|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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 @ 0541 AM Error Date : Saturday, November 10th 2012 @ 0541 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. __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum MYSQL errors | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-28-2010 02:50 PM |
Forum Help me with some of MySQL errors | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 03-08-2010 09:20 PM |
Forum Mysql errors and bots? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 02-28-2010 02:00 AM |
Forum Anyone getting rsslog mysql errors? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 01-17-2010 09:10 PM |
Forum MySQL database errors | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 01-01-2010 09:40 AM |