DiscuzX1.5访问群组页面时,经常出现如下错误,刷新以后又变正常
2015.09.10 | 683阅读 | 0条评论 | 未命名
dz1.5版本为20110321版本，访问群组页面错误，刷新以后又可以了。
| Error messages: |
- [Type] 查询语句错误
- [1052] Column 'displayorder' in on clause is ambiguous
- [Query] SELECT attach.*,t.tid,t.author,t.authorid,t.subject , f.name groupname FROM `forum_attachment` attach INNER JOIN `forum_thread` t ON `t`.`tid`=`attach`.`tid` AND `displayorder`>='0' LEFT JOIN forum_forum f ON t.fid=f.fid LEFT JOIN forum_forumfield ff ON f.fid = ff.fid WHERE `attach`.`dateline`>='1292729484' AND `attach`.`readperm`='0' AND `attach`.`price`='0' AND t.isgroup='1'AND `attach`.`isimage` IN ('1', '-1') ORDER BY `attach`.`dateline` DESC LIMIT 0,4;
解决方法：打开
/source/class/block/group/block_groupattachment.php
将第290行
ON `t`.`tid`=`attach`.`tid` AND `displayorder`>='0'
改为：
ON `t`.`tid`=`attach`.`tid` AND `t`.`displayorder`>='0' |
发表评论