Devilbrad
02-21-2014, 04:23 PM
I've been working on this with another member but thought I might get other opinions in this thread. Here's the recap, our forum is on 3.8.6 and im upgrading it to 4.x but setting up a test site first. Right now its at 4.0x but will soon go to 4.2.
I had the new forum installed and working and have been trying to restore it to show all our forum names etc while I play with getting it ready. I first tried to back it up using the CPanel backup, then used phpmyadmin. Neither worked due to timeout reasons.
Last night I tried with bigdump. Changed the URLs, exported with phpmyadmin, had the "ADD DROP TABLE" setting checked. Changed the bigdump.php DB config, uploaded and ran it as they said. I got:
Stopped at the line 410.
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts or very long procedure definitions. Please read the BigDump usage notes for more infos. Ask for our support services in order to handle dump files containing extended inserts.
So I created another backup with just structure (no data) and in .gz. Ran bigdump etc. Said that it worked ok but now the forum is messed up and says:
vBulletin datastore error caused by one or more of the following:
You may have uploaded vBulletin files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.
Fatal error: vBulletin datastore cache incomplete or corrupt in [path]/includes/init.php on line 247
So I run the install/upgrade.php and the URL gets changed to install/upgrade_363.php. Went around in circles upgrading to 3.63, 3.64, 3.65.... till 3.7, then got this error in Step 2) Altering Table Defaults
Database error in vBulletin :
Invalid SQL:
ALTER TABLE groupmessage
CHANGE groupid groupid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postuserid postuserid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postusername postusername VARCHAR(100) NOT NULL DEFAULT '',
CHANGE dateline dateline INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE ipaddress ipaddress INT UNSIGNED NOT NULL DEFAULT '0';
MySQL Error : Unknown column 'groupid' in 'groupmessage'
Error Number : 1054
Request Date : Friday, February 21st 2014 @ 11:18:27 AM
Error Date : Friday, February 21st 2014 @ 11:18:27 AM
Script : http://www.racemagnum.com/thefogpound/install/upgrade_370b3.php?step=2
Referrer : http://www.racemagnum.com/thefogpound/install/upgrade_370b3.php?step=1
IP Address : 24.92.208.4
Username :
Classname : vB_Database
MySQL Version : 5.5.32-31.0-log
Please help! I have no idea how im messing up a simple DB backup so bad!
I had the new forum installed and working and have been trying to restore it to show all our forum names etc while I play with getting it ready. I first tried to back it up using the CPanel backup, then used phpmyadmin. Neither worked due to timeout reasons.
Last night I tried with bigdump. Changed the URLs, exported with phpmyadmin, had the "ADD DROP TABLE" setting checked. Changed the bigdump.php DB config, uploaded and ran it as they said. I got:
Stopped at the line 410.
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts or very long procedure definitions. Please read the BigDump usage notes for more infos. Ask for our support services in order to handle dump files containing extended inserts.
So I created another backup with just structure (no data) and in .gz. Ran bigdump etc. Said that it worked ok but now the forum is messed up and says:
vBulletin datastore error caused by one or more of the following:
You may have uploaded vBulletin files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.
Fatal error: vBulletin datastore cache incomplete or corrupt in [path]/includes/init.php on line 247
So I run the install/upgrade.php and the URL gets changed to install/upgrade_363.php. Went around in circles upgrading to 3.63, 3.64, 3.65.... till 3.7, then got this error in Step 2) Altering Table Defaults
Database error in vBulletin :
Invalid SQL:
ALTER TABLE groupmessage
CHANGE groupid groupid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postuserid postuserid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postusername postusername VARCHAR(100) NOT NULL DEFAULT '',
CHANGE dateline dateline INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE ipaddress ipaddress INT UNSIGNED NOT NULL DEFAULT '0';
MySQL Error : Unknown column 'groupid' in 'groupmessage'
Error Number : 1054
Request Date : Friday, February 21st 2014 @ 11:18:27 AM
Error Date : Friday, February 21st 2014 @ 11:18:27 AM
Script : http://www.racemagnum.com/thefogpound/install/upgrade_370b3.php?step=2
Referrer : http://www.racemagnum.com/thefogpound/install/upgrade_370b3.php?step=1
IP Address : 24.92.208.4
Username :
Classname : vB_Database
MySQL Version : 5.5.32-31.0-log
Please help! I have no idea how im messing up a simple DB backup so bad!