Forum "Common Issue" problem
 

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?