 | |  | |
June 21st, 2011, 11:46 AM
|
#1 (permalink)
| | Member Verified Customer
Join Date: Feb 2003
Posts: 364
| Upgrade error
I just upgraded to VB 4.1.4 and then upgraded my VBG to 3.01. Now I can not access my VB database without getting an error in my VBG section of things. I can not even access my VB admincp without getting an error. I have to disable my plugins in my VB config file to get my site to come online.
Here is the error I am getting. Can I get some help please? Quote:
Database error in vBulletin 4.1.4:
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_portal AS phrasegroup_adv_portal,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_prefix AS phrasegroup_prefix,
language.phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
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
, ppgal_user.ppicount, ppgal_user.pppcount, ppgal_user.lastimageid, ppgal_user.lastimagetitle, ppgal_user.lastimagedate, ppgal_user.lastpostid, ppgal_user.lastposttitle, ppgal_user.lastpostdate, ppgal_user.profile_active, ppgal_user.profile_exclude, ppgal_user.profile_include, ppgal_user.profile_orderby, ppgal_user.profile_cutoff, ppgal_user.profile_tabfirst, ppgal_user.profile_autosel, ppgal_user.profile_tabstats, ppgal_user.profile_tabhighlight, ppgal_user.profile_showtitle, ppgal_user.profile_showcat, ppgal_user.profile_showcontext, ppgal_user.profile_contextfirst, ppgal_user.profile_showhtitle, ppgal_user.profile_husername, ppgal_user.profile_showhcat, ppgal_user.profile_showhcontext, ppgal_user.ppfavcount, ppgal_user.upload_readpolicy, ppgal_user.profile_tabthumbs, ppgal_user.profile_limit
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 ppgal_user AS ppgal_user ON (ppgal_user.userid = user.userid)
WHERE user.userid = 8;
MySQL Error : Unknown column 'ppgal_user.profile_tabfirst' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 21st 2011 @ 12:09:50 PM
Error Date : Tuesday, June 21st 2011 @ 12:09:50 PM
Script : emailMyName- Low-cost email address - 1GB email storage - Block spam - Web & POP3 email access - Get your name as your email address
Referrer :
IP Address : 72.224.240.166
Username :
Classname : vB_Database
| |
| |
June 21st, 2011, 12:05 PM
|
#2 (permalink)
| | Member Verified Customer
Join Date: Feb 2003
Posts: 364
|
I figured out the problem. I forgot to run the install file,
|
| |
June 21st, 2011, 12:49 PM
|
#3 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,676
|
Not a problem glad its sorted. Was just about to say I am running 4.14 with vbgallery test setup and did not see anything like that.
|
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread | Linear Mode | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | All times are GMT -5. The time now is 05:26 PM. | |