mon858
04-24-2007, 05:16 PM
اهلا السلام عليكم ورحمة الله وبركاته
اخواني اريد مساعدة
انا قمت بعملية تحديث منتداي من 3.5.0 إلى 3.6.5
وكل شيء تماام بس لما ادخل المواضيع بالمنتدى تظهر لي هذه المشكله
Database error in vBulletin 3.6.5:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,2290,2232,2182,2191,2144,2142,940,1052,120,714, 2158,582,2143,2083,143,1188,2141,1190,2121,614,181 3)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Column 'canview' in on clause is ambiguous
Error Number : 1052
Date : Tuesday, April 24th 2007 @ 06:02:23 PM
Script : http://www.smd-sh.com/vb/forumdisplay.php?f=7
Referrer : http://www.smd-sh.com/vb/
IP Address : 122.167.38.189
Username : smd-sh.net
Classname : vb_database
بلييييييييييز اريد مساعدة في اسرع وقت ممكن
اخواني اريد مساعدة
انا قمت بعملية تحديث منتداي من 3.5.0 إلى 3.6.5
وكل شيء تماام بس لما ادخل المواضيع بالمنتدى تظهر لي هذه المشكله
Database error in vBulletin 3.6.5:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,2290,2232,2182,2191,2144,2142,940,1052,120,714, 2158,582,2143,2083,143,1188,2141,1190,2121,614,181 3)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Column 'canview' in on clause is ambiguous
Error Number : 1052
Date : Tuesday, April 24th 2007 @ 06:02:23 PM
Script : http://www.smd-sh.com/vb/forumdisplay.php?f=7
Referrer : http://www.smd-sh.com/vb/
IP Address : 122.167.38.189
Username : smd-sh.net
Classname : vb_database
بلييييييييييز اريد مساعدة في اسرع وقت ممكن