动网论坛部分帖子的楼层错乱的原因以及解决方法
多数造成的原因是ACC转换SQL数据库造成的，帖子默认是ID排列，咱们可以修改成按照时间来排列就可以8.1以下版本修改方法：
用记事本打开dispbbs.asp文件.
找到175行左右.Rem 如果是原版论坛,没经过转换的建议使用这行,可以减少消耗
SQL="Select AnnounceID,UserName,Topic,dateandtime,body,Expression,ip,RootID,signflag,isbest,PostUserid,layer,isagree,GetMoneyType,IsUpload,Ubblist,LockTopic,GetMoney,UseTools,PostBuyUser,ParentID From "& TotalUseTable &" where RootID="& Announceid &" and Boardid="& Dvbbs.Boardid&" Order By Announceid"
Rem 如果你的论坛是从别的论坛转换过来的,如出现楼层错误,则可以把下面的注释去掉,避免错误.
Rem SQL="Select AnnounceID,UserName,Topic,dateandtime,body,Expression,ip,RootID,signflag,isbest,PostUserid,layer,isagree,GetMoneyType,IsUpload,Ubblist,LockTopic,GetMoney,UseTools,PostBuyUser,ParentID From "& TotalUseTable &" where RootID="& Announceid &" and Boardid="& Dvbbs.Boardid&" Order By dateandtime"修改成Rem 如果是原版论坛,没经过转换的建议使用这行,可以减少消耗
Rem SQL="Select AnnounceID,UserName,Topic,dateandtime,body,Expression,ip,RootID,signflag,isbest,PostUserid,layer,isagree,GetMoneyType,IsUpload,Ubblist,LockTopic,GetMoney,UseTools,PostBuyUser,ParentID From "& TotalUseTable &" where RootID="& Announceid &" and Boardid="& Dvbbs.Boardid&" Order By Announceid"
Rem 如果你的论坛是从别的论坛转换过来的,如出现楼层错误,则可以把下面的注释去掉,避免错误.
SQL="Select AnnounceID,UserName,Topic,dateandtime,body,Expression,ip,RootID,signflag,isbest,PostUserid,layer,isagree,GetMoneyType,IsUpload,Ubblist,LockTopic,GetMoney,UseTools,PostBuyUser,ParentID From "& TotalUseTable &" where RootID="& Announceid &" and Boardid="& Dvbbs.Boardid&" Order By dateandtime"8.2版本修改方法就不一样了
如果是ACC版本出现的错乱，可以直接修改
dispbbs.asp179 行 左右 (只限 ACCESS)SQL="Select AnnounceID,UserName,Topic,dateandtime,body,Expression,ip,RootID,signflag,isbest,PostUserid,layer,isagree,GetMoneyType,IsUpload,Ubblist,LockTopic,GetMoney,UseTools,PostBuyUser,ParentID,FlashId From "& TotalUsetable &" whereRootID="& ReplyID &" and Boardid="& Dvbbs.Boardid&" Order By Announceid"改为SQL="Select AnnounceID,UserName,Topic,dateandtime,body,Expression,ip,RootID,signflag,isbest,PostUserid,layer,isagree,GetMoneyType,IsUpload,Ubblist,LockTopic,GetMoney,UseTools,PostBuyUser,ParentID,FlashId From "& TotalUsetable &" whereRootID="& ReplyID &" and Boardid="& Dvbbs.Boardid&" Order By dateandtime"如果 是 SQL就要改存储过程
具体的修改方法： 在导入MDB文件的时候选择插入标识， 或者直接导入mdb 不修改成和默认SQL的MDB一致
页:
[1]