d/b error 1054

[karlm]

Help???

Database error in vBulletin 3.8.3:

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_adv_links AS phrasegroup_adv_links,
language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_prefix AS phrasegroup_prefix,
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
, cmpspages.layout AS cmpslayout
FROM vbuser AS user
LEFT JOIN vbuserfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vbusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vblanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN vbadv_pages_user AS cmpspages ON (user.userid = cmpspages.userid AND cmpspages.pageid = 1)
WHERE user.userid = 7;

MySQL Error : Unknown column 'language.phrasegroup_adv_links' in 'field list'
Error Number : 1054
Request Date : Saturday, July 18th 2009 @ 09:26:25 PM
Error Date : Saturday, July 18th 2009 @ 09:26:25 PM
Script : http://xxxxxxx.com/links/index.php
Referrer :
IP Address : xx.xx.227.171
Username :
Classname : vB_Database
MySQL Version :

[karlm]

Just a note, despite reading the FAQ / installation instructions over and over, I couldn't resolve this. Eventually, I opted to uninstalling it completley and reinstalling from scratch... losing all the data that had been added over the last year by members (and myself). :(

[Our Sponsors]

[Brian]

What version were you trying to upgrade from? It sounds like you had already uninstalled if the phrasegroup was missing (as indicated by the db error).

[BigBass]

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_adv_links_moderate AS phrasegroup_adv_links_moderate,
phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
phrasegroup_adv_links AS phrasegroup_adv_links,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_adv_links_moderate' in 'field list'
Error Number : 1054
Request Date : Wednesday, November 25th 2009 @ 04:25:20 PM
Error Date : Wednesday, November 25th 2009 @ 04:25:20 PM
Script : http://www.reportchildporn.com/supporters/browselinks.php?do=newlinks&ltr=W
Referrer :
IP Address : 65.55.207.28
Username :
Classname : vb_database
MySQL Version :



I am getting and its after i uninstall it

Any idea, how i can get rid of it?

[Our Sponsors]

[Brian]

If you've uninstalled the software then you should be receiving errors when trying to access the vBa Links pages. You'll need to remove the vBa Links files from your server or rename your 'supporters' folder so your users will no longer have access to it.

[BigBass]

Gotta it Brian..........thanks......
That Supporter file is what threw me off, because i renamed it to that...
Sorry..........