Errors due to repository table names using reserved keyword in MySQL

[Raul Ramirez]

Hello Schedulix Group,

Getting an error trying to restart Schedulix on an upgraded backend MySQL database where both the GROUPS and MEMBER tables are now considered reserved keywords according to https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-0.html

ERROR   [Thread-1]      31 Jan 2024 16:56:33 GMT SQL Error :  You have an error in your SQL syntax; check manual that corresponds to your MySQL server version for the right syntax to use near 'GROUPS' at line 1

I tried adding back-tick quotes to the tables the init.sql files below without success:

/usr/bin/schedulix/sql/init.sql

/usr/bin/schedulix/sql/mysql/init.sql

I suspect the issue is somewhere else since those init.sql files seem to be needed to initialize a new installation. That is, they do have specific insert values into the tables.

Stack:

Schedulix 2.9

MySQL 8.0.33

Amazon Linux AMI

My coworker Andrew Keddell suggested that I reached out to this group. He has been helped in the past by the group.

Kind regards,

Raul

[Ronald Jeninga]

Hi Raul,

as a matter of fact we've fixed that (AFAIK) quite a while ago.

Which would mean that you are running a 2.9 that is pretty old.

I've compiled a schedulix 2.9 and I've uploaded the jar file to our server.

You can download it from

https://www.independit.de/Downloads/Raul/BICsuite.jar

And in order to check if the download was successful:

ronald@oncilla:~/schedulix-2.9/lib$ md5sum BICsuite.jar
7fb4a8330bcdcece69e961879177b8bc  BICsuite.jar

After downloading it, you replace $BICSUITEHOME/lib/BICsuite.jar with the downloaded file.

After that, your server should start.

But if I'm mistaken, please notify me and I'll investigate more in depth what is going wrong.

Best regards,

Ronald

[Raul Ramirez]

I am really impressed with how quickly I got a response.

I'll try the new JAR file and will let you know how it goes. Thank you Ronald.

Raul

[Raul Ramirez]

Good news Ronald. The server was able to start pointed to MySQL 8 DB and is running just fine with the new JAR file.

Thank you.

Raul

[Ronald Jeninga]

Hi Raul,

thank you very much for the feedback! 

I'm glad I could help.

Best regards,

Ronald