Forum was unusable after installing vBGallery 2.5

[packetattack]

I ran the install for vBGallery last night on my forums running vBulletin 3.8.2.

I got an error during the install that it was unable to install, so having thought that I previously had installed it a long time ago, I clicked the upgrade button. Once I did that, the entire forums was unusable and all users were receiving SQL errors during login (see below). I had to edit my vBulletin config.php to turn off all plugin hooks, login to AdminCP and using the Plugin & Products section, click the Uninstall button.

I saw one of Chuck's post on issuing a SQL DELETE to ensure that all tables were gone for vBGallery however I didn't do that after uninstalling as that seems to have taken care of it, correct?

I also noticed that the 2.5 version I downloaded did not have as lengthy a readme as the version found in the members section. I initially downloaded 2.5 the day the email blast went out touting the new version of vBGallery so I don't know if I missed any steps, but I made sure that the forums path and everything was there.

That aside, I would like to attempt to install vBGallery again. I had sent my phpMyAdmin credentials via the Contact Us link yesterday so if someone could take a look at my database to make sure no old "vbGallery" tables are hanging around, I would appreciate it, before I attempt the upgrade again and have to uninstall the product again.

SQL error message below. Yes, I did search on the "ppgal" error message and found a few other users here that saw the same error, however the circumstances might have been different.

Thanks in advance,

P.S. I should note that I also have a plugin called "Album Pictures - Forum Home" just in case that might have caused a conflict?

--------------------------

Database error in vBulletin 3.8.2:

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_adv_gallery_int AS phrasegroup_adv_gallery_int,
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.*
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 = 4223;

MySQL Error : Table 'nycmaximas2.ppgal_user' doesn't exist
Error Number : 1146
Request Date : Monday, July 27th 2009 @ 09:36:26 AM
Error Date : Monday, July 27th 2009 @ 09:36:26 AM
Script : NYCMaximas - New York City Maximas Auto Club
Referrer :
IP Address : 129.44.59.56
Username :
Classname : vB_Database
MySQL Version :

[Chuck S]

There should be a user table in vbgallery

This tells me at the very minimum 2.42 upgrade forward was not ran

Please send a url admin login and ftp information for us to look at this through the contact us link in our header

[packetattack]

Hi Chuck, all of the info was sent through the Contact Us link, two days ago. Did you not receive it?

[Chuck S]

I dont beleive we recieved any such email which email would this have come from so I can check our helpdesk?

[packetattack]

In the Contact Us form, I would have used packetattack@yahoo.com as the email address.

[Chuck S]

I see no emails from packetattack@yahoo.com but I do beleive that might be a yahoo issue as I seem to remember an issue of yahoo people not getting emails from our domain probally an issue with that host blocking the domain but not sure. Try sending the email to us with another email.

[packetattack]

Chuck, I think you're misunderstanding me.

I sent all my login details through the form on the top of header which is where the Contact Us link takes you to.

This is the form I used:

PhotoPost Gallery: Contact Sales and Support

This has nothing to do with my Yahoo email since I only used the address in your form to contact me back, it didn't originate from Yahoo.

I really hope you find that contact form because it contains root level credentials, otherwise I am going to have to change some passwords right now.

[Chuck S]

Your email which is required does send an email from that email I beleive as all that is is a form email program.

I am merely saying there is no emails from that email which the email you input into that form would be sent to use and appear in our helpdesk.

I have also searched our helpdesk for your domain name which is tied to your license and nothing comes up in the helpdesk contact for that domain, I searched your name as well nothing comes up.

Feel free to send an email via your email program if you wish to support at photopost dot com.

[packetattack]

Ok, understood. Sent one from Yahoo (just to see) and also my gmail (noxide@gmail dot com). Let me know if you see either of those.

[Chuck S]

Yes I got both of those emails in our helpdesk although none included the asked for details.

[packetattack]

Originally Posted by Chuck S

Yes I got both of those emails in our helpdesk although none included the asked for details.

You should have the email now with all the login details.

Thank you,

[Chuck S]

I got it and responded

[Chuck S]

You need to tell me what your doing because its all a mess

I dont see where you have a workable photopost vbgallery anywhere.

You cant upgrade to vbgallery from photopost

Your database has Photopost Pro tables as well as old style vbgallery tables and new vbgallery tables so there is your issue your upgrade script is very confused whats going on.

So I take it you tried upgrading from photopost to vbgallery which is your issue

PhotoPost vBGallery

You where probally expecting this but photopost pro and vbgallery are two separate products.

[packetattack]

I just want to install vBGallery and use that, not PhotoPost.

I might have had an old PhotoPost installation from a long time ago which is probably what you found.

[Chuck S]

well you had all kind of stuff around. You had old vbgallery tables new vbgallery tables photopost tables. Thus vbgallery did not know what to do cause it found old vbgallery tables. At any rate you can delete the content if you wish.

[packetattack]

Shouldn't the script be able to identify old stuff and remove it/upgrade etc, the way vBulletin does it?

Thanks for getting it running Chuck. I notice my Chatbox disappeared. I will have to look at the template to see where the code for it went.

[Chuck S]

No it should not remove anything. It found old tables so it tried to upgrade and hense your issue you had improper old tables etc

Your title of this thread was even misleading saying failed upgrade. You should have been like new install.

Like I said its up and running as I installed it for you free and you can delete any old photopost pro content as you wish I simply worked with what I saw. I mean you even uploaded your vbgallery files into the photopost pro directory with all its files.

[packetattack]

Originally Posted by Chuck S

No it should not remove anything. It found old tables so it tried to upgrade and hense your issue you had improper old tables etc

Your title of this thread was even misleading saying failed upgrade. You should have been like new install.

Like I said its up and running as I installed it for you free and you can delete any old photopost pro content as you wish I simply worked with what I saw. I mean you even uploaded your vbgallery files into the photopost pro directory with all its files.

Chuck, I followed the directions that stated which files are supposed to go into which directories for this install based on the 2.5 documentation. Perhaps you were looking at some old directories or something, I don't know. Regardless, thanks for your help today, you can close this thread.

[Chuck S]

No what I am saying is you installed vbgallery into the photopost directory.

The confusion of course was your multitude of different product installs over the years where all in the database.

[packetattack]

Based on what you saw today, should it be safe to run the IMPORT script to get the vBulletin Gallery pics into vBGallery 2.5?