karma010
10-28-2012, 06:11 AM
Ok, so like a fool, I attempted to uninstall the CMS via Plugin Manager. It then gave me this error while attempting to uninstall it:
Database error in vBulletin 4.2.0:
Invalid SQL:
DELETE cms_widgettype, cms_widget, cms_widgetconfig
FROM package AS package
LEFT JOIN cms_widgettype AS cms_widgettype
ON cms_widgettype.packageid = package.packageid
LEFT JOIN cms_widget AS cms_widget
ON cms_widget.widgettypeid = cms_widgettype.widgettypeid
LEFT JOIN cms_widgetconfig AS cms_widgetconfig
ON cms_widgetconfig.widgetid = cms_widget.widgetid
WHERE package.productid = 'vbcms';
MySQL Error : Table 'xxxx.cms_widgettype' doesn't exist
Error Number : 1146
Request Date : Sunday, October 28th 2012 @ 01:04:08 AM
Error Date : Sunday, October 28th 2012 @ 01:04:08 AM
Script : http://domain.com/admincp/plugin.php?do=productkill
Referrer : http://domain.com/admincp/plugin.php?do=productdelete&productid=vbcms&s=
IP Address : xxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 5.5.23-55
Now whenever I try to uninstall any other plugins, I get that same database error and the plguin fails to uninstall. I tried running the upgrade script, but get another database error on step 31:
Action Required
Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<?xml version="1.0" encoding="windows-1252"?>
<errors>
<error><![CDATA[<p>Database Error</p>
Invalid SQL:
SELECT COUNT(*) AS count
FROM cms_node
WHERE nodeid <> 1;
Table 'xxxx.cms_node' doesn't exist]]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.2.0</p>
<p>Invalid SQL:
SELECT COUNT(*) AS count
FROM cms_node
WHERE nodeid <> 1;<p>
<p>
<strong>MySQL Error</strong> : Table 'xxxx.cms_node' doesn't exist<br />
<strong>Error Number</strong> : 1146<br />
<strong>Request Date</strong> : Sunday, October 28th 2012 @ 01:06:28 AM<br />
<strong>Error Date</strong> : Sunday, October 28th 2012 @ 01:06:29 AM<br />
<strong>Script</strong> : http://domain.com/install/upgrade.php<br />
<strong>Referrer</strong> : http://domain.com/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.5.23-55<br />
So apparently when I attempted the CMS uninstall, it removed the database tables, but didn't complete the process? After some searching (which I should have done to begin with) I now realize that I should have just disabled the CMS, not uninstalled.
My question now is: How do I rectify this while still keeping my forum intact? As it is now, I can't uninstall any plugins...it just gives me the 1st database error I posted. Like I said, I tried the upgrade script, but that gives me an error, I tried manually adding the tables, still get errors, I tried reinstalling CMS using the XML file via Plugin Manager...another error.
Any help would be greatly appreciated!
Database error in vBulletin 4.2.0:
Invalid SQL:
DELETE cms_widgettype, cms_widget, cms_widgetconfig
FROM package AS package
LEFT JOIN cms_widgettype AS cms_widgettype
ON cms_widgettype.packageid = package.packageid
LEFT JOIN cms_widget AS cms_widget
ON cms_widget.widgettypeid = cms_widgettype.widgettypeid
LEFT JOIN cms_widgetconfig AS cms_widgetconfig
ON cms_widgetconfig.widgetid = cms_widget.widgetid
WHERE package.productid = 'vbcms';
MySQL Error : Table 'xxxx.cms_widgettype' doesn't exist
Error Number : 1146
Request Date : Sunday, October 28th 2012 @ 01:04:08 AM
Error Date : Sunday, October 28th 2012 @ 01:04:08 AM
Script : http://domain.com/admincp/plugin.php?do=productkill
Referrer : http://domain.com/admincp/plugin.php?do=productdelete&productid=vbcms&s=
IP Address : xxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 5.5.23-55
Now whenever I try to uninstall any other plugins, I get that same database error and the plguin fails to uninstall. I tried running the upgrade script, but get another database error on step 31:
Action Required
Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<?xml version="1.0" encoding="windows-1252"?>
<errors>
<error><![CDATA[<p>Database Error</p>
Invalid SQL:
SELECT COUNT(*) AS count
FROM cms_node
WHERE nodeid <> 1;
Table 'xxxx.cms_node' doesn't exist]]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.2.0</p>
<p>Invalid SQL:
SELECT COUNT(*) AS count
FROM cms_node
WHERE nodeid <> 1;<p>
<p>
<strong>MySQL Error</strong> : Table 'xxxx.cms_node' doesn't exist<br />
<strong>Error Number</strong> : 1146<br />
<strong>Request Date</strong> : Sunday, October 28th 2012 @ 01:06:28 AM<br />
<strong>Error Date</strong> : Sunday, October 28th 2012 @ 01:06:29 AM<br />
<strong>Script</strong> : http://domain.com/install/upgrade.php<br />
<strong>Referrer</strong> : http://domain.com/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.5.23-55<br />
So apparently when I attempted the CMS uninstall, it removed the database tables, but didn't complete the process? After some searching (which I should have done to begin with) I now realize that I should have just disabled the CMS, not uninstalled.
My question now is: How do I rectify this while still keeping my forum intact? As it is now, I can't uninstall any plugins...it just gives me the 1st database error I posted. Like I said, I tried the upgrade script, but that gives me an error, I tried manually adding the tables, still get errors, I tried reinstalling CMS using the XML file via Plugin Manager...another error.
Any help would be greatly appreciated!