• 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 4.x Series
    • Bug
    • Fatal Error on Upgrading (Alpha 1)

    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: Fatal Error on Upgrading (Alpha 1)

    • Issue Tools
      • View Changes
    1. issueid=3228 July 24, 2013 5:05 PM
      Morrus Morrus is offline
      Regular Member
      Fatal Error on Upgrading (Alpha 1)

      So I bit the bullet, renewed the license, and set aside the evening for the upgrade.

      I *think* I followed the instruction correctly, but the install script gives me this when I navgigate to it:
      Code:
      Fatal error: Cannot redeclare class vw_Install_UpgradePath_Steps_400alpha2_3X_Controller in /vault/core/controller/install/upgradepath/steps/4/0/0/alpha/2/4X/vw.php on line 79
      What am I doing wrong?
    Issue Details
    Issue Number 3228
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.0 Beta 3
    Fixed Version 4.0.0 Beta 3
    Milestone VaultWiki 4 Beta X
    Software DependencyAny
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 1
    Assigned Users (none)
    Tags (none)


    Page 1 of 4 123 ... Next LastLast


    1. July 24, 2013 7:45 PM
      Morrus Morrus is offline
      Regular Member
      Hmm. This is suboptimal. I tried to reactivate the wiki in the meantime (re-enable product, switch back on in Server Settings, set wiki forums back to visible), but I just get the forum page when I click on the wiki link. I guess uploading all those files busted the original install?

      Any help would be appreciated. Right now, I got nothing!
      Reply Reply  
    2. July 24, 2013 11:47 PM
      pegasus pegasus is offline
      VaultWiki Team
      I don't know how this bug never got reported back when Alpha 2 was released, but to fix, open the file vault/core/controller/install/upgradepath/steps/4/0/0/alpha/2/4X/vw.php, and find:
      Code:
      class vw_Install_UpgradePath_Steps_400alpha2_3X_Controller extends vw_Install_UpgradePath_Steps_Controller
      Replace with:
      Code:
      class vw_Install_UpgradePath_Steps_400alpha2_4X_Controller extends vw_Install_UpgradePath_Steps_Controller
      Reply Reply  
    3. July 25, 2013 4:19 AM
      Morrus Morrus is offline
      Regular Member
      That fixed that; thanks.

      The install script started OK, but now it seems to be hung on 7%. I've left it alone for quite some time now.

      I'm not able to tell what stage that's at, because (in Firefox at least) there's a box with a scrollbar where the progress is listed, but the progress list is longer than the box and the scrollbar can't be selected.
      Reply Reply  
    4. July 25, 2013 4:24 AM
      Morrus Morrus is offline
      Regular Member
      Here's where it's hung. That scrollbar doesn't do anything.

      (Dunno what happened to the image dimensions there - got stretched or something. Bu you should be able to see it).
      Reply Reply  
    5. July 25, 2013 8:10 AM
      Morrus Morrus is offline
      Regular Member
      A second attempt stalls it at 1%.
      Reply Reply  
    6. July 25, 2013 9:32 AM
      pegasus pegasus is offline
      VaultWiki Team
      You will have to perform the upgrade in manual mode. Simply put ?step=1 after the install URL to enter manual mode. Once you get past the problematic step, feel free to re-enter auto-mode by requesting the page without a step parameter.
      Reply Reply  
    7. July 25, 2013 9:34 AM
      Morrus Morrus is offline
      Regular Member
      OK, I continued on with the manual thing (yeah, I know, that was quick!)

      That helped. Next 30 seconds of progress completed! Now we have a database error at:

      Upgrading to 4.0.0 Alpha 1
      Step 15

      creating_empty_main_pages
      Code:
      Database Error 	Database error
      The EN World: RPG News & Reviews database has encountered a problem.
      Please try the following:
      
          Load the page again by clicking the Refresh button in your web browser.
          Open the [url]www.enworld.org[/url] home page, then try to open another page.
          Click the Back button to try another link.
      
      The [url]www.enworld.org[/url] forum technical staff have been notified of the error, though you may contact them if the problem persists.
       
      We apologise for any inconvenience.
      
      Database error in vBulletin 4.2.1:
      
      Invalid SQL:
      UPDATE `vw_area` SET `pageid` =  CASE `areaid` 
      		 WHEN 1 THEN  
      		 WHEN 2 THEN  
      		 WHEN 3 THEN  
      		 WHEN 4 THEN  
      		 WHEN 5 THEN  
      		 WHEN 6 THEN  
      		 WHEN 7 THEN  
      		 WHEN 8 THEN  
      		 WHEN 9 THEN  
      		 WHEN 10 THEN  
      		 WHEN 11 THEN  
      	 END  WHERE  `areaid` IN (1,2,3,4,5,6,7,8,9,10,11);
      
      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 'WHEN 2 THEN  
      		 WHEN 3 THEN  
      		 WHEN 4 THEN  
      		 WHEN 5 THEN  
      		 WHEN 6 THEN ' at line 3
      Error Number  : 1064
      Request Date  : Thursday, July 25th 2013 @ 09:30:04 AM
      Error Date    : Thursday, July 25th 2013 @ 09:30:04 AM
      Script        : [url]http://www.enworld.org/forum/vault/install/index.php[/url]
      Referrer      : [url]http://www.enworld.org/forum/vault/install/index.php[/url]
      IP Address    : 
      Username      : Morrus
      Classname     : vB_Database
      MySQL Version : 5.5.29
      Reply Reply  
    8. July 25, 2013 9:42 AM
      pegasus pegasus is offline
      VaultWiki Team
      Since there are bugs affecting your upgrade, I have added a free Upgrade Service to your Members area here. Please fill it out and I will see what I can do.
      Reply Reply  
    9. July 25, 2013 9:49 AM
      Morrus Morrus is offline
      Regular Member
      Quote Originally Posted by pegasus View Post
      Since there are bugs affecting your upgrade, I have added a free Upgrade Service to your Members area here. Please fill it out and I will see what I can do.
      Done; thanks. I'll be glad to get this upgrade over and done with!
      Reply Reply  
    10. July 25, 2013 10:51 AM
      pegasus pegasus is offline
      VaultWiki Team
      Fixed in the current ZIP. With some new features, there were some regressions that affected the upgrade process from VW3 to Alpha 1.
      Reply Reply  
    11. July 25, 2013 10:55 AM
      Morrus Morrus is offline
      Regular Member
      Does that mean I should continue with the upgrade, or are you doing it? (Don't want to cross the streams!)
      Reply Reply  
    12. July 25, 2013 12:26 PM
      Morrus Morrus is offline
      Regular Member
      Sorry, I'm not trying to bug you, but could you let me know if I should be doing anything?
      Reply Reply  
    13. July 25, 2013 12:27 PM
      pegasus pegasus is offline
      VaultWiki Team
      I would set aside your last database backup in case you notice problems with the imported data.
      Due to the issues we had earlier with upgrading your site, some pages were imported twice.

      Go to AdminCP > VaultWiki > Admin Panel > Integrity > URL Conflicts. Try to resolve each one.

      For types of "Page,Area", only delete areas that don't have pages inside (it will tell you if it does).
      For duplicate "Page" or "Redirect", compare the text content. If none is shown, I would keep the very last item in the list and delete the rest.

      If you notice even after this that the wiki is still messed up, create a new database with your database backup and fill out the info in vault/core/controller/import/config/vw.php and let me know.

      You do NOT need to restore your database. With the importer rather than the upgrader we can try as many times as we need to get the data without a problem. We may alter the upgrade process and just recommend this course in the future, since it's much much safer.
      Reply Reply  
    14. July 25, 2013 12:43 PM
      Morrus Morrus is offline
      Regular Member
      I have the db from last night. Hopefully it won't be needed, as plenty of people have posted on the boards since.

      OK, I'll take a look at the URL Conflicts thing. Not sure what I'm doing there though.

      So, very quick glance, lots of issues immediately apparent:

      There seems to be content missing. For example this page:

      http://www.enworld.org/forum/showwik...WotC-Employees

      Had a great big long table of information on it.

      This page:

      http://www.enworld.org/forum/showwik...title=Numenera

      Gives a database error.

      This page:

      http://www.enworld.org/forum/showwik...itle=Wiki-Home

      Was my main/home page. Now it's completely blank.

      (From what I can tell, all the table on pages have been erased; I use a *lot* of tables via the standard vB4 WYSIWIG editor).

      Comments are all missing from pages - there were some lengthy discussions on some of them.

      I assume the old wiki forums are not deleted, so all the content is still OK in there at least?
      Reply Reply  
    15. July 25, 2013 12:48 PM
      Morrus Morrus is offline
      Regular Member
      Attempt to delete a duplicate node gave a database error:
      Code:
      Database error in vBulletin 4.2.1:
      
      Invalid SQL:
      DELETE FROM `vw_report` WHERE itemtypeid = 1 AND  `itemid` IN (596);
      
      MySQL Error   : Table 'enworld.vw_report' doesn't exist
      Error Number  : 1146
      Request Date  : Thursday, July 25th 2013 @ 12:45:25 PM
      Error Date    : Thursday, July 25th 2013 @ 12:45:25 PM
      Script        : http://www.enworld.org/forum/admincp/wiki_cp.php?panel=conflict&do=update
      Referrer      : http://www.enworld.org/forum/admincp/wiki_cp.php?panel=conflict&prefixid=6&key=monsters-dragons&do=edit
      IP Address    : 81.101.96.161
      Username      : Morrus
      Classname     : vB_Database
      MySQL Version : 5.5.29
      Reply Reply  
    Page 1 of 4 123 ... Next LastLast
    + 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 11:16 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.