Trying to install modx evo locally and all goes well. Get all of the okâ€™s during setup then get the following message at the Install Results page:
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=MyISAM COMMENT=â€™Contains data about active users.â€™â€™ at line 9 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_active_users` ( `internalKey` int(9) NOT NULL default â€™0â€™, `username` varchar(50) NOT NULL default â€™â€™, `lasthit` int(20) NOT NULL default â€™0â€™, `id` int(10) default NULL, `action` varchar(10) NOT NULL default â€™â€™, `ip` varchar(20) NOT NULL default â€™â€™, PRIMARY KEY (`internalKey`) ) TYPE=MyISAM COMMENT=â€™Contains data about active users.â€™.
I get one of these for every table I think. When I look in phpMyAdmin there are no tables at all.
On the previous page I have the check:
Checking MySQL version: OK! Your MySQL version is: 5.5.9
Help would be much appreciated - I have no idea how to address this problem.