السلام عليكم
اخواني الكرام
بسبب التحديثات الاخيرة لـ قواعد بيانات السيرفر والتقطيعات اللي فيها
حدثت مشكلة في زر ( البحث عن المواضيع الجديده )
فبعد الضغط عليها تظهر هالرسالة :
=========================
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.lastpost 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.p...searchid=14511
Referer:
=========================
فهل المشكلة في جدول المواضيع thread او في جدول المرفقات ؟؟
وتفسيركم للسطر :
Unknown column 'thread.postusername' in 'on clause'
؟؟؟؟؟؟
والله يعطيك الف عافيه