search

bdaloukas / moodle-mod_game

moodle-mod_game
GNU General Public License v3.0
15 stars 40 forks source link

Error in SQL syntax during install #17

Closed tpv-ebben closed 6 years ago

tpv-ebben commented 7 years ago

Error: Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows SMALLINT(3), words SMALLINT(3), wordsall BIGINT(10), createscor' at line 4

Gist with complete error

Moodle 3.3 MariaDB 10.2 mod_game commit 6ee163b, also same error with stable version

bdaloukas commented 7 years ago

Last beta version fixes the above problem. Now the field is named "createdrows" instead "rows". "Rows" is a reserved word now in MariaDB.

tpv-ebben commented 7 years ago

there is another instance in snake_database, working on pull request

bdaloukas commented 7 years ago

I changed the table game_snakes_database also. See the last stable release.

tpv-ebben commented 6 years ago

This is happening again with the latest version, Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows SMALLINT(3) DEFAULT 0 AFTER id' at line 1 ALTER TABLE mdl_game_cross ADD rows SMALLINT(3) DEFAULT 0 AFTER id Error code: ddlexecuteerror