elsha3r
06-08-2011, 01:35 PM
السلام عليكم ورحمه الله وبركاته
يوجد مشكله عندى فى مجله ديموفنق
تعطينى Database error
error in Dimofinf v3.0.0 :
***********************************
Invalid SQL:
SELECT id,caption
FROM downloadsm AS downloadsm
WHERE downloadsm.date <= '1312600792' AND
downloadsm.updatedate !='' AND
((1312600792-downloadsm.updatedate)/86400) < 7 AND
downloadsm.inmain='1'
AND newsm.id NOT IN(01474,1473,1471,1468,1467,1472,1470,1469,1464,1 461)
ORDER BY downloadsm.id desc
LIMIT 30;
***********************************
MySQL Error :
===================================
Unknown column 'newsm.id' in 'where clause'
===================================
Error Number : 1054
Date aturday, August 6th 2011 06:20:06 AM
Referrer : REFERRER
Database error
ما هو الحل
يوجد مشكله عندى فى مجله ديموفنق
تعطينى Database error
error in Dimofinf v3.0.0 :
***********************************
Invalid SQL:
SELECT id,caption
FROM downloadsm AS downloadsm
WHERE downloadsm.date <= '1312600792' AND
downloadsm.updatedate !='' AND
((1312600792-downloadsm.updatedate)/86400) < 7 AND
downloadsm.inmain='1'
AND newsm.id NOT IN(01474,1473,1471,1468,1467,1472,1470,1469,1464,1 461)
ORDER BY downloadsm.id desc
LIMIT 30;
***********************************
MySQL Error :
===================================
Unknown column 'newsm.id' in 'where clause'
===================================
Error Number : 1054
Date aturday, August 6th 2011 06:20:06 AM
Referrer : REFERRER
Database error
ما هو الحل