We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 32675
    • 1 Posts
    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
      • 4041
      • 788 Posts
      I think you’ll have to modify the setup.sql, found in the install folder:


      rerun the installer and all should be good.
        http://frsbuilders.net (under construction) forum for evolution
        • 32675
        • 1 Posts
        Hot damn! I love the ModX community.

        Works a treat now - many thanks!
          • 32675
          • 1 Posts
          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.

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

          Many thanks
            • 4310
            • 2,310 Posts
            Looks like Magic Quotes is set to on