- A+
所属分类:网络技术
ALTER TABLE `pre_common_member_grouppm` ENGINE = INNODB;
ALTER TABLE `pre_forum_post` ENGINE = INNODB;
[Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as
首先在sql下单个运行一下需要修改的数据库条目
ALTER TABLE pre_forum_postposition DROP PRIMARY KEY,ADD PRIMARY KEY(position,tid);
ALTER TABLE pre_common_member_grouppm DROP PRIMARY KEY,ADD PRIMARY KEY(gpmid,uid);
ALTER TABLE pre_forum_post DROP PRIMARY KEY,ADD PRIMARY KEY(position,tid);
再执行
ALTER TABLE `pre_common_member_grouppm` ENGINE = INNODB;
ALTER TABLE `pre_forum_post` ENGINE = INNODB;
完美解决
本文为原创,如需转载,请标注本文来自:www.fourye.com四爷技术网