![]() |
Forum Mysql errors - please help Hi, I am getting some errors in my vbulletin. Daily i get several emails to my email id about database error like this - Error type 1 : Database error in vBulletin 4.1.6: Invalid SQL: SELECT post_thanks.postid AS postid FROM post_thanks AS post_thanks LEFT JOIN post AS post USING (postid) INNER JOIN thread AS thread ON(thread.threadid = post.threadid) WHERE post_thanks.userid = 2563 AND thread.forumid IN(1,2,44,24,8,9,10,11,3,4,5,7,25,35,12,13,14,26,3 1,27,28,32,33,30,15,29,17,18,16,36,38,37 ,40,41,42,43) ORDER BY post.dateline DESC LIMIT 1000; MySQL Error : Table 'abc123_myforumdb.post_thanks' doesn't exist Error Number : 1146 Request Date : Monday, November 12th 2012 @ 10:25:07 PM Error Date : Monday, November 12th 2012 @ 10:25:07 PM Script : http://www.myforum.com/post_thanks.p...er_gave&u=2563 Referrer : IP Address : 192.31.21.179 Username : Unregistered Classname : vB_Database MySQL Version : Error type 2 : Database error in vBulletin 4.1.6: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_global AS phrasegroup_global, language.phrasegroup_holiday AS phrasegroup_holiday, language.phrasegroupinfo AS lang_phrasegroupinfo, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep , (user.credits) AS vbcredits_1, user.credits AS vbcreditsb_1, (user.DailyCredits) AS vbcredits_3, user.DailyCredits AS vbcreditsb_3 ,kbank_granted.allow_count AS kbank_granted_count ,kbank_granted.allow_userid AS kbank_granted_userid ,kbank_granted.allow_username AS kbank_granted_username ,kbank_granted.allow_usergroupid AS kbank_granted_usergroupid ,kbank_granted.allow_membergroupids AS kbank_granted_membergroupids ,kbank_granted.allow_money AS kbank_granted_money FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) LEFT JOIN ( SELECT kbank_granted.userid AS userid ,COUNT(*) AS allow_count ,GROUP_CONCAT(user.userid SEPARATOR '|') AS allow_userid ,GROUP_CONCAT(user.username SEPARATOR '|') AS allow_username ,GROUP_CONCAT(user.usergroupid SEPARATOR '|') AS allow_usergroupid ,GROUP_CONCAT(user.membergroupids SEPARATOR '|') AS allow_membergroupids ,GROUP_CONCAT(user.money SEPARATOR '|') AS allow_money FROM `kbank_granted_permission` AS kbank_granted INNER JOIN `user` AS user ON (user.userid = kbank_granted.allowid) WHERE kbank_granted.userid = 1 GROUP BY kbank_granted.userid ) AS kbank_granted ON (kbank_granted.userid = user.userid) WHERE user.userid = 1; MySQL Error : Table 'abc123_myforumdb.kbank_granted_permission' doesn't exist Error Number : 1146 Request Date : Saturday, November 10th 2012 @ 05:13:41 AM Error Date : Saturday, November 10th 2012 @ 05:13:41 AM Script : http://www.myforum.com Referrer : IP Address : 117.222.225.86 Username : Classname : vB_Database MySQL Version : Please help me, i am getting such mysql errors many times a day to my email id. Want to get rid of these errors. |
الساعة الآن 05:10 PM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir