Upgrade error 1.0 RC4 > 3.01

[Marcski]

Trying to upgrade my testserver from 1.0 RC4 to 3.01, i get the following error;

Database error in vBulletin 4.1.7:

Invalid SQL:
REPLACE INTO ppgal_settinggroup (grouptitle, displayorder) VALUES ('adv_gallery_global', '1');

MySQL Error : Table 'vf_db.ppgal_settinggroup' doesn't exist
Error Number : 1146
Request Date : Saturday, November 5th 2011 @ 04:41:38 PM
Error Date : Saturday, November 5th 2011 @ 04:41:53 PM
Script : http://192.168.1.10/forum/admincp/vbgallery_install.php
Referrer : http://192.168.1.10/forum/admincp/vbgallery_install.php
IP Address : 192.168.1.117
Username : Marcski
Classname : vB_Database
MySQL Version : 5.5.17

[Chuck S]

Well the real question is why does that table not exist if you ask me.

Content visible to verified customers only.

You can try running that query in phpmyadmin and see if that helps and continue your upgrade.

[Marcski]

TYPE=MyISAM is deprecated btw, but i used ENGINE=
(had to replace the whole upgrade script the first time round)

Updated to version 2.0B2

Updated to version 2.0.0

Updated to version 2.0

Updated to version 2.1

Updated to version 2.2

Updated to version 2.3

Updated to version 2.4

Updated to version 2.4.3

Updated to version 3.0 Beta 1

Updated to version 3.0 Beta 2

Updated to version 3.0 Beta 3

this is when it happened. Running the script after creating the table gave an error on 2.0.0 upgrade;

Database error in vBulletin 4.1.7:

Invalid SQL:
ALTER TABLE adv_gallery_categories RENAME TO ppgal_categories;

MySQL Error : Table 'vf_db.adv_gallery_categories' doesn't exist
Error Number : 1146
Request Date : Saturday, November 5th 2011 @ 09:17:06 PM
Error Date : Saturday, November 5th 2011 @ 09:17:07 PM
Script : http://192.168.1.10/forum/admincp/vbgallery_install.php
Referrer : http://192.168.1.10/forum/admincp/vbgallery_install.php
IP Address : 192.168.1.117
Username : Marcski
Classname : vB_Database
MySQL Version : 5.5.17

putting a database backup back now and creating the table before running the full upgrade..

[Chuck S]

Yes I can see where it happened I was merely commenting on the specific errors. I would think you have an issue with the type versus engine and then of course your specific version in the database.

what is the version in your setting table for the vbgallery your running?

[Marcski]

after the (failed) upgrade?

[Chuck S]

Yes I am trying to figure out where you are.

Your trying to upgrade from an early pre release beta not even from the gold first version.

Your noting errors from 3.0 upgrades yet when you go back your getting errors from 2.0 the version number is suppose to be changed at every upgrade stage.

[Marcski]

i know, but we've been running RC4 since forever without any problems

i can't find a vbgallery version varname in the setting table.

after the create table on a db restore, upgrade goes on to ?do=upgradesettings, but stalls at another error:

Database ... Updated!

Importing Settings from XML File...

Database error in vBulletin 4.1.7:

Invalid SQL:

SELECT *
FROM ppgal_setting;

MySQL Error : Table 'vf_db.ppgal_setting' doesn't exist
Error Number : 1146
Request Date : Saturday, November 5th 2011 @ 10:47:44 PM
Error Date : Saturday, November 5th 2011 @ 10:47:45 PM
Script : http://192.168.1.10/forum/admincp/vb...pgradesettings
Referrer : http://192.168.1.10/forum/admincp/vbgallery_install.php
IP Address : 192.168.1.117
Username : Marcski
Classname : vB_Database
MySQL Version : 5.5.17

[Marcski]

adv_setting and adv_settinggroup tables do exist though;

SQL query: SELECT * FROM `adv_setting` WHERE `varname` LIKE '%gallery_version%' LIMIT 0 , 30;
Rows: 1
varname grouptitle value defaultvalue optioncode displayorder
gallery_version adv_gallery_main 1.0 RC4 1.0 RC4 hidden 1

[Chuck S]

We are not talking about the adv_settinggroup table though are we. I am trying to see where your at. Do you have ppgal_ prefixed gallery tables in your database? If you do your past those old tables.

If you continue to have issues I might need to see your site because I can only guess by what your posting it is not like I am doing things first hand.

[Marcski]

I've set up 3 databases, one with RC4 before upgrade (vbg_1.0_fresh), one with failed upgrade (vbg_upgrade_error) and one with create table and failed upgradesettings (vbg_upgradesettings_error)
you can reach them REMOVED

[Chuck S]

I removed any info above

feel free to send full site info including urls admin login and urls to forum gallery and ftp info and phpmyadmin info to the contact us link in our header above.

I can then look as yours is a unique situation as all rc or beta software is suppose to be destroyed once a gold version comes out and your not even using the gold first release so there are bound to be issues.

[Marcski]

info sent

[Chuck S]

PhotoPost vBGallery

[Marcski]

thanks, what did you do?
This is a testserver and production needs to be updated too

[Chuck S]

well I just dealt with the issues one at a time as I beleive there might have been issues with one the latest mysql version and two running non supported old code for so long. Feel free to contact me if you run into any issues.

[Marcski]

Originally Posted by Chuck S

Feel free to contact me if you run into any issues.

There must be another way for me to do it myself and minimize downtime on production, I can't wait for you to fix it for me...

[Chuck S]

Given your unique situation that is all I can offer your running a non supported old pre-release code and I beleive there are a multitude of issues trying to run and upgrade it on new php and mysql as well as some other conflicts which one needs to work through as they are encountered.

[Marcski]

there must be a way to upgrade RC4 to a gold release, and upgrade vb and vbgallery from there? don't you have old versions of vbgallery i could use to upgrade?

Production server is running vB 3.0.12, php 5.1.6 and mysql 5.0.45

[Marcski]

and in all fairless, your "unsupported" doesn't apply because the upgarde manual explicitly states RC versions as upgradeble;
http://www.photopost.com/installphp-...y.html#upgrade

[Chuck S]

The issue here is there is no crystal ball. Everything would be a guess and I can not guess what would happen you may have totally different results on your production server.