.........................
Discuz! info: MySQL Query Error
Time: 2005-12-13 2:52pm
Script: /bbs/upgrade25to4.php
SQL: ALTER TABLE cdb_members DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identifying,
CHANGE username username char(15) NOT NULL default '',
CHANGE adminid adminid TINYINT( 1 ) DEFAULT '0' NOT NULL,
CHANGE password password char(32) NOT NULL default '',
CHANGE secques secques char(8) NOT NULL default '',
CHANGE regip regip char(15) NOT NULL default '',
CHANGE lastip lastip char(15) NOT NULL default '',
CHANGE email email char(50) NOT NULL default '',
CHANGE dateformat dateformat char(10) NOT NULL default '',
CHANGE timeformat timeformat tinyint(1) NOT NULL default '0',
CHANGE signature sigstatus tinyint(1) NOT NULL default 0,
CHANGE postnum posts MEDIUMINT(8) UNSIGNED NOT NULL default '0',
CHANGE credit credits int(10) NOT NULL,
CHANGE showemail showemail tinyint(1) NOT NULL default '0',
CHANGE timeoffset timeoffset CHAR(4) NOT NULL,
ADD digestposts SMALLINT(6) UNSIGNED NOT NULL AFTER posts,
ADD groupexpiry INT(10) UNSIGNED NOT NULL AFTER groupid,
ADD pmsound TINYINT(1) NOT NULL AFTER timeformat,
CHANGE extracredit extcredits1 int(10) NOT NULL,
ADD extcredits5 int(10) NOT NULL AFTER extcredits1,
ADD extcredits4 int(10) NOT NULL AFTER extcredits1,
ADD extcredits3 int(10) NOT NULL AFTER extcredits1,
ADD extcredits2 int(10) NOT NULL AFTER extcredits1,
ADD extgroupids char(60) NOT NULL AFTER groupexpiry,
ADD avatarshowid int(10) UNSIGNED NOT NULL default '0' AFTER extcredits5,
ADD extcredits8 int(10) NOT NULL AFTER extcredits5,
ADD extcredits7 int(10) NOT NULL AFTER extcredits5,
ADD extcredits6 int(10) NOT NULL AFTER extcredits5,
ADD pageviews mediumint(8) UNSIGNED NOT NULL AFTER digestposts,
ADD oltime smallint(6) UNSIGNED NOT NULL AFTER digestposts,
DROP INDEX username,
ADD UNIQUE (username),
ADD INDEX (email)
Error: Duplicate column name 'pmsound'
Errno.: 1060
Similar error report has beed dispatched to administrator before. |