MySQL Query Error: SELECT s.sid,pid,catid,domain,name,avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews,pictures,favorites,thumb,aid,map_lat,map_lng,avgprice,subname,video,address,c_sewg,c_cgyhbv,c_thyg,c_trdxg,tel,c_fhgh,description,c_fhbkg,c_kuym,c_ureds,c_trewug,c_uygfdsg,c_hytfdsh,c_frew,card_msg,content,level FROM [dbpre]subject s LEFT JOIN [dbpre]subjectatt st ON (s.sid = st.sid) LEFT JOIN [dbpre]subject_shops sf ON (s.sid = sf.sid) WHERE status = '1' AND pid = '328' AND city_id = '1' AND attid = '3309' ORDER BY finer DESC LIMIT 0, 10
Error description: Unknown column 'address' in 'field list'
Error number: 1054
Date: 2025-12-19 @ 16:56
Script: http://www.liyuanwu.com/index.php/item-list-branch_id-0-catid-334-aid-2940.html
| File | Line | Function |
|---|---|---|
| core\lib\mysql.php | 115 | ms_mysql->_halt() |
| core\lib\activerecord.php | 86 | ms_mysql->query() |
| core\modules\item\model\subject_class.php | 153 | ms_activerecord->get() |
| core\modules\item\list.php | 215 | msm_item_subject->getlist() |
| core\modules\item\common.php | 40 | include() |
| index.php | 56 | include() |