升级成8.0后发贴出现了一个问题

楼主
升级成8.0后发贴出现了一个问题
[FACE=宋体][SIZE=12px]升级成8.0后发贴时,下面出现一个错误,显示以下SQL语句执行出错,程序意外中止,请问这是怎么回事?谢谢![/SIZE][/FACE][P][FACE=宋体][SIZE=12px]
[/SIZE][/FACE][/P]
[upload=16162,0]网站出错.PNG[/upload]
1楼
[P]试着在后台执行以下三个语句(分三次执行):[/P][P]ALTER TABLE leadbbs_applogin ADD COLUMN Token TEXT(64)
ALTER TABLE leadbbs_applogin ADD COLUMN ExpiresTime DOUBLE
ALTER TABLE leadbbs_applogin ADD COLUMN Retention1 TEXT(64)[/P][P]正确完成以下语句也试着执行(注意一行执行一次而不是全部一起执行,前面的先执行,有前后顺序)[/P][P]
alter table leadbbs_applogin alter column Token varchar(128)
DROP INDEX IX_LeadBBS_AppLogin_UserID ON LeadBBS_AppLogin
CREATE INDEX IX_LeadBBS_AppLogin_UserID ON LeadBBS_AppLogin(UserID,appType)
update leadbbs_applogin set ExpiresTime=0 where ExpiresTime is null[/P][P]update leadbbs_applogin set Token='' where Token is null[/P][P]AlterTableColumn###leadbbs_applogin###Token###Default###''[/P][P]
[/P]
2楼
[P]内网的数据库也可在后台强行执行数据库语句来完成,然后将除数据库外的文件手工替换为9.2的也行。[/P][P]数据库升级语句如下(access):[/P][P]
[/P][P]ALTER TABLE leadbbs_link ALTER COLUMN sitename Memo[/P][P]ALTER TABLE leadbbs_applogin ADD COLUMN Token TEXT(64)
ALTER TABLE leadbbs_applogin ADD COLUMN ExpiresTime DOUBLE
ALTER TABLE leadbbs_applogin ADD COLUMN Retention1 TEXT(64)[/P][P]
[/P][P]
[/P][P]ALTER TABLE article_newsarticle ADD COLUMN htmlflag SmallInt
ALTER TABLE article_newsarticle_hide ADD COLUMN htmlflag SmallInt
ALTER TABLE article_newsclass ADD COLUMN classname_side varchar(255)
AlterTableColumn###article_newsarticle###htmlflag###Default###2
AlterTableColumn###article_newsarticle_hide###htmlflag###Default###2
AlterTableColumn###article_newsclass###classname_side###Default###''
Create TABLE LeadBBS_extend(ID AUTOINCREMENT,ClassType Long,extendID Long,extent_title text(255),extent_content Memo,extent_num Long,extent_num2 Long,extent_level Long,PRIMARY KEY(ID))
CREATE INDEX [IX_LeadBBS_extend_extentID] ON [LeadBBS_extend] ( [ClassType] ASC, [extendID] ASC, [ID] ASC)
CREATE INDEX [IX_LeadBBS_extend_level] ON [LeadBBS_extend] ( [ClassType] ASC, [extent_level] ASC, [extendID] ASC, [ID] ASC)
CREATE INDEX IX_LeadBBS_User_Truename ON LeadBBS_User(TrueName)
AlterTableColumn###LeadBBS_extend###ClassType###Default###0
AlterTableColumn###LeadBBS_extend###extendID###Default###0
AlterTableColumn###LeadBBS_extend###extent_title###Default###''
AlterTableColumn###LeadBBS_extend###extent_content###Default###''
AlterTableColumn###LeadBBS_extend###extent_num###Default###0
AlterTableColumn###LeadBBS_extend###extent_num2###Default###0
AlterTableColumn###LeadBBS_extend###extent_level###Default###0
alter table leadbbs_announce alter column LastUser varchar(50)
alter table leadbbs_announce_hide alter column LastUser varchar(50)
alter table leadbbs_topic alter column LastUser varchar(50)
alter table leadbbs_topic_hide alter column LastUser varchar(50)
alter table leadbbs_boards alter column LastWriter varchar(50)
CREATE INDEX IX_LeadBBS_Announce_OnlyTopicUser ON LeadBBS_Announce(RootIDBak,UserID,ID)
update leadbbs_announce set layer=0 where parentid>0
update leadbbs_announce set topicsortid=0 where topicsortid<>0
ALTER TABLE LeadBBS_Boards ADD COLUMN BoardIntro2 memo
AlterTableColumn###LeadBBS_Boards###BoardIntro2###Default###''
ALTER TABLE LeadBBS_user ADD COLUMN remark memo
AlterTableColumn###LeadBBS_user###remark###Default###''
alter table leadbbs_applogin alter column Token varchar(128)
DROP INDEX IX_LeadBBS_AppLogin_UserID ON LeadBBS_AppLogin
CREATE INDEX IX_LeadBBS_AppLogin_UserID ON LeadBBS_AppLogin(UserID,appType)
CREATE INDEX IX_LeadBBS_extend_ClassType ON LeadBBS_extend(ClassType,ID DESC)
CREATE INDEX IX_LeadBBS_User_MobileTel ON LeadBBS_User(MobileTel,ID)
alter table LeadBBS_SpecialUser alter column UserName varchar(60)[/P][P]Create TABLE LeadBBS_Plugs(ID AUTOINCREMENT,Name text(255), ClassID Long,url text(255), width Long, height Long,intro Memo, sortid Long,plugkey text(128),createtime decimal,remark Memo,PRIMARY KEY(ID))
CREATE INDEX IX_LeadBBS_Plugs_ClassID ON LeadBBS_Plugs(ClassID,sortid,ID)
CREATE INDEX IX_LeadBBS_Plugs_plugkey ON LeadBBS_Plugs(plugkey,ID)
Create TABLE LeadBBS_plug_class(ID AUTOINCREMENT,Name text(100), ParentID Long, Num Long, remark Memo, sortid Long,PRIMARY KEY(ID))
CREATE INDEX IX_LeadBBS_plug_class_ParentID ON LeadBBS_plug_class(ParentID,ID)
CREATE INDEX IX_LeadBBS_plug_class_sortid ON LeadBBS_plug_class(sortid,ID)
AlterTableColumn###LeadBBS_plug_class###Name###Default###''
AlterTableColumn###LeadBBS_plug_class###ParentID###Default###0
AlterTableColumn###LeadBBS_plug_class###Num###Default###0
AlterTableColumn###LeadBBS_plug_class###remark###Default###''
AlterTableColumn###LeadBBS_plug_class###sortid###Default###0
AlterTableColumn###LeadBBS_Plugs###sortid###ClassID###0
AlterTableColumn###LeadBBS_Plugs###width###Default###0
AlterTableColumn###LeadBBS_Plugs###height###Default###0
AlterTableColumn###LeadBBS_Plugs###intro###Default###''
AlterTableColumn###LeadBBS_Plugs###sortid###Default###0
AlterTableColumn###LeadBBS_Plugs###plugkey###Default###''
AlterTableColumn###LeadBBS_Plugs###createtime###Default###0
AlterTableColumn###LeadBBS_Plugs###remark###Default###''[/P][P]ALTER TABLE leadbbs_upload ADD COLUMN FileName varchar(50)
ALTER TABLE leadbbs_upload ADD COLUMN FileSize Long
ALTER TABLE leadbbs_upload ADD COLUMN announceid Long
ALTER TABLE leadbbs_upload ADD COLUMN boardid Long
ALTER TABLE leadbbs_upload ADD COLUMN Info varchar(30)
ALTER TABLE leadbbs_upload ADD COLUMN VisitIP varchar(50)
ALTER TABLE leadbbs_upload ADD COLUMN hits Long
AlterTableColumn###leadbbs_upload###FileName###Default###''
AlterTableColumn###leadbbs_upload###Info###Default###''
AlterTableColumn###leadbbs_upload###VisitIP###Default###''
AlterTableColumn###leadbbs_upload###FileSize###Default###0
AlterTableColumn###leadbbs_upload###announceid###Default###0
AlterTableColumn###leadbbs_upload###boardid###Default###0
AlterTableColumn###leadbbs_upload###hits###Default###0
AlterTableColumn###leadbbs_user###ExtentFlag###rencolumnname###ExtendFlag[/P][P]
[/P][P]ALTER TABLE LeadBBS_extend ALTER COLUMN extent_num float
ALTER TABLE LeadBBS_extend ALTER COLUMN extent_num2 float
update leadbbs_applogin set ExpiresTime=0 where ExpiresTime is null
AlterTableColumn###leadbbs_applogin###ExpiresTime###Default###0
update leadbbs_applogin set Token='' where Token is null
AlterTableColumn###leadbbs_applogin###Token###Default###''
alter table leadbbs_boards alter column BoardStyle long[/P][P]
[/P][P]注意一行一行的手动顺序执行。部分非正常sql执行不了的话,替换先替换manage/database目录下面的文件至9.2版本[/P]
3楼
按照版主的第一个回复,这个问题已经解决了,版主后面那个回复是为了升级到9.2的,有时间我再慢慢执行。[P]多谢版主!太热心了![/P]

电脑版 Page created in 0.0000 seconds with 3 queries.