在 WAMP 安装 Modx 1.0.5 错误
我尝试在我的 WAMP 服务器上安装 modx 1.0.5，使用此规范
- PHP v5.2.11
- MySQL v5.5.8
- OS Win 7
，这是我得到的错误
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.'.
，因为它太长了，我没有输入所有信息错误。
这对我来说似乎很奇怪，因为我的朋友将其安装在 XAMPP 服务器上并且安装运行正确。我的 WAMP 服务器的某些配置是否会导致安装失败？
由于我的 WAMP 配置没有太大变化，除了在 Apache 中启用 rewriteEngine 并添加 PHP 5.2.11 版本
提前谢谢
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
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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
快速搜索一下，
TYPE不再受支持，而且已经很长时间了。它应该是ENGINE=MyISAMhttp://dev.mysql.com/doc/refman/5.5/en/show-create-table.html
为什么这是安装程序的一部分尚未确定。
更新
我已经提交了一个错误 #4156
您可以同时尝试此解决方法 - http://modxcms.com/forums/index.php?topic=60964。新;topicseen#new
From a quick search,
TYPEis no longer supported and hasn't been for a very long time. It should beENGINE=MyISAMhttp://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