Geting this error in both version 6.5 and 7.3 during installation.. Using WAMP with following config
Apache 2.4.41
PHP 7.3.12
MySQL 8.0.18 Port 3308
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank NUMERIC; declare cur1 cursor for select mp.markingperiodid, ' at line 9
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I had the same problem with MySQL 8. To resolve, I had to use MySQL 5.7 instead. Also, I was able to install using MariaDB 10.23 (the non-Oracle fork of MySQL).
Something in the SQL syntax is not compatible with version 8 of MySQL, but the syntax is accepted by MySQL 5.7 and MariaDB 10.
This is because in the install/OpensisProcsMysqlInc.sql file the rank is declared as numeric, but in newer versions of MySQL this is a reserved word (RANK (R); added in 8.0.2 (reserved))
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Geting this error in both version 6.5 and 7.3 during installation.. Using WAMP with following config
Apache 2.4.41
PHP 7.3.12
MySQL 8.0.18 Port 3308
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank NUMERIC; declare cur1 cursor for select mp.markingperiodid, ' at line 9
hi, any luck on this one?
I had the same problem with MySQL 8. To resolve, I had to use MySQL 5.7 instead. Also, I was able to install using MariaDB 10.23 (the non-Oracle fork of MySQL).
Something in the SQL syntax is not compatible with version 8 of MySQL, but the syntax is accepted by MySQL 5.7 and MariaDB 10.
Maria download at: https://mariadb.org/
This is because in the install/OpensisProcsMysqlInc.sql file the rank is declared as numeric, but in newer versions of MySQL this is a reserved word (RANK (R); added in 8.0.2 (reserved))