Windows Server R2
MySQL Workbench 6.1
I'm installing Evolution 1.0.5 so that I can pull over our current site and then upgrade it, but when I try to install this version of modx on my site I get this error (only showing 1st paragraph, the rest is in the attachment)
Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting database `modx`: OK!
Checking table prefix `modx_`: OK!
Creating database tables: Database Alerts!
MODx setup couldn't install/alter some tables inside the selected database.
The following errors had occurred during installation
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.'.
what am I doing wrong on this install that it is not installing?
my modx revolution install I took off was working fine before this