• 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
    • Uninstall 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.

    Issue: Uninstall issue

    • Issue Tools
      • View Changes
    1. issueid=819 September 8, 2009 10:23 AM
      jawatkin jawatkin is offline
      Junior Member
      Uninstall issue
      Tried to uninstall, database error and broke forum.

      Hi there, tried to uninstall the product. I uninstalled the plugins first with no issue. When I tried to uninstall the main product, I got the following database error:
      Code:
      Database error in vBulletin 3.8.2:
      
      Invalid SQL:
      
      		ALTER TABLE thread
      		
      	DROP vault_description
      	DROP INDEX firstpostid;
      
      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 'DROP INDEX firstpostid' at line 4
      Error Number  : 1064
      Request Date  : Tuesday, September 8th 2009 @ 10:07:47 AM
      Error Date    : Tuesday, September 8th 2009 @ 10:07:48 AM
      Script        : http://www.removed.com/forum/acp/plugin.php?do=productkill
      Referrer      : http://www.removed.com/forum/acp/plugin.php?do=productdelete&productid=ces_nwsp_spec
      IP Address    : removed
      Username      : removed
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.0.45
      Immediately following, I got about 500 database errors from users. It happened when trying to access a thread in any forum, Wiki or non-Wiki.

      Code:
      Database error in vBulletin 3.8.2:
      
      Invalid SQL:
      
      			SELECT IF(visible = 2, 1, 0) AS isdeleted,
      			
      
      			
      			thread.*
      			
      			, article.*, thread.threadid
      			FROM thread AS thread
      			
      			
      			
      			
      			
      			
      	LEFT JOIN vault_article AS article ON (thread.threadid = article.threadid)
      			WHERE thread.threadid = 373422;
      
      MySQL Error   : Table 'removed.vault_article' doesn't exist
      Error Number  : 1146
      Request Date  : Tuesday, September 8th 2009 @ 10:07:49 AM
      Error Date    : Tuesday, September 8th 2009 @ 10:07:49 AM
      Script        : http://www.removed.com/forum/f139/asian-8-25-rare-7pm-kt-373422/index44.html
      Referrer      : 
      IP Address    : 66.249.71.90
      Username      : Unregistered
      Classname     : vB_Database_MySQLi
      MySQL Version :
      Shut down the forum and figured out that I could just "disable" the product to get things working again.

      Any further attempts to uninstall give the following error

      Code:
      Database error in vBulletin 3.8.2:
      
      Invalid SQL:
      
      	SELECT bbcodetag
      	FROM vault_namespace;
      
      MySQL Error   : Table 'removed.vault_namespace' doesn't exist
      Error Number  : 1146
      Request Date  : Tuesday, September 8th 2009 @ 10:15:40 AM
      Error Date    : Tuesday, September 8th 2009 @ 10:15:40 AM
      Script        : http://removed.com/forum/acp/plugin.php?do=productkill
      Referrer      : http://www.removed.com/forum/acp/plugin.php?do=productdelete&productid=ces_nwsp_spec
      IP Address    : removed 
      Username      : removed
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.0.45
      I would like it completely removed, but how do I do this?

      Also, this is a really serious bug for someone who may uninstall and get stuck and not figure out that you can simply disable the product and continue on....

      Thanks!
    Issue Details
    Issue Number 819
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Install / Upgrade
    Status Duplicate
    Priority 2 - Fatal / Database Errors
    Affected Version 2.5.0
    Fixed Version (none)
    Milestone (none)
    Software DependencyvBulletin 3.8
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags uninstall




    1. September 8, 2009 12:30 PM
      jawatkin jawatkin is offline
      Junior Member
      Also, adding a follow-up... My cron won't run either.

      Code:
      Database error in vBulletin 3.8.2:
      
      Invalid SQL:
      UPDATE language SET title = title, phrasegroup_reputationlevel = 'a:15:{s:11:\"reputation1\";s:30:\"is infamous around these parts\";s:12:\"reputation10\";s:29:\"is a glorious beacon of light\";s:12:\"reputation11\";s:22:\"is a name known to all\";s:12:\"reputation12\";s:27:\"is a splendid one to behold\";s:12:\"reputation13\";s:23:\"has much to be proud of\";s:12:\"reputation14\";s:22:\"has a brilliant future\";s:12:\"reputation15\";s:30:\"has a reputation beyond repute\";s:11:\"reputation2\";s:24:\"can only hope to improve\";s:11:\"reputation3\";s:44:\"has a little shameless behaviour in the past\";s:11:\"reputation4\";s:36:\"is an unknown quantity at this point\";s:11:\"reputation5\";s:26:\"is on a distinguished road\";s:11:\"reputation6\";s:30:\"will become famous soon enough\";s:11:\"reputation7\";s:28:\"has a spectacular aura about\";s:11:\"reputation8\";s:23:\"is a jewel in the rough\";s:11:\"reputation9\";s:19:\"is just really nice\";}', phrasegroup_infractionlevel = 'a:7:{s:22:\"infractionlevel1_title\";s:22:\"Spammed Advertisements\";s:22:\"infractionlevel2_title\";s:24:\"Insulted Other Member(s)\";s:22:\"infractionlevel3_title\";s:24:\"Signature Rule Violation\";s:22:\"infractionlevel4_title\";s:22:\"Ina
      
      ..........................
      
      MySQL Error   : Unknown column 'phrasegroup_specialpages' in 'field list'
      Error Number  : 1054
      Request Date  : Tuesday, September 8th 2009 @ 11:00:01 AM
      Error Date    : Tuesday, September 8th 2009 @ 11:00:01 AM
      Script        : http://www.removed.com/forum/cron.php?rand=645706
      Referrer      : http://www.removed.com/forum/f248/regshs-mercantile-ye-olde-shoppe-four-314489/index75.html
      IP Address    : removed
      Username      : Unregistered
      Classname     : vB_Database_MySQLi
      MySQL Version :
      Reply Reply  
    2. September 8, 2009 12:39 PM
      pegasus pegasus is offline
      VaultWiki Team
      If you were running the most recent version of VaultWiki (2.5.2), this bug no longer exists. However, now you will have to open the file vault/install/uninstall.php and perform the changes listed there manually.

      If you encounter an error, it means that step was probably already performed, so move on to the next item.
      Reply Reply  
    3. September 8, 2009 1:45 PM
      jawatkin jawatkin is offline
      Junior Member
      Can I just copy the new uninstall.php from the 2.5.2 installation package and attempt an uninstall again?
      Reply Reply  
    4. September 8, 2009 2:30 PM
      pegasus pegasus is offline
      VaultWiki Team
      It's possible that some steps were already completed, so you should comment out the vw_ calls prior to:
      Code:
      vw_alter_table('thread'
      Reply Reply  
    5. September 8, 2009 2:35 PM
      jawatkin jawatkin is offline
      Junior Member
      This is getting complicated.. Can I install 2.5.2 as an upgrade and then uninstall or will this make things worse?
      Reply Reply  
    6. September 8, 2009 3:02 PM
      jawatkin jawatkin is offline
      Junior Member
      Forget it, I finally waded through the PHP and performed a successful uninstall. You could've informed me that "all the changes" included a simple comma that you left out in one of the queries.
      Reply Reply  
    7. September 8, 2009 3:03 PM
      pegasus pegasus is offline
      VaultWiki Team
      I expect this will make things worse.

      Adding the following line to the beginning of the uninstall file should help bypass any errors:
      Code:
      $db->hide_errors();
      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:37 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 © 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.