vBulletin CMS Prevents Uninstalling of Products

[Lilmikeishere]

I'm using vBulletin 4.2.0 Patch Level 2. I did not upgrade to this version, I installed it like a week ago.

I disabled Blogs + CMS and added a few random products I found on different websites. Some products I want to uninstall though, and it doesn't let me and gives me a mySQL error with the CMS.

Here's the error I get:

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 'xxx.cms_widgettype' doesn't exist
Error Number : 1146
Request Date : Wednesday, September 26th 2012 @ 03:33:56 PM
Error Date : Wednesday, September 26th 2012 @ 03:33:57 PM
Script : http://xxx.com/admincp/plugin.php?do=productkill
Referrer : http://xxx.com/admincp/plugin.php?do=productdelete&productid=username_html_markup&s=
IP Address : 127.0.0.1
Username : xxx
Classname : vB_Database
MySQL Version : 5.5.23-55

[Lynne]

And does that table exist? Have you tried running the upgrade.php script again? Did you just disable the CMS or uninstall it?

[Lilmikeishere]

And does that table exist? Have you tried running the upgrade.php script again? Did you just disable the CMS or uninstall it?

Disabled it. I don't think I can uninstall it.

[Lynne]

And does that table exist? Have you tried running the upgrade.php script again?

[Lilmikeishere]

And does that table exist? Have you tried running the upgrade.php script again?

Yeah, I remember following this thread for guidance:
https://www.vbulletin.com/forum/showthread.php/402593-cms_widgettype-doesn-t-exist-eror

I re-ran the upgrade script and it froze at like 91% and then I exited out of it and later was able to uninstall various products which then ended up breaking my forum (in terms of the templates in the skins - even when i reverted them the whole skin was broken)

[Lynne]

You cannot only upgrade to 91% - that is not a complete upgrade and it will cause issues if you just quit then. Please do the upgrade again and click to View Details so you know exactly where in the script you are when it has problems.

[Lilmikeishere]

You cannot only upgrade to 91% - that is not a complete upgrade and it will cause issues if you just quit then. Please do the upgrade again and click to View Details so you know exactly where in the script you are when it has problems.

I already roll backed the forums to pre-upgrading.

Also, the upgrade crashed last time I tried it; I waited it out for like an hour before I closed it.

[Lynne]

So, you are fine now?

[Lilmikeishere]

So, you are fine now?

No... I can't uninstall any products and I get that error.

[Lynne]

I don't understand your comment about how you rolled back the forums then. Your database error says 4.2.0. Are you saying that your files are for a different version? Exactly what have you done and what is the state of your site right now (file version and database version)?