السلام عليكم ورحمة الله
بعد الترقية من النسخة 3.5.3 إلى النسخة 3.6.0
قمت بالترقية من النسخة 3.6.0 إلى النسخة الماسية 3.6.4
وبعد تركيب الإستايل ظهر الإستايل بدون مشاكل
لكن عند الدخول على أى قسم أو أى موضوع من واجهة المنتدى الرئيسية
تظهر مشكلة بالداتا بيس
لكن الرسالتين مختلفتين بعض الشيء
فعند الضغط على أى من الأقسام تظهر هذه الرسالة
كود:
Database error in vBulletin 3.6.4:
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,515,514)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'canview' in 'on clause'
Error Number : 1054
Date : Sunday, January 28th 2007 @ 09:43:53 AM
Script : http://www.hero-world.com/vb/forumdisplay.php?f=48
Referrer : http://www.hero-world.com/vb/
IP Address : 82.201.130.94
Username : :: S i r H e r o ::
Classname : vb_database
وعند الضغط على أى موضوع من واجهة المنتدى الرئيسية تكون الرسالة كالتالي :
كود:
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT IF(visible = 2, 1, 0) AS isdeleted,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,
thread.*
FROM thread AS thread
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND subscribethread.canview = 1)
WHERE thread.threadid = 599;
MySQL Error : Unknown column 'subscribethread.canview' in 'on clause'
Error Number : 1054
Date : Sunday, January 28th 2007 @ 09:44:39 AM
Script : http://www.hero-world.com/vb/showthr...=newpost&t=599
Referrer : http://www.hero-world.com/vb/
IP Address : 82.201.130.94
Username : :: S i r H e r o ::
Classname : vb_database
بإنتظار حل للمشكلة
وأكون شاكر لكم حسن تعاونكم
وأتمنى أن ألا أكون قد أطلت عليكم بمشاكل منتداي
تقبلوا أسمى تحياتي