On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
Subscribe: RSS
  • 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.
        xforum
        http://frsbuilders.net (under construction) forum for evolution
      • 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