...
For this, a CREATE TABLE statement ends with TYPh1. TYPE= InnoDB in MySQL 4 and with ENGINEInnoDB ENGINE=InnoDB in MySQL 5.
Until MySQL 5.4 was Type=InnoDB as far backward compatible, but since MySQL 5.5 an error is thrown.
We have therefore modified the SQL statements to ENGINEInnoDB ENGINE=InnoDB for Job Scheduler releases > 1.3.10.1132.
MySQL 4 user gets a database error during the setup for Job Scheduler releases > 1.3.10.1132
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 'Engine=InnoDB'
In this case you must change in all SQL files (./db/mysql/*.sql) the ENGINE=InnoDB to TYPEInnoDB and start the ./install/scheduler_install_tables.(cmd|sh) script.
MySQL >= 5.5 user gets a database error during the setup for Job Scheduler releases <= 1.3.10.1132
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 'Type=InnoDB'
...