• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 3.x Series
    • Bug
    • Step 4 of install/upgrade fails with database error

    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.

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

    • Issue Tools
      • View Changes
    1. issueid=729 July 27, 2009 11:29 PM
      tommythejoat tommythejoat is offline
      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)




    1. July 27, 2009 11:33 PM
      tommythejoat tommythejoat is offline
      Regular Member
      Am I supposed to be running the Install instead of the Upgrade script?
      Reply Reply  
    2. 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
      Reply Reply  
    3. July 27, 2009 11:58 PM
      pegasus pegasus is offline
      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 Reply  
    4. July 28, 2009 12:07 AM
      tommythejoat tommythejoat is offline
      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 Reply  
    5. July 28, 2009 12:11 AM
      pegasus pegasus is offline
      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 Reply  
    6. 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
      Reply Reply  
    7. July 28, 2009 12:26 AM
      tommythejoat tommythejoat is offline
      Regular Member
      If I delete vault_list by hand will this be OK?
      Reply Reply  
    8. July 28, 2009 12:32 AM
      pegasus pegasus is offline
      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 Reply  
    9. 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
      Reply Reply  
    10. July 28, 2009 1:00 AM
      pegasus pegasus is offline
      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 Reply  
    11. July 28, 2009 1:43 AM
      tommythejoat tommythejoat is offline
      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 Reply  
    12. July 28, 2009 2:20 AM
      pegasus pegasus is offline
      VaultWiki Team
      If they don't match, the Namespace Display Order overrides the selected forum's Display Order.
      Reply Reply  
    + Reply

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