在线情况
楼主
  • 头像
  • 级别
    • 积分20
    • 经验739
    • 文章15
    • 注册2013-08-08
    升级成8.0后发贴出现了一个问题
    [FACE=宋体][SIZE=12px]升级成8.0后发贴时,下面出现一个错误,显示以下SQL语句执行出错,程序意外中止,请问这是怎么回事?谢谢![/SIZE][/FACE][P][FACE=宋体][SIZE=12px]
    [/SIZE][/FACE][/P]
    [upload=16162,0]网站出错.PNG[/upload]
    LeadBBS 官方论坛(asp论坛)感谢您的参与
    在线情况
    2
    • 头像
    • 级别
    • 徽章
    • 职务总版主
    • 声望+46
    • 积分17058
    • 经验1436058
    • 文章25379
    • 注册2003-01-20
    [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]
    LeadBBS 官方论坛(asp论坛)感谢您的参与
    在线情况
    3
    • 头像
    • 级别
    • 徽章
    • 职务总版主
    • 声望+46
    • 积分17058
    • 经验1436058
    • 文章25379
    • 注册2003-01-20
    [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]
    LeadBBS 官方论坛(asp论坛)感谢您的参与
    在线情况
    4
    • 头像
    • 级别
      • 积分20
      • 经验739
      • 文章15
      • 注册2013-08-08
      按照版主的第一个回复,这个问题已经解决了,版主后面那个回复是为了升级到9.2的,有时间我再慢慢执行。[P]多谢版主!太热心了![/P]
      LeadBBS 官方论坛(asp论坛)感谢您的参与
      Page created in 0.0117 seconds with 6 queries.