MODX :: Creating database tables: Database Alerts!

4

Ma Reply #1, 1 year, 3 months ago

Link to this post#1

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

15,092

How MODx Evo Works

Log in to an Evo Manager username guest, password guestuser.

sottwell Reply #2, 1 year, 3 months ago

Link to this post#2

Your MySQL version doesn't like the TYPE keyword; this needs to be changed to ENGINE in the .sql file for installing.

4

Ma Reply #3, 1 year, 3 months ago

Link to this post#3

in setup.sql ?

4

Ma Reply #4, 1 year, 2 months ago

Link to this post#4

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, 02:14 AM

Your MySQL version doesn't like the TYPE keyword; this needs to be changed to ENGINE in the .sql file for installing.

4

Ma Reply #5, 1 year, 2 months ago

Link to this post#5

Help?

3

fxb Reply #6, 11 months, 2 weeks ago

Link to this post#6

Hello,

It is not working because ofyISAM, 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 !