PDA

View Full Version : unknown MySQL error.


Ua|Eight
02-11-2013, 08:21 PM
Hi guys,

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

https://vborg.vbsupport.ru/external/2013/02/18.jpg

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

https://vborg.vbsupport.ru/external/2013/02/19.jpg


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
02-11-2013, 08:27 PM
did you delete username_html_markup plugin

Ua|Eight
02-11-2013, 08:31 PM
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
02-11-2013, 08:33 PM
u cant delete it as it is already been deleted run upgrade.php (http://imperionx.org/forums/install/upgrade.php) to reinstall what is missing use the link I put here to do that

Ua|Eight
02-11-2013, 08:41 PM
u cant delete it as it is already been deleted run upgrade.php (http://imperionx.org/forums/install/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.

https://vborg.vbsupport.ru/external/2013/02/17.jpg


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
02-11-2013, 08:48 PM
try uploading all files first then run that

Ua|Eight
02-11-2013, 09:05 PM
try uploading all files first then run that

Which files? :O

--------------- Added 1360621043 at 1360621043 ---------------

https://vborg.vbsupport.ru/external/2013/02/16.jpg

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