DX3.4正式版917出现Column 'fid' in order clause is ambiguous

zengrenrui

升级917后群组出现
Discuz! Database Error(1052) Column 'fid' in order clause is ambiguousSELECT ff.*, f.fid, f.name, f.threads, f.posts, f.todayposts, f.level as flevel FROM forum_forum f USE INDEX(fup_type) LEFT JOIN forum_forumfield ff ON ff.fid=f.fid WHERE f.fup IN ('212') AND f.type='sub' AND f.status=3 ORDER BY f.displayorder DESC, fid DESC LIMIT 0, 40

PHP Debug

No.	File	Line	Code
1	group.php	32	require(%s)
2	source/module/group/group_index.php	115	grouplist(%s, %s, Array, Array, %d)
3	source/function/function_group.php	48	table_forum_forum->fetch_all_for_grouplist(%s, %s, Array, Array, %d, %d)
4	source/class/table/table_forum_forum.php	302	discuz_database::fetch_all(%s)
5	source/class/discuz/discuz_database.php	106	discuz_database::query(%s, Array, false, false)
6	source/class/discuz/discuz_database.php	142	db_driver_mysql->query(%s, false, false)
7	source/class/db/db_driver_mysql.php	152	db_driver_mysql->halt(%s, %d, %s)
8	source/class/db/db_driver_mysql.php	223	break()

我知道答案 回答被采纳将会获得1 贡献 已有4人回答

zengrenrui

请查看群组地址www.jatxh.cn/group.php?sgid=212

zengrenrui

table_forum_forum.php这个文件用以前的就正常。

allthebest

https://www.dismall.com/thread-10348-1-1.html

看看以上帖子，沙发解决方法

zengrenrui

source\class\table\table_forum_forum.php
找到
fid DESC' : 'ORDER BY fid DESC


改为
f.fid DESC' : 'ORDER BY f.fid DESC


搞定，www.jatxh.cn