Upgrade Issue

**Jav** · January 21, 2010

I recently upgrade my site to vbulletin 4 and that went well. Site is up and running.
VaultWiki was disabled and I proceeded to upgrade VaultWiki. Uploaded the files,
then ran the upgrade.php script. There was an error during the upgrade which might
have been

Code:

Warning: Invalid argument supplied for foreach() in [path]/vault/install/upgrade_3x254.php on line 119

I am also getting database errors when I try to access the Wiki

Code:

Database error in vBulletin 4.0.1:

Invalid SQL:

  SELECT albumpicture.*, album.*, user.username, user.usergroupid,
  IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
  FROM Forumalbumpicture AS albumpicture
  LEFT JOIN Forumalbum AS album ON(album.albumid = albumpicture.albumid)
  LEFT JOIN Forumuser AS user ON(user.userid = album.userid)
  WHERE album.state = 'public' 
  ORDER BY rand(NOW()) DESC LIMIT 0, 5;

MySQL Error   : Table 'database_namer.Forumalbumpicture' doesn't exist
Error Number  : 1146
Request Date  : Friday, January 22nd 2010 @ 12:57:44 AM
Error Date    : Friday, January 22nd 2010 @ 12:57:44 AM
Script        : http://www.myforum.com/Forum/index.php
Referrer      : http://www.myforum.com/Forum/forumdisplay.php?33-General-Chat
IP Address    : 125.14.164.110
Username      : XYZ
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.82-msl-usrs-sure2-log

Can you tell me what went wrong?

Maybe related. In the download page there is the top download for Wiki 3.0.0 Beta 2 ( or such )
and then there are 4 or 5 downloads under that. Do I need to download and install these when
i do the upgrade?

Thank you.

**pegasus** · January 21, 2010

The error you saw during the upgrade was not serious and it basically meant there was nothing for that step to do because you weren't using the feature it was updating. I have updated that step for the next release to suppress the error.

As for the problems with VaultWiki - that database query is not added by VaultWiki, it doesn't do anything with the album table. It's possible there is another mod doing this, or that this is a bug in vBulletin 4.

When upgrading, you only ever have to download the most recent version you want to use. The installer will automatically do the steps in between. Earlier versions are mainly listed for addon developers and for users whose licenses are expired and can't access the newer releases.

**Jav** · January 21, 2010

What I meant was in the Details and Options section of my member area, there is the main
download and then there are 5 sub downloads. When i perform an upgrade do I need to just
use the main download package or should I down load and install these as well?
Download
CES VaultWiki Categories
Download
CES VaultWiki Special Images
Download
CES VaultWiki Special Xpages
Download
CES VaultWiki Special Xredirects
Download
CES VaultWiki Parser Extensions
Download

Also, if possible can someone from VaultWiki check what is happenig on my forum.
The errors I posted may not have anything to do with the issue I am seeing. I can
provide admin access if necessary.

**Jav** · January 21, 2010

This is also interesting. When I go to Product Manager in Vb4 I see this

Product CES VaultWiki is out of date.
Installed Version 2.5.4
Latest Version 3.0.0 Beta 2 (Unstable)
Click here for more information!

**Jav** · January 21, 2010

Also, I had disabled all plug ins except VaultWiki, when I did the install and they are still disabled.

**Jav** · January 22, 2010

Tried to run the install process again and found

Code:

Database error in vBulletin 4.0.1:

Invalid SQL:

		ALTER TABLE Forumvault_namespace
		ADD COLUMN path VARCHAR(255) NOT NULL DEFAULT '';

MySQL Error   : Duplicate column name 'path'
Error Number  : 1060
Request Date  : Friday, January 22nd 2010 @ 01:40:15 PM
Error Date    : Friday, January 22nd 2010 @ 01:40:15 PM
Script        : http://www.mydomain.com/Forum/vault/install/upgrade_3x300b2.php?step=1
Referrer      : http://www.mydomain.com/Forum/vault/install/upgrade_3x300b2.php
IP Address    : 214.112.133.44
Username      : Me
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.82-msl-usrs-sure2-log

Interestingly also, when I turn off the Wiki I can view the threads. When the Wiki is ON i cannot.

**pegasus** · January 22, 2010

As of version 3.0.0, you don't need to install the sub-downloads separately. They are there for users who still want to use v2.

Sure I can check what is happening on your forum. Just send me a PM.