The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
CMS related database error
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:
Code:
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 Code:
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 /> 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! |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|