unknown MySQL error.

[Ua|Eight]

Hi guys,

Whenever I try to uninstall a product, I get an DB error.
Here is a picture:



When trying to reinstalling the CMS I get the same error:

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 = 'username_html_markup';

MySQL Error   : Table 'blackout_forums.cms_widgettype' doesn't exist
Error Number  : 1146
Request Date  : Monday, February 11th 2013 @ 03:20:43 PM
Error Date    : Monday, February 11th 2013 @ 03:20:44 PM
Script        : http://imperionx.org/forums/admincp/plugin.php?do=productkill
Referrer      : http://imperionx.org/forums/admincp/plugin.php?do=productdelete&productid=username_html_markup&s=
IP Address    : *******
Username      : Paiman
Classname     : vB_Database
MySQL Version : 5.5.23-55

I hope someone can help me out with that I should do here.

[ForceHSS]

did you delete username_html_markup plugin

[Ua|Eight]

Originally Posted by ForceHSS

did you delete username_html_markup plugin

Problem is, I can't delete it.

I can't find the XML on the server either..

[ForceHSS]

u cant delete it as it is already been deleted run upgrade.php to reinstall what is missing use the link I put here to do that

[Ua|Eight]

Originally Posted by ForceHSS

u cant delete it as it is already been deleted run upgrade.php to reinstall what is missing use the link I put here to do that

This is the error I get, when doing that.

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 'blackout_forums.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 'blackout_forums.cms_node' doesn't exist<br />
<strong>Error Number</strong>  : 1146<br />
<strong>Request Date</strong>  : Monday, February 11th 2013 @ 03:39:54 PM<br />
<strong>Error Date</strong>    : Monday, February 11th 2013 @ 03:39:55 PM<br />
<strong>Script</strong>        : http://imperionx.org/forums/install/upgrade.php<br />
<strong>Referrer</strong>      : http://imperionx.org/forums/install/upgrade.php<br />
<strong>Classname</strong>     : vB_Database<br />
<strong>MySQL Version</strong> : 5.5.23-55<br />
</p>]]></error_html>
</errors>

[ForceHSS]

try uploading all files first then run that

[Ua|Eight]

Originally Posted by ForceHSS

try uploading all files first then run that

Which files? :O

--------------- Added [DATE]1360621043[/DATE] at [TIME]1360621043[/TIME] ---------------



Thats the only thing I had to upload.
Could you PM me your skype for an IM?