Discuz! Database Error

(1054) Unknown column 'avg_desc' in 'order clause'
SELECT shop.*, count.average, count.rank, count.rank1, count.rank2, count.rank3, count.rank4, count.reviewnum FROM xn_haodian_shop shop INNER JOIN xn_haodian_shopcount count USING(shopid) WHERE shop.`displayorder` IN('0','1') AND shop.`invisible`='0' AND shop.`catid` IN('3') ORDER BY avg_desc LIMIT 12

PHP Debug

No.FileLineCode
1haodian.php6include(%s)
2plugin.php47include(%s)
3source/plugin/xn_haodian/xn_haodian.inc.php28require(%s)
4source/plugin/xn_haodian/module/xn_haodian_list.php158table_xn_haodian_shop->fetch_all_by_search(Array, %s, %d, %d)
5source/plugin/xn_haodian/table/table_xn_haodian_shop.php98discuz_database::fetch_all(%s, Array, %s)
6source/class/discuz/discuz_database.php100discuz_database::query(%s, Array, false, false)
7source/class/discuz/discuz_database.php136db_driver_mysql->query(%s, false, false)
8source/class/db/db_driver_mysql.php153db_driver_mysql->halt(%s, %d, %s)
9source/class/db/db_driver_mysql.php224break()
www.tokyocn.com 已经将此出错信息详细记录, 由此给您带来的访问不便我们深感歉意. Need Help?