مشكلة في ( البحث عن المواضيع الجديده ) !!
السلام عليكم
اخواني الكرام
بسبب التحديثات الاخيرة لـ قواعد بيانات السيرفر والتقطيعات اللي فيها
حدثت مشكلة في زر ( البحث عن المواضيع الجديده )
فبعد الضغط عليها تظهر هالرسالة :
=========================
Invalid SQL:
SELECT DISTINCT post.userid,
thread.threadid,thread.threadid AS postid,thread.title AS threadtitle,thread.iconid AS threadiconid,thread.replycount,
thread.views,thread.pollid,thread.open,thread.last post AS postdateline,thread.lastpost,thread.lastposter,
forum.forumid,forum.security AS security,forum.title AS forumtitle,forum.allowicons,attach,
thread.postusername AS usrname,
user.userid AS postuserid,
threadicon.iconpath AS threadiconpath,threadicon.title AS threadicontitle
FROM
thread,forum
LEFT JOIN user ON user.username=thread.postusername
LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '1' AND post.visible = 1)
WHERE
thread.forumid=forum.forumid AND thread.threadid IN (0)
ORDER BY
thread.lastpost DESC,thread.lastpost DESC
mysql error: Unknown column 'thread.postusername' in 'on clause'
mysql error number: 1054
Date: Wednesday 18th of October 2006 05:33:40 AM
Script:
http://www.amorat.net/vb/vb/search....&searchid=14 511
Referer:
=========================
فهل المشكلة في جدول المواضيع thread او في جدول المرفقات ؟؟
وتفسيركم للسطر :
Unknown column 'thread.postusername' in 'on clause'
؟؟؟؟؟؟
والله يعطيك الف عافيه