Issue: Uninstall issue

Issue Tools
- View Changes

September 8, 2009 10:23 AM

jawatkin

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

September 8, 2009 12:30 PM

jawatkin

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 :

September 8, 2009 12:39 PM

pegasus

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
September 8, 2009 1:45 PM

jawatkin

Junior Member

Can I just copy the new uninstall.php from the 2.5.2 installation package and attempt an uninstall again?

Reply
September 8, 2009 2:30 PM
pegasus

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
September 8, 2009 2:35 PM

jawatkin

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
September 8, 2009 3:02 PM

jawatkin

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
September 8, 2009 3:03 PM
pegasus

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

All times are GMT -4. The time now is 11:40 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

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

Issue: Uninstall issue

Issue Tools