We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 47809
    • 7 Posts
    Windows Server R2
    IIS 8.5
    PHP 5.5.11
    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)

    Install results

    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