开发者

Install Modx 1.0.5 Error at WAMP

开发者 https://www.devze.com 2023-02-19 22:50 出处:网络
I try to install modx 1.0.5 on my WAMP server with this specification PHP v5.2.11 MySQL v5.5.8 OS Win 7 and this is the error i get

I try to install modx 1.0.5 on my WAMP server with this specification

  1. PHP v5.2.11
  2. MySQL v5.5.8
  3. OS Win 7

and this is the error i get

Install results

Setup will now attempt to setup the database:

Creating connection to the database: OK!

Selecting database `modx105`: 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.'.

i didn't put all the information error, since its too long.

Is seems strange for me, since my friend install this on XAMPP server and the install run correctly. Is there maybe some configuration of my WAMP server make开发者_开发知识库 this installation failure?

Since my WAMP Configuration is not much change except enable rewriteEngine in Apache and add PHP 5.2.11 version

Thank you in advance


From a quick search, TYPE is no longer supported and hasn't been for a very long time. It should be ENGINE=MyISAM

http://dev.mysql.com/doc/refman/5.5/en/show-create-table.html

Why this is part of the installer is yet to be determined.

Update

I've filed a bug #4156

You can try this workaround in the meantime - http://modxcms.com/forums/index.php?topic=60964.new;topicseen#new

0

精彩评论

暂无评论...
验证码 换一张
取 消