The Job Scheduler needs InnoDB tables.
For this, a CREATE TABLE statement ends with TYPh1. InnoDB in MySQL 4 and with ENGINEInnoDB in MySQL 5.
Until MySQL 5.4 was Typeh1. InnoDB as far backward compatible, but since MySQL 5.5 an error is thrown.
We have therefore modified the SQL statements to ENGINEInnoDB for Job Scheduler releases > 1.3.10.1132.
Who still uses MySQL4 gets a database error during setup:
ERROR 1064 (00000): 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 ENGINh1. InnoDB to TYPEInnoDB and start the ./install/scheduler_install_tables.(cmd|sh) script.