安装程序时 “向数据库写入数据时发生错误!”

 

安装程序时 “向数据库写入数据时发生错误!”

数据库访问错误 CREATE TABLE cws_categories ( categoryid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, parentid INT(10) UNSIGNED NOT NULL DEFAULT 0, designid INT(10) UNSIGNED NOT NULL DEFAULT 0, name VARCHAR(64) NOT NULL DEFAULT '', urlname VARCHAR(64) NOT NULL DEFAULT '', displayorder INT(10) UNSIGNED NOT NULL DEFAULT 0, link VARCHAR(128) NOT NULL DEFAULT '', target VARCHAR(10) NOT NULL DEFAULT '', menuwidth SMALLINT UNSIGNED NOT NULL DEFAULT 0, nolink TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (categoryid), KEY displayorder (displayorder) ) TYPE=MyISAM; 错误内容: 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 14 错误代码: 1064 时间: Wednesday 22nd 2011f June 2011 07:40:59 AM 文件: http://localhost/sf/install/model.php(undefined : )  

将 TYPE=MyISAM 替换成 ENGINE=MyISAM 即可，在createDB。php文件

转载于:https://www.cnblogs.com/zhouwenwu/archive/2012/04/05/2432680.html