Issue: Step 4 of install/upgrade fails with database error

Issue Tools
- View Changes

July 27, 2009 11:29 PM

tommythejoat

Regular Member

Step 4 of install/upgrade fails with database error

as in the title

My system is down with this problem.

Issue Details

Issue Number 729

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 2.5.0

Fixed Version 2.5.0

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

July 27, 2009 11:33 PM

tommythejoat

Regular Member

Am I supposed to be running the Install instead of the Upgrade script?

Reply

July 27, 2009 11:57 PM

tommythejoat tommythejoat is offline

Regular Member

The following php errors occurred.

Code:

[27-Jul-2009 02:51:12] PHP Fatal error:  Call to undefined method stdClass::special_postbit_complete() in /var/www/html/vault/tabs/special_tab_article.php on line 396
[27-Jul-2009 08:49:21] PHP Fatal error:  Call to undefined method stdClass::special_postbit_complete() in /var/www/html/vault/tabs/special_tab_article.php on line 396
[27-Jul-2009 21:24:24] PHP Parse error:  syntax error, unexpected $end in /var/www/html/vault/special_plugins.php on line 744

July 27, 2009 11:58 PM

pegasus

VaultWiki Team

Your VaultWiki product should be disabled automatically during the upgrade. Since the upgrade didn't finish, I can't see why your forum would be inaccessible - the product would still be disabled.

I also can't see how you got all the way to step 4 before throwing a database error, since this table is accessed in both steps 1 and 3 as well. Also, since step 4 doesn't access this table, it again leads me to believe that the product is still enabled somehow.

Reply
July 28, 2009 12:07 AM

tommythejoat

Regular Member

I understand that by not specifying the file I started executing with upgrade_250.php instead of upgrade.php. Can I just restart the upgrade with upgrade.php?

I think the step information is stored somewhere. It immediately goes back to 250 and the database error.

Reply
July 28, 2009 12:11 AM

pegasus

VaultWiki Team

It also looks like your special_plugins.php file is truncated. Perhaps you downloaded at the precise moment we were performing maintenance on the download folder and it interrupted the transfer. I recommend downloading the files again before making another attempt.

You are by no means the first person to upgrade today, so hopefully this is some kind of fluke with the files. I'm still baffled how you got all the way to step 4.

Reply

July 28, 2009 12:25 AM

tommythejoat tommythejoat is offline

Regular Member

I redid the upload and started with .../vault/install/upgrade.php with the following error

Code:

Database error in vBulletin 3.8.3:

Invalid SQL:

		CREATE TABLE vault_list (
			threadid INT UNSIGNED NOT NULL DEFAULT '0',
			title_un VARCHAR(255) NOT NULL DEFAULT '',
			title_enc VARCHAR(255) NOT NULL DEFAULT '',
			namespaceid INT UNSIGNED NOT NULL DEFAULT '0',
			languageid INT UNSIGNED NOT NULL DEFAULT '0',
			INDEX threadid (threadid),
			INDEX encoded (title_enc),
			INDEX langspace (namespaceid, languageid)
		);

MySQL Error   : Table 'vault_list' already exists
Error Number  : 1050
Request Date  : Monday, July 27th 2009 @ 10:20:29 PM
Error Date    : Monday, July 27th 2009 @ 10:20:29 PM
Script        : http://mb.nawcc.org/vault/install/upgrade_250.php?step=1
Referrer      : http://mb.nawcc.org/vault/install/upgrade_250.php
IP Address    : 66.189.87.170
Username      : TMcIntyre
Classname     : vB_Database
MySQL Version : 5.0.27-standard

and this php error from the php error log.

Code:

27-Jul-2009 21:24:24] PHP Parse error:  syntax error, unexpected $end in /var/www/html/vault/special_plugins.php on line 744

July 28, 2009 12:26 AM

tommythejoat

Regular Member

If I delete vault_list by hand will this be OK?

Reply
July 28, 2009 12:32 AM

pegasus

VaultWiki Team

special_plugins.php is not supposed to end at line 744. Confirm that the file exists in full (your license info should appear at the bottom). If not, as I mentioned in my previous post, you will want to download the ZIP and replace your files again.

Then, since you stalled at step 4, I would just run /vault/install/upgrade_250.php?step=4 again.

Reply

July 28, 2009 12:43 AM

tommythejoat tommythejoat is offline

Regular Member

The file is all there. I tried restarting at step=4

Code:

Database error in vBulletin 3.8.3:

Invalid SQL:

				UPDATE vault_protect
				SET title = CASE protectid
					
WHEN 25 THEN ''
WHEN 7 THEN ''
WHEN 10 THEN ''
WHEN 12 THEN ''
WHEN 16 THEN ''
WHEN 46 THEN ''
WHEN 26 THEN ''
WHEN 27 THEN ''
WHEN 28 THEN ''
WHEN 29 THEN ''
WHEN 30 THEN ''
WHEN 31 THEN ''
WHEN 32 THEN ''
WHEN 33 THEN ''
WHEN 34 THEN ''
WHEN 35 THEN ''
WHEN 36 THEN ''
WHEN 37 THEN ''
WHEN 38 THEN ''
WHEN 39 THEN ''
WHEN 40 THEN ''
WHEN 41 THEN ''
WHEN 43 THEN ''
WHEN 45 THEN ''
WHEN 47 THEN ''
WHEN 48 THEN ''
WHEN 49 THEN ''
WHEN 50 THEN ''
				END,
					title_lower = CASE protectid
					
WHEN 5 THEN ''
WHEN 6 THEN ''
WHEN 7 THEN ''
WHEN 10 THEN ''
WHEN 11 THEN ''
WHEN 12 THEN ''
WHEN 14 THEN ''
WHEN 15 THEN ''
WHEN 16 THEN ''
WHEN 19 THEN ''
WHEN 22 THEN ''
WHEN 23 THEN ''
WHEN 24 THEN ''
WHEN 25 THEN ''
WHEN 26 THEN ''
WHEN 27 THEN ''
WHEN 28 THEN ''
WHEN 29 THEN ''
WHEN 30 THEN ''
WHEN 31 THEN ''
WHEN 32 THEN ''
WHEN 33 THEN ''
WHEN 34 THEN ''
WHEN 35 THEN ''
WHEN 36 THEN ''
WHEN 37 THEN ''
WHEN 38 THEN ''
WHEN 39 THEN ''
WHEN 40 THEN ''
WHEN 41 THEN ''
WHEN 43 THEN ''
WHEN 45 THEN ''
WHEN 46 THEN ''
WHEN 47 THEN ''
WHEN 48 THEN ''
WHEN 49 THEN ''
WHEN 50 THEN ''
				END
				WHERE protectid IN (,49318,50092,50109,50409,50806,52540,52531,52532,52249,52247,52221,52186,52182,52180,52158,52156,52142,52083,52590,52591,52592,49916,52667,52857,52853,52713,52712);

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 '49318,50092,50109,50409,50806,52540,52531,52532,52249,52247,52221,52186,52182,52' at line 73
Error Number  : 1064
Request Date  : Monday, July 27th 2009 @ 10:40:57 PM
Error Date    : Monday, July 27th 2009 @ 10:40:57 PM
Script        : http://mb.nawcc.org/vault/install/upgrade_250.php?step=4
Referrer      : 
IP Address    : 66.189.87.170
Username      : TMcIntyre
Classname     : vB_Database
MySQL Version : 5.0.27-standard

July 28, 2009 1:00 AM

pegasus

VaultWiki Team

The code didn't consider situations where titles were actually blocked via protection. Updated /vault/install/upgrade_250.php

Replace and run this step again.

Reply
July 28, 2009 1:43 AM

tommythejoat

Regular Member

Everything is installed. I will be working a while sorting out some of the namespaces. My sandbox is now visible even with display order 0.

Reply
July 28, 2009 2:20 AM

pegasus

VaultWiki Team

If they don't match, the Namespace Display Order overrides the selected forum's Display Order.

Reply

+ Reply

All times are GMT -4. The time now is 5:40 PM.

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: Step 4 of install/upgrade fails with database error

Issue Tools