MySQL Query Error: SELECT s.sid,pid,catid,domain,name,
case reviews
when 0 then 0
when 1 then 0.1
when 2 then 0.1
when 3 then 0.1
when 4 then 0.1
when 5 then 0.1
when 6 then 0.1
when 7 then 0.1
when 8 then 0.1
when 9 then 0.1
else avgsort end as avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews,pictures,favorites,thumb,c_inpai,c_price,c_candi,c_naiyuan,c_banben,c_shiyongnl,c_peiliaosx,c_ruji,c_tspeifang,c_yingyangyq,c_tsyaoqiu,c_pinpaisx,c_guanzhuang,c_jqpeifang,c_danjia,c_xxpeiliaob,c_ssgongsi,c_ssjituan,c_guige,c_youdian,c_quedian,c_qita,c_youdiansm,c_quediansm,c_qitasm,subname,video,description,c_nianling,c_baozhuang,c_guanwang,c_goumaidizi FROM [dbpre]subject s LEFT JOIN [dbpre] sf ON (s.sid = sf.sid) WHERE pid = 4 AND aid = 0 AND status = 1 AND listshow = 0 AND catid = 22 AND exists(SELECT 1 FROM [dbpre]subjectatt st FORCE INDEX (sid) WHERE s.sid=st.sid AND attid IN (548,80,84,35)
GROUP BY st.sid HAVING COUNT(st.sid)=4) ORDER BY sortscore DESC LIMIT 0, 10
Error description: Table 'modoer.[dbpre]' doesn't exist
Error number: 1146
Date: 2026-03-22 @ 22:02
Script: http://www.naifen123.cn/item-list-catid-22-aid-0-att-4.548_8.80_2.84_3.35.html
| File | Line | Function |
|---|---|---|
| core/lib/mysql.php | 91 | ms_mysql->_halt() |
| core/lib/database.php | 404 | ms_mysql->query() |
| core/modules/item/model/subject_class.php | 405 | ms_database->get() |
| core/modules/item/list.php | 344 | msm_item_subject->getlist() |
| core/modules/item/common.php | 36 | include() |
| index.php | 50 | include() |