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!