Skip to end of metadata
Go to start of metadata

The Job Scheduler needs InnoDB tables.

For this, a CREATE TABLE statement ends with TYPE= InnoDB in MySQL 4 and with 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 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'

In this case you must change in all SQL files (./db/mysql/*.sql) the TYPE=InnoDB to ENGINEInnoDB.

Furthermore, missing four CREATE TABLE statements.

Insert the following CREATE TABLEs to ./db/mysql/scheduler.sql:

Start the ./install/scheduler_install_tables.(cmd|sh) script.