DiscuzX1.5訪問(wèn)群組頁(yè)面時(shí),經(jīng)常出現(xiàn)如下錯(cuò)誤,刷新以后又變正常
2015.09.10 | 648閱讀 | 0條評(píng)論 | 未命名
dz1.5版本為20110321版本，訪問(wèn)群組頁(yè)面錯(cuò)誤，刷新以后又可以了。
| Error messages: |
- [Type] 查詢語(yǔ)句錯(cuò)誤
- [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;
解決方法：打開(kāi)
/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' |
發(fā)表評(píng)論