Upgrading VBGallery database error

mindcry · January 4th, 2008, 08:40 AM

I am trying to upgrade VBGallery. I uploaded all of the files and went to run the script and got the database errors pasted below.

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT catid, styleid, title, allowusercats, catuserid, membercat, parent, parentlist, hasimages, password, active, options, useroptions, styleoverride FROM ppgal_categories ORDER BY d d, hasimages;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'd, hasimages' at line 1
Error Number : 1064
Date : Friday, January 4th 2008 @ 09:22:16 AM
Script : http://domain.com/admincp/vbgallery_install.php
Referrer : http://domain.com/admincp/vbgallery_install.php
IP Address : x.x.x.x
Username : username
Classname : vB_Database

Database error in vBulletin 3.6.5:

Invalid SQL:
CREATE TABLE ppgal_setting SELECT * FROM adv_setting;

MySQL Error : Table 'ppgal_setting' already exists
Error Number : 1050
Date : Friday, January 4th 2008 @ 09:35:31 AM
Script : http://domain.com/admincp/vbgallery_install.php
Referrer : http://domain.com/admincp/vbgallery_install.php
IP Address : x.x.x.x
Username : username
Classname : vB_Database

mindcry · January 4th, 2008, 11:32 AM

I tried dropping ppgal_setting and now I get You are already running the current version of PhotoPost vBGallery Photopost vBGallery. which is not true

mindcry · January 4th, 2008, 11:42 AM

That didnt work so I restored it from backup. Now I dont get any db errors but it says that I am running the latest version still. so, when I go to the gallery page it's blank

Zachariah · January 4th, 2008, 12:13 PM

Shoot me some ftp access and a AdminCP account via PM.
- I'll take a look.

mmilton67uk · January 8th, 2008, 11:47 AM

I had this same problem with the upgrade from version 2.0 to 2.4.1
I had to uninstall the old version before i could install the new version then i had to reupload all the images to the folders and input the images into the sql by hand,
So that i did not lose what i had already on my site.

I think you need to look into the upgrade script as its not doing what its ment to do.

I have also tryed this on my test site and i get the same errors.
if you would like a list of the errors i will do this for you and post them here so that you can see, but its best if you install the old version then try an upgrade yourself to see whats happening first hand.

boske · January 29th, 2008, 07:57 AM

I am having the same issues, can anyone help?

Code:

Content visible to verified customers only.

Zachariah · January 29th, 2008, 02:46 PM

Quote:

Originally Posted by boske

I am having the same issues, can anyone help?

Code:

Content visible to verified customers only.

Hello what version of the gallery did you have installed ?

boske · January 30th, 2008, 02:28 PM

I had vBadvanced Gallery v1.0.1

bloodydecks · January 31st, 2008, 09:17 AM

I have the exact same problem. Going from version 2.0 vbgallery. With vbulletin 3.6.8 pl2

Zachariah · January 31st, 2008, 10:43 AM

First let's explore your database to find where the upgrade failed so that we can continue. There needs to be few queries executed to look around. There is a tool in vBulletin. I do not have table prefixes in front of my table name.

AdminCP => Maintenance => Execute SQL Query

Code:

Content visible to verified customers only.

Looking for: pppcount, ppicount

If found continue run:

Code:

Content visible to verified customers only.

- Then run the upgrade script again

If not shoot me some ftp/admincp access via PM.

boske · January 31st, 2008, 11:00 AM

seems like that did the trick! Thank you for your help!

bloodydecks · January 31st, 2008, 03:58 PM

Thanks for posting Zacharaih.
I ran the query and did not find pppcount or ppicount.
I did run the second query reguardless and it fixed the problem...

bloodydecks · February 1st, 2008, 12:30 AM

Nevermind. Still broken. 10K users on my website concerned

.

Code:

Content visible to verified customers only.

Zachariah · February 1st, 2008, 03:30 PM

bloodydecks, added the 2 missing columns in user table.
- you should be ready to go

bloodydecks · February 1st, 2008, 03:45 PM

Yep. It works now. But in the admincp I have urls and img tags enabled and they don't show up on the picture display page. Should I reinstall the templates?

You are the man Zachariah. Thanks for saving all the years of pics...

Zachariah · February 1st, 2008, 04:08 PM

Darkness Style

ADV_GALLERY_SHOWIMAGE
Default Template Updated in PhotoPost vBGallery 2.4 by PhotoPost vBGallery
Your Custom Template Last Edited in PhotoPost vBGallery 2.0 by Jason

You may have some Google ads or custom items in there.

bloodydecks · February 1st, 2008, 04:19 PM

All fixed! Thank you!