[Sir Hero]

السلام عليكم ورحمة الله

بعد الترقية من النسخة 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

بإنتظار حل للمشكلة

وأكون شاكر لكم حسن تعاونكم

وأتمنى أن ألا أكون قد أطلت عليكم بمشاكل منتداي

تقبلوا أسمى تحياتي