[CMS] Getting error after upgrading to 4.2.0

[uday789]

Hi

i have upgarded to 4.2.0 from 4.1.12 and getting this error while trying to uninstall " VBulletin CMS " from manage products

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 '*********_downloadsmasti.cms_widgettype' doesn't exist
Error Number : 1146
Request Date : Friday, May 25th 2012 @ 07:58:53 PM
Error Date : Friday, May 25th 2012 @ 07:58:53 PM
Script : http://www.downloadsmasti.com/adminc...do=productkill
Referrer : http://www.downloadsmasti.com/adminc...uctid=vbcms&s=
IP Address : **************
Username : *************
Classname : vB_Database
MySQL Version : 5.1.62-cll

[Maurd]

It's a bug: http://tracker.vbulletin.com/browse/VBIV-15165

[uday789]

So No solution at the moment

[momilc]

Hello, I've the latest version PL2 and I have the same bug. No solution yet ?

[Mark.B]

This will be fixed in 4.2.1 I believe.

[Paul M]

Hello, I've the latest version PL2 and I have the same bug. No solution yet ?

Why are you trying to delete the CMS ?

If you dont want to use it, just disable it.

[flash84]

Only fix that I know is to put in a support ticket to the vbulletin team. If you try to reinstall the CMS at this stage it will skip all the steps and still wont work.

Maybe it's just me but I ran into this problem when I clicked on NO in the upgrade when it asked me "Do you want to install the default CMS data?" In my test install I clicked on YES to this question and the CMS worked fine with all the default articles. So in my proper site upgrade I clicked no because I didn't want to have all the default articles. Turns out the CMS default data is not the default articles but the entire CMS itself. I think a better wording in the vbulletin installer would be "Do you want to install the CMS?"

Be aware! If you have the CMS as the main default page to your site and then you go to uninstal it and get this CMS uninstall database error it will completely break your site with a "Database error" when you go to your main URL! Go back into the add on manager and disable the CMS to get your site working properly again.

[Paul M]

Turns out the CMS default data is not the default articles but the entire CMS itself. I think a better wording in the vbulletin installer would be "Do you want to install the CMS?"

The wording is correct, your assertion is not. All that installs is the default data. As I said before, why are you deleting the CMS in the first place ? if for some reason you dont intend you have it active at all, just disabled it, otherwise it will be re-installed anyway the next time you run the upgrader.