Hướng dẫn fix lỗi khi uninstall và nâng cấp CMS VBB 4 "cms_widgettype doesn't exist eror"

[Admin]

Running 4.2.0 suite, but have the vbcms disabled.

Báo lỗi khi nâng cấp, cài đặt CMS VBB 4 cms_widgettype doesn't exist eror.

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

MySQL Error : Table 'xxxxxx.cms_widgettype' doesn't exist
Error Number : 1146
Request Date : Thursday, June 7th 2012 @ 12:27:39 AM
Error Date : Thursday, June 7th 2012 @ 12:27:40 AM
Script : xxxx
Referrer : xxxx
IP Address : xxxxxxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 5.1.52-cll

Để gở bỏ uninstall CMS bạn có thể dùng cách này.

Warning: This will delete any CMS data that you have. (But you should already know that as you are uninstalling/reinstalling it.)
Đăng nhập phpMyadmin
Run the following MySQL queries:

DROP TABLE IF EXISTS `cms_article`, `cms_category`, `cms_grid`, `cms_layout`, `cms_layoutwidget`, `cms_navigation`, `cms_node`, `cms_nodecategory`, `cms_nodeconfig`, `cms_nodeinfo`, `cms_permissions`, `cms_rate`, `cms_sectionorder`, `cms_widget`, `cms_widgetconfig`, `cms_widgettype`;DELETE FROM product WHERE productid = 'vbcms';DELETE FROM productcode WHERE productid = 'vbcms';DELETE FROM productdependency WHERE productid = 'vbcms';

Bây giờ bạn có thể Uninstall/Reinstall the CMS