• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
      • Try XenForo Demo
      • New Posts
      • FAQ
      • Calendar
      • Community
        • Groups
        • Albums
        • Member List
      • Forum Actions
        • Mark Forums Read
      • Quick Links
        • Today's Posts
        • Who's Online
      • Sponsor
        • Sponsor a Feature
        • List of Donors
    • Wiki
    • Support
    • What's New?
    • Buy Now
    • Manual
    • 
    • Forum
    • VaultWiki How-Tos
    • VaultWiki Questions
    • Upgrade Issue

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

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Results 1 to 8 of 8

    Thread: Upgrade Issue

    • Thread Tools
      • Show Printable Version
    1. January 21, 2010 #1
      Jav
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Jav is offline
      Junior Member
      Join Date
      July 24, 2009
      Posts
      10
      Rep Power
      0

      Upgrade Issue

      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.
      Reply With Quote Reply With Quote

    2. January 21, 2010 #2
      pegasus
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • Visit Homepage
      • View Articles
      pegasus is offline
      VaultWiki Team
      Join Date
      March 28, 2004
      Location
      New York, NY
      Posts
      2,959
      Blog Entries
      18
      Rep Power
      687
      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.
      - lead developer for VaultWiki
      Reply With Quote Reply With Quote

    3. January 21, 2010 #3
      Jav
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Jav is offline
      Junior Member
      Join Date
      July 24, 2009
      Posts
      10
      Rep Power
      0
      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.
      Reply With Quote Reply With Quote

    4. January 21, 2010 #4
      Jav
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Jav is offline
      Junior Member
      Join Date
      July 24, 2009
      Posts
      10
      Rep Power
      0
      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!
      Reply With Quote Reply With Quote

    5. January 21, 2010 #5
      Jav
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Jav is offline
      Junior Member
      Join Date
      July 24, 2009
      Posts
      10
      Rep Power
      0
      Also, I had disabled all plug ins except VaultWiki, when I did the install and they are still disabled.
      Reply With Quote Reply With Quote

    6. January 22, 2010 #6
      Jav
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Jav is offline
      Junior Member
      Join Date
      July 24, 2009
      Posts
      10
      Rep Power
      0
      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.
      Reply With Quote Reply With Quote

    7. January 22, 2010 #7
      pegasus
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • Visit Homepage
      • View Articles
      pegasus is offline
      VaultWiki Team
      Join Date
      March 28, 2004
      Location
      New York, NY
      Posts
      2,959
      Blog Entries
      18
      Rep Power
      687
      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.
      - lead developer for VaultWiki
      Reply With Quote Reply With Quote

    8. January 23, 2010 #8
      Jav
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Jav is offline
      Junior Member
      Join Date
      July 24, 2009
      Posts
      10
      Rep Power
      0
      Valutwiki staff found the issue. I appreciate their excellent efforts.
      Reply With Quote Reply With Quote

    Similar Threads

    1. Issue with Attachments
      By OKCTalk in forum VaultWiki Questions
      Replies: 9
      Last Post: June 14, 2012, 8:04 AM
    2. Table issue
      By tagman in forum VaultWiki Questions
      Replies: 3
      Last Post: February 12, 2011, 3:52 PM
    3. Group issue
      By Jella in forum VaultWiki Questions
      Replies: 2
      Last Post: June 27, 2010, 8:40 AM
    4. Upgrade issue with Book and Default
      By mickknutson in forum VaultWiki Questions
      Replies: 5
      Last Post: May 14, 2009, 11:56 PM
    5. 2.2.3 PL1 Upgrade Issue
      By Home Alone in forum VaultWiki Questions
      Replies: 17
      Last Post: May 12, 2009, 8:28 PM

    Tags for this Thread

    able, all, also, another, any, are, automatically, because, been, between, can, cannot, check, com, date, details, did, does, doing, don, duplicate, files, for, from, get, getting, have, here, http, invalid, left, line, load, more, most, need, next, now, off, only, other, out, php, possible, public, see, should, someone, steps, sub, sure, that, the, their, there, this, threads, try, under, user, using, was, were, what, when, where, will, with, www, you, your

    View Tag Cloud

    Bookmarks

    Bookmarks
    • Submit to Digg Digg
    • Submit to del.icio.us del.icio.us
    • Submit to StumbleUpon StumbleUpon
    • Submit to Google Google

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  
    • BB code is On
    • Smilies are On
    • [IMG] code is Off
    • [VIDEO] code is
    • HTML code is Off

    Forum Rules

    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 6:44 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
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2025 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
    Copyright © 2008 - 2024 VaultWiki Team, Cracked Egg Studios, LLC.