We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Creating database tables: Database Alerts! - WIN2003

    • 17797
    • 4 Posts
    Ma Reply #1, 13 years, 2 months ago
    Hi

    I try to install modx in IIS6 with MySQL 5.5.9 and PHP 5.3.5
    I have Windows server 2003

    All goes fin but with Install results
    can i see this fail:
    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.'


    and more text

    /Ma
    • sottwell Reply #2, 13 years, 2 months ago
      Your MySQL version doesn’t like the TYPE keyword; this needs to be changed to ENGINE in the .sql file for installing.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 17797
        • 4 Posts
        Ma Reply #3, 13 years, 2 months ago
        in setup.sql ?

          • 17797
          • 4 Posts
          Ma Reply #4, 13 years, 2 months ago
          I try to edit setup.sql and the install work fine but now work modx not. Se ma.jdh.dk/rc for fails
          Quote from: sottwell at Feb 19, 2011, 08:14 AM

          Your MySQL version doesn’t like the TYPE keyword; this needs to be changed to ENGINE in the .sql file for installing.
            • 17797
            • 4 Posts
            Ma Reply #5, 13 years, 2 months ago
            Help?
              • 34901
              • 3 Posts
              fxb Reply #6, 12 years, 11 months ago
              Hello,

              It is not working because of TYPE=MyISAM, therefore in install/setup.sql you need to replace TYPE by ENGINE.

              Enjoy

              Note :For Linux user it is also working with XAMPP for Linux 1.7.4 !

                • 7391
                • 49 Posts
                digitalmaster Reply #7, 12 years, 7 months ago
                Worked like a charm!