|
此主题相关图片如下:

我的是从风讯3.0Sp2升级来的。在后台生成栏目时发生如上错误,请问是怎么回事啊?
答:
在/foosun/admin/Refresh/RefreshFunction.asp,行 2541 附近找到
if ClassListStr <> "" then RecDownListSql = "Select top " & NewNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_DownLoad.FileExtName as DownLoadFileExtName from FS_DownLoad,FS_NewsClass where FS_DownLoad.ClassID=FS_NewsClass.ClassID and FS_DownLoad.AuditTF=1 and FS_RecTF=1 and FS_NewsClass.ClassID in (" & AllClassID & ") order by FS_DownLoad.ID Desc" else RecDownListSql = "Select top " & NewNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_DownLoad.FileExtName as DownLoadFileExtName from FS_DownLoad,FS_NewsClass where FS_DownLoad.ClassID=FS_NewsClass.ClassID and FS_DownLoad.AuditTF=1 and FS_RecTF=1 order by FS_DownLoad.ID Desc" end if
改为
if ClassListStr <> "" then RecDownListSql = "Select top " & NewNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_DownLoad.FileExtName as DownLoadFileExtName from FS_DownLoad,FS_NewsClass where FS_DownLoad.ClassID=FS_NewsClass.ClassID and FS_DownLoad.AuditTF=1 and FS_DownLoad.RecTF=1 and FS_NewsClass.ClassID in (" & AllClassID & ") order by FS_DownLoad.ID Desc" else RecDownListSql = "Select top " & NewNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_DownLoad.FileExtName as DownLoadFileExtName from FS_DownLoad,FS_NewsClass where FS_DownLoad.ClassID=FS_NewsClass.ClassID and FS_DownLoad.AuditTF=1 and FS_DownLoad.RecTF=1 order by FS_DownLoad.ID Desc" end if |