ColdFusion cluster scheduled tasks

[mikeweb85]

I am having issues enabling scheduled tasks in ColdFusion 10. I have go so far as to set MySQL (5.1.73) to use lower case table names and be case insensitive in comparison.  After that didnt work, i dropped the databse and ran `tables_mysql_innodb.sql` (C:\ColdFusion10\cfusion\lib\quartz\scripts) and trien to enable schedule task clustering and continue to recieve this error message: `Error while creating tables for cluster setup for datasource cf_tasks. Verify the connection. The supported databases for cluster setup are MySQL, Microsoft SQL Server and Oracle'. I didn't have the `Create Tables for Cluster Setup` option selected.

[mikeweb85 · Accepted solution]

nevermind. the INNODB.sql file packaged with CF10 was in complete. Combine the table struction from the MyISAM version with INNODB and boom.