Localhost Testing Setup: Installing Modx on laptop

Hi guys

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.

Many thanks

I think you’ll have to modify the setup.sql, found in the install folder:
install/setup.sql

change
TYPE=MyISAM
to
ENGINE=MyISAM

rerun the installer and all should be good.

Hot damn! I love the ModX community.

Works a treat now - many thanks!

Spoke too soon!

The manager is working fine now but when I add a new template it treats my html like php and escapes all my quotes like so:

<img src=\"http://localhost/assets/templates/standard/img/logo_small.jpg\" width=\"90\" height=\"90\" />

When I close and open the template they have multiplied x 3 e.g.

height=\\\"90\\\"

Any ideas on this one?
My localhost is running on uniserver.

Many thanks

Looks like Magic Quotes is set to on