Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

无法写入资料表

[复制链接]
loveyou520tw 发表于 2017-2-14 11:37:45 | 显示全部楼层 |阅读模式

目前遇到很奇怪的问题,全新安装却无法写入pre_forum_post与pre_common_member_grouppm导致目前于发文与搜寻

MySQL版本:5.6&5.7
伺服器:Ubuntu16.04LTS
主机:Google Cloud Console

错误讯息
run_sql_error
SQL:CREATE TABLE pre_common_member_grouppm ( uid mediumint(8) unsigned NOT NULL DEFAULT '0', gpmid smallint(6) unsigned NOT NULL AUTO_INCREMENT, `status` tinyint(1) NOT NULL DEFAULT '0', dateline int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (uid,gpmid)) ENGINE=MYISAM DEFAULT CHARSET=utf8
Error:Incorrect table definition; there can be only one auto column and it must be defined as a key
Errno:1075

run_sql_error
SQL:CREATE TABLE pre_forum_post ( pid int(10) unsigned NOT NULL, fid mediumint(8) unsigned NOT NULL DEFAULT '0', tid mediumint(8) unsigned NOT NULL DEFAULT '0', `first` tinyint(1) NOT NULL DEFAULT '0', author varchar(15) NOT NULL DEFAULT '', authorid mediumint(8) unsigned NOT NULL DEFAULT '0', `subject` varchar(80) NOT NULL DEFAULT '', dateline int(10) unsigned NOT NULL DEFAULT '0', message mediumtext NOT NULL, useip varchar(15) NOT NULL DEFAULT '', `port` smallint(6) unsigned NOT NULL DEFAULT '0', invisible tinyint(1) NOT NULL DEFAULT '0', anonymous tinyint(1) NOT NULL DEFAULT '0', usesig tinyint(1) NOT NULL DEFAULT '0', htmlon tinyint(1) NOT NULL DEFAULT '0', bbcodeoff tinyint(1) NOT NULL DEFAULT '0', smileyoff tinyint(1) NOT NULL DEFAULT '0', parseurloff tinyint(1) NOT NULL DEFAULT '0', attachment tinyint(1) NOT NULL DEFAULT '0', rate smallint(6) NOT NULL DEFAULT '0', ratetimes tinyint(3) unsigned NOT NULL DEFAULT '0', `status` int(10) NOT NULL DEFAULT '0', tags varchar(255) NOT NULL DEFAULT '0', `comment` tinyint(1) NOT NULL DEFAULT '0', replycredit int(10) NOT NULL DEFAULT '0', position int(8) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (tid,position), UNIQUE KEY pid (pid), KEY fid (fid), KEY authorid (authorid,invisible), KEY dateline (dateline), KEY invisible (invisible), KEY displayorder (tid,invisible,dateline), KEY `first` (tid,`first`)) ENGINE=MYISAM DEFAULT CHARSET=utf8
Error:Incorrect table definition; there can be only one auto column and it must be defined as a key
Errno:1075

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-11-27 21:54 , Processed in 0.013877 second(s), 3 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表