网站升级过程中出现Discuz! Database Error (1050)

00:00:00

您有一张10元限时体验卡，马上领取获得VIP尊享特权。

DZ插件网 › Discuz! AI文库 › Discuz!问题求助 › 网站升级过程中出现Discuz! Database Error (1050)

2022-3-8 13:28 来自婷姐发布 @ Discuz!问题求助

Discuz! Database Error(1050) Table 'common_member_profile_history' already exists
REATE TABLE common_member_profile_history ( hid int(10) unsigned NOT NULL AUTO_INCREMENT, uid mediumint(8) unsigned NOT NULL, realname varchar(255) NOT NULL DEFAULT '', gender tinyint(1) NOT NULL DEFAULT '0', birthyear smallint(6) unsigned NOT NULL DEFAULT '0', birthmonth tinyint(3) unsigned NOT NULL DEFAULT '0', birthday tinyint(3) unsigned NOT NULL DEFAULT '0', constellation varchar(255) NOT NULL DEFAULT '', zodiac varchar(255) NOT NULL DEFAULT '', telephone varchar(255) NOT NULL DEFAULT '', mobile varchar(255) NOT NULL DEFAULT '', idcardtype varchar(255) NOT NULL DEFAULT '', idcard varchar(255) NOT NULL DEFAULT '', address varchar(255) NOT NULL DEFAULT '', zipcode varchar(255) NOT NULL DEFAULT '', nationality varchar(255) NOT NULL DEFAULT '', birthcountry varchar(255) NOT NULL DEFAULT '', birthprovince varchar(255) NOT NULL DEFAULT '', birthcity varchar(255) NOT NULL DEFAULT '', birthdist varchar(20) NOT NULL DEFAULT '', birthcommunity varchar(255) NOT NULL DEFAULT '', residecountry varchar(255) NOT NULL DEFAULT '', resideprovince varchar(255) NOT NULL DEFAULT '', residecity varchar(255) NOT NULL DEFAULT '', residedist varchar(20) NOT NULL DEFAULT '', residecommunity varchar(255) NOT NULL DEFAULT '', residesuite varchar(255) NOT NULL DEFAULT '', graduateschool varchar(255) NOT NULL DEFAULT '', company varchar(255) NOT NULL DEFAULT '', education varchar(255) NOT NULL DEFAULT '', occupation varchar(255) NOT NULL DEFAULT '', position varchar(255) NOT NULL DEFAULT '', revenue varchar(255) NOT NULL DEFAULT '', affectivestatus varchar(255) NOT NULL DEFAULT '', lookingfor varchar(255) NOT NULL DEFAULT '', bloodtype varchar(255) NOT NULL DEFAULT '', height varchar(255) NOT NULL DEFAULT '', weight varchar(255) NOT NULL DEFAULT '', alipay varchar(255) NOT NULL DEFAULT '', icq varchar(255) NOT NULL DEFAULT '', qq varchar(255) NOT NULL DEFAULT '', yahoo varchar(255) NOT NULL DEFAULT '', msn varchar(255) NOT NULL DEFAULT '', taobao varchar(255) NOT NULL DEFAULT '', site varchar(255) NOT NULL DEFAULT '', bio text NOT NULL, interest text NOT NULL, field1 text NOT NULL, field2 text NOT NULL, field3 text NOT NULL, field4 text NOT NULL, field5 text NOT NULL, field6 text NOT NULL, field7 text NOT NULL, field8 text NOT NULL, dateline int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (hid)) ENGINE=InnoDB;