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.