|Marcski ||November 5th, 2011 10:47 AM |
Upgrade error 1.0 RC4 > 3.01
Trying to upgrade my testserver from 1.0 RC4 to 3.01, i get the following error;
Database error in vBulletin 4.1.7:
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 ||November 5th, 2011 01:50 PM |
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 ||November 5th, 2011 03:18 PM |
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;
putting a database backup back now and creating the table before running the full upgrade..
|Chuck S ||November 5th, 2011 03:37 PM |
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 ||November 5th, 2011 03:47 PM |
after the (failed) upgrade?
|Chuck S ||November 5th, 2011 03:53 PM |
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 ||November 5th, 2011 04:55 PM |
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...
|Marcski ||November 5th, 2011 04:58 PM |
adv_setting and adv_settinggroup tables do exist though;
SQL query: SELECT * FROM `adv_setting` WHERE `varname` LIKE '%gallery_version%' LIMIT 0 , 30;
varname grouptitle value defaultvalue optioncode displayorder
gallery_version adv_gallery_main 1.0 RC4 1.0 RC4 hidden 1
|Chuck S ||November 5th, 2011 05:28 PM |
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 ||November 6th, 2011 09:38 AM |
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 ||November 6th, 2011 02:03 PM |
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 ||November 6th, 2011 02:20 PM |
|Marcski ||November 6th, 2011 04:42 PM |
thanks, what did you do?
This is a testserver and production needs to be updated too
|Chuck S ||November 6th, 2011 05:04 PM |
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 ||November 7th, 2011 03:33 AM |
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 ||November 7th, 2011 07:04 AM |
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 ||November 7th, 2011 07:28 AM |
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
|Chuck S ||November 7th, 2011 07:45 AM |
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.
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0