天天看点

ZENCART 重新安装时出现1064错误

Installation In Progress...

1064 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' at line 1

in:

[CREATE TABLE upgrade_exceptions ( upgrade_exception_id smallint(5) NOT NULL auto_increment, sql_file varchar(50) default NULL, reason varchar(200) default NULL, errordate datetime default '0001-01-01 00:00:00', sqlstatement text, PRIMARY KEY (upgrade_exception_id) ) TYPE=MyISAM;]

最近我的虚拟主机那边有更换主机,现在MySQL version:5.5.29-log,之前的版本应该是5.5.22-cll

请问是不是不兼容的缘故,要怎么处理呢,我用的是1.3.8a的zencart

将安装程序包的TYPE=MyISAM 全部改成ENGINE=MyISAM

继续阅读