本帖最后由 mhjl2006 于 2009-9-17 18:18 编辑
升级表 mm_styles 出错,请手工执行以下升级语句后,再重新运行本升级程序:
升级SQL语句: ALTER TABLE mm_styles ADD `tplid` smallint(6) unsigned NOT NULL auto_increment, ADD `tplname` varchar(80) NOT NULL default '', ADD `tplnote` text NOT NULL, ADD `tpltype` varchar(20) default NULL, ADD `tplfilepath` varchar(80) NOT NULL default '', DROP PRIMARY KEY, ADD PRIMARY KEY (tplid), ADD INDEX `tpltype` (tpltype)
Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
Errno.: 1075
我手工升级STYLES也是
提示信息 | Incorrect table definition; there can be only one auto column and it must be defined as a key |
重复升级3次到那里卡住了……请问我该怎么办啊? |