|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hi, I've encountered the follow problem with my vBulletin, copied and pasted from "Common Issues" thread. Issue: Some users with Forums Only installations have reported receiving the following Database Error when trying to create a sitemap: Database error in vBulletin 4.0.4: Invalid SQL: SELECT administrator.*, 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_global AS phrasegroup_global, language.phrasegroup_cpglobal AS phrasegroup_cpglobal, language.phrasegroup_cpcms AS phrasegroup_cpcms, language.phrasegroup_cpglobal AS phrasegroup_cpglobal, 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 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 administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 2, user.languageid)) WHERE user.userid = 1; MySQL Error : Unknown column 'language.phrasegroup_cpcms' in 'field list' Error Number : 1054 Request Date : Monday, July 5th 2010 @ 08:37:47 AM Error Date : Monday, July 5th 2010 @ 08:37:47 AM Script : http://www.site.com/admincp/sitemap.php Referrer : http://www.site.com/admincp/index.php?do=nav IP Address : 99.249.169.108 Username : Classname : vB_Database_MySQLi MySQL Version : Bug: Fixed in 4.0.5 Fix: Run the following query in phpMyAdmin: ALTER TABLE `language` ADD `phrasegroup_cpcms` mediumtext NOT NULL; I'm not 100% how to do this but from phpMyAdmin, I've selected the vBulletin database, clicked SQL tab and in the text box under "Run SQL query/queries on database " I've entered "ALTER TABLE `language` ADD `phrasegroup_cpcms` mediumtext NOT NULL;" as suggested, however, after clicking go, I get the error "#1146 - Table '.language' doesn't exist". I may be doing it wrong? Any suggestions please? __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
أدوات الموضوع | |
انواع عرض الموضوع | |
| |