Errors trying to upgrade to v2.5

[sean747]

good afternoon,

I'm having trouble upgrading to v2.5 and was wondering if anyone can help. First I ran into the problem here,

2.5 Upgrade Error

I edited the version through phpmyadmin and that fixed that error.

then I got this,

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

I refreshed the page and now I get this

Database error in vBulletin 3.8.4:

Invalid SQL:
CREATE TABLE ppgal_setting SELECT * FROM adv_setting;

MySQL Error : Table 'ppgal_setting' already exists

can anyone tell me what is going on please?

thanks.

[Chuck S]

what version of vb are you running?

[sean747]

forums running vB Version 3.8.4


looking into it more, I think i should change the version from 2.0.0 to 2.0 in the database from looking at the install file? and run the upgrade again, what do you think?

I don't even know why all of this is happening to begin with.

I also sent an email out using the "contact us" with the phpmyadmin and forum admin info.

thanks,
Sean Sartipi

[sean747]

k the gallery seems to be back up but it's one huge mess, I don't even know what version the gallery is running anymore cause I don't even know how far the upgrade went through. The gallery admin link doesn't even show up in admincp.

possible for you to take a look at the database please from the email I sent out earlier? sean.sartipi@gmail.com

this is how the gallery looks right now, the main page is a big mess too,

Vivid Racing -

[Chuck S]

You can send site info to contact us link in header

[sean747]

Hi Chuck,

already did about two hours ago,

Thank you for contacting PhotoPost Sales. We have received your email and we will reply to you as soon as possible. If you would like an immediate answer to your question, please give us a call at 1-800-346-9486 Monday through Friday between the hours of 9am and 4pm Eastern time, and one of our friendly and knowledgeable sales specialists will be happy to assist you.

Thank you,

The PhotoPost Team

let me know if I should send the info over again, or if I missed anything in the email I sent. The email was sent using the contact us form that you mentioned.

the email in use is: sean.sartipi@gmail.com

thank you.

[Chuck S]

No problem will see what I can find there

[sean747]

thank you very much Chuck

[Chuck S]

No problem once I get posts answered here I am going over there

[sean747]

appreciate it Chuck, thanks again

[sean747]

Chuck just received your email thank you. However, I responded with one of the issues that are still there regarding the admincp.

thanks again for your help,
Sean

[sean747]

Hi again,

just a quick update that after I added my userid to the vbulletin's config file, the vbgallery admin link seem to show up and seems to be working fine.

thank you

[Chuck S]

No problem glad that worked