I had this problem and it turns out that XAMPP (at least the windows version) had InnoDB disabled by default. Before being able to convert to InnoDB I had to enable it within the my.cnf file and restart MySQL.
The my.cnf file is located in the mysql\bin folder within the xampp install folder. You need to find the following:
Code: Select all
skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:/xampp/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/xampp/mysql/data/
#innodb_log_arch_dir = C:/xampp/mysql/data/
Code: Select all
# skip-innodb
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = C:/xampp/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:/xampp/mysql/data/
innodb_log_arch_dir = C:/xampp/mysql/data/
Anyway, it took me a while to figure out what was going on so I decided to post this in case it helps anyone else out. I have a feeling if I made the above changes before installing TimeTrex, all the tables would have been created as InnoDB to begin with.