PDA

View Full Version : Database error after removing vBa Homepage


MegaHertz
07-02-2004, 11:04 PM
I upgraded my forums to 3.0.2 and then ran the advindex_install and told it to install the templates only. Next I uploaded all my files to upgrade to vBa CMPS ran the install it went exactly as planned imported my old settings and everything.

Checked out the Homepage and it worked just fine and everything was in it's place. So I ran the advindex install and had it uninstall vBa Homepage uninstall was reported to be successful. I checked the hompage again to make sure everything was cool and that is when I got this.
<!--
Database error in vBulletin 3.0.2:

Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_advindex AS phrasegroup_advindex,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_global AS phrasegroup_global,
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 vb_user AS user
LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN vb_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1

mysql error: Unknown column 'language.phrasegroup_advindex' in 'field list'

mysql error number: 1054

Date: Friday 02nd of July 2004 08:55:47 PM
Script: http://mysitehere/index.php
Referer: http://mysitehere/forums/index.php?
IP Address: XXX.XXX.XXX.XXX
--> Any ideas on where I went wrong?

Any suggestions on what I need to do to fix the problem?

MegaHertz
07-02-2004, 11:06 PM
FYI the forums are working fine it is only when I try to go to the CMPS home page that I get the error.

Our Sponsors
 

MegaHertz
07-03-2004, 12:33 AM
Disregard it was my own error.