DiscuzX1.5訪問群組頁面時,經常出現如下錯誤,刷新以后又變正常
2015.09.10 | 611閱讀 | 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' |
發表評論