www.dhyxy.cn - Database Error

(1052) Column 'fid' in order clause is ambiguous

SELECT 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 ('294','293') AND f.type='sub' AND f.status=3 ORDER BY f.displayorder DESC, fid DESC LIMIT 0, 30

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()

Discuz! Database Error