Issue: Upgrading from 211 to 212

Issue Tools
- View Changes

October 26, 2008 2:13 PM

vimto

Regular Member

Upgrading from 211 to 212

Error on line 1945

I've just tried the upgrade to 2.1.2 and received the following error:

Code:

Upgrading to 2.1.2

    * Creating Tables
          o Creating: vault_forummap
    * Updating Tables
          o Modifying: forum
          o Modifying: thread
          o Modifying: vault_namespace
          o Modifying: vault_link
          o Modifying: vault_article
    * Removing outdated extensions
    * Inserting Namespace Forum Map

      Fatal error: Call to a member function fetch_namespaceid() on a non-object in /home/bluedragon/public_html/forums/vault/install/special_upgrade.php on line 1945

This then creates an error when viewing certain pages in my wiki.

Issue Details

Issue Number 300

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 2.1.2

Fixed Version 2.1.2

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

October 26, 2008 2:28 PM

pegasus

VaultWiki Team

Redownload the ZIP and replace the file vault/install/special_upgrade.php. Then run the upgrade again.

Reply

October 26, 2008 2:40 PM

vimto

Regular Member

redownloaded and the upgrade process worked fine this time, although I am now getting another error on certain articles:

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
DELETE FROM vault_link WHERE type2 != 'nonforum'
				AND postid IN (16593,16593);

MySQL Error   : Unknown column 'type2' in 'where clause'
Error Number  : 1054
Request Date  : Sunday, October 26th 2008 @ 06:37:13 PM
Error Date    : Sunday, October 26th 2008 @ 06:37:14 PM
Script        : hxxp://www.bluedragons.co.uk/forums/showwiki.php?title=Wiki:Test+Page
Referrer      : hxxp://www.bluedragons.co.uk/forums/forumdisplay.php?f=38
IP Address    : xxx.xxx.xxx.xxx
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 4.1.20-log

October 26, 2008 2:49 PM

vimto

Regular Member

also getting the following error when creating/editing/deleting an article:

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

		SELECT postid
		FROM vault_link
		
		WHERE type2 = 'forum'
			AND targetid = 2455;

MySQL Error   : Unknown column 'type2' in 'where clause'
Error Number  : 1054
Request Date  : Sunday, October 26th 2008 @ 06:47:49 PM
Error Date    : Sunday, October 26th 2008 @ 06:47:49 PM
Script        : hxxp://www.bluedragons.co.uk/forums/inlinemod.php?do=dodeletethreads&threadids=2455
Referrer      : hxxp://www.bluedragons.co.uk/forums/inlinemod.php?forumid=38
IP Address    : xxx.xxx.xxx.xxx3
Username      : xxxxxxxx
Classname     : vB_Database
MySQL Version : 4.1.20-log

October 26, 2008 3:00 PM

pegasus

VaultWiki Team

There had been a problem with one of our install code functions that generated some bad SQL involving DROPping INDEXes. This caused a (suppressed) database error that prevented any of the DB changes in 2.1.2 from taking effect. I fixed the problem and re-updated your install.

The ZIP has been updated with this fix.

Reply
October 26, 2008 3:21 PM

vimto

Regular Member

Many thanks, seems to be working ok now

Reply

+ Reply

All times are GMT -4. The time now is 11:32 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: Upgrading from 211 to 212

Issue Tools