PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old June 21st, 2011, 11:46 AM   #1 (permalink)
Member
Verified Customer
 
attroll's Avatar
 
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
attroll is offline   Reply With Quote
Old June 21st, 2011, 12:05 PM   #2 (permalink)
Member
Verified Customer
 
attroll's Avatar
 
Join Date: Feb 2003
Posts: 364
I figured out the problem. I forgot to run the install file,
attroll is offline   Reply With Quote
Old June 21st, 2011, 12:49 PM   #3 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
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.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reviewpost Error after upgrade: Parse Error vengeance72 ReviewPost Installation & Upgrades 7 November 6th, 2010 11:25 AM
Error after upgrade to 2.4.3 Lily_My_Lovely Installs and Upgrade - vBulletin 3.6x 12 September 14th, 2008 05:04 AM
Upgrade error: ...unrecoverable error fpoole Classifieds Bug Reports 10 February 23rd, 2007 08:01 AM
Upgrade error on upgrade from 5.0 release to 5.1 zacksof Photopost Pro Installation & Upgrades 20 December 1st, 2006 11:43 AM
error on upgrade from 3.1.1 ncangler ReviewPost Installation & Upgrades 8 September 9th, 2006 09:02 AM


All times are GMT -5. The time now is 05:26 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0