Issue: MySQL Error in Upgrade to 3.0

Issue Tools
- View Changes

January 6, 2010 3:09 PM

Mokonzi

Senior Member

MySQL Error in Upgrade to 3.0

MySQL Error during the Upgrade process to 3.0

I'm getting this MySQL error immediately after the upgrade to 2.5.7 (starting from 2.5.6, it upgrades to 2.5.7 then the following):

PHP Code:

Database error in vBulletin 4.0.0: Invalid SQL: REPLACE INTO vb3_vault_upgradelog (upgradetype, version) VALUES ( '3X', '2.5.7' ); MySQL Error : Table 'vb3.vb3_vault_upgradelog' doesn't exist Error Number : 1146 Request Date : Wednesday, January 6th 2010 @ 08:07:19 PM Error Date : Wednesday, January 6th 2010 @ 08:07:20 PM Script : http://www.mysite.com/forum/vault/install/upgrade_3x257.php?step=3 Referrer : http://www.mysite.com/forum/vault/install/upgrade_3x257.php?step=2 IP Address : Username : Classname : vB_Database MySQL Version : 5.1.36-community-log

Issue Details

Issue Number 975

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 3.0.0 Beta 1

Fixed Version 3.0.0 Beta 1

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

January 6, 2010 3:42 PM

pegasus

VaultWiki Team

Yes this occurs if you upgrade from a version prior to 2.5.7 using the new script. Fixed in the current ZIP. In vault/install/upgradecore.php, find:

Code:

			$vbulletin->db->query_write("
				REPLACE INTO " . TABLE_PREFIX . "vault_upgradelog
					(upgradetype, version)
				VALUES
				(
					'" . $vbulletin->db->escape_string(VAULT_VERSION_KEY) . "',
					'" . $vbulletin->db->escape_string(VERSION) . "'
				)
			");

Replace with:

Code:

			if (VAULT_VERSION_KEY != '3X' OR is_newer_version(VERSION, '2.5.7'))
			{
				$vbulletin->db->query_write("
					REPLACE INTO " . TABLE_PREFIX . "vault_upgradelog
						(upgradetype, version)
					VALUES
					(
						'" . $vbulletin->db->escape_string(VAULT_VERSION_KEY) . "',
						'" . $vbulletin->db->escape_string(VERSION) . "'
					)
				");
			}

Then just refresh the page to update the version number.

January 6, 2010 7:30 PM

Mokonzi

Senior Member

Works a treat, thanks Peg.

Reply

+ Reply

All times are GMT -4. The time now is 11:13 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: MySQL Error in Upgrade to 3.0

Issue Tools