湖南金鹰节2017:Discuz! info: MySQL Query Error

来源:百度文库 编辑:高校问答 时间:2024/04/29 07:39:58
Time: 2006-8-20 7:14am
Script:

SQL: CREATE TABLE cdb_memberfields ( uid mediumint(8) unsigned NOT NULL default '0', nickname varchar(30) NOT NULL default '', site varchar(75) NOT NULL default '', alipay varchar(50) NOT NULL default '', icq varchar(12) NOT NULL default '', qq varchar(12) NOT NULL default '', varchar(40) NOT NULL default '', msn varchar(40) NOT NULL default '', taobao varchar(40) NOT NULL default '', location varchar(30) NOT NULL default '', customstatus varchar(30) NOT NULL default '', medals varchar(255) NOT NULL default '', avatar varchar(255) NOT NULL default '', avatarwidth tinyint(3) unsigned NOT NULL default '0', avatarheight tinyint(3) unsigned NOT NULL default '0', bio text NOT NULL, signature text NOT NULL, sightml text NOT NULL, ignorepm text NOT NULL, groupterms text NOT NULL, authstr varchar(20) NOT NULL default '', PRIMARY KEY (uid)) ENGINE=MYISAM DEFAULT CHARSET=gbk
Error: 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 'varchar(40) NOT NULL default '', msn varchar(40) NOT NULL default '', taobao v' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

Error: 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 'varchar(40) NOT NULL default '', msn varchar(40) NOT NULL default '', taobao v' at line 1

说你的SQL语句有语法错误

CREATE TABLE cdb_memberfields
( uid mediumint(8) unsigned NOT NULL default '0',
nickname varchar(30) NOT NULL default '',
site varchar(75) NOT NULL default '',
alipay varchar(50) NOT NULL default '',
icq varchar(12) NOT NULL default '',
qq varchar(12) NOT NULL default '',

xxxx varchar(40) NOT NULL default '',
~~~~ 缺少一个表中的字段名,但是我不知道应该是什么

msn varchar(40) NOT NULL default '',
taobao varchar(40) NOT NULL default '',
location varchar(30) NOT NULL default '',
customstatus varchar(30) NOT NULL default '',
medals varchar(255) NOT NULL default '',
avatar varchar(255) NOT NULL default '',
avatarwidth tinyint(3) unsigned NOT NULL default '0',
avatarheight tinyint(3) unsigned NOT NULL default '0',
bio text NOT NULL,
signature text NOT NULL,
sightml text NOT NULL, ignorepm text NOT NULL,
groupterms text NOT NULL,
authstr varchar(20) NOT NULL default '',
PRIMARY KEY (uid))
ENGINE=MYISAM DEFAULT CHARSET=gbk

缺少一个字段名,你随便给一个试试,不行的话Q我 188925047