bdaloukas/moodle-mod_game

Error in SQL syntax during install

Closed this issue · 4 comments

tpv-ebben commented

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

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

there is another instance in snake_database, working on pull request

bdaloukas commented

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

tpv-ebben commented

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