discuz mysql query error_Discuz! info: MySQL Query Error

Time:2006-8-207:14amScript:SQL:CREATETABLEcdb_memberfields(uidmediumint(8)unsignedNOTNULLdefault'0',nicknamevarchar(30)NOTNULLdefault'',sitevarchar(75)NOTNULLdefault'',al...

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.

展开