vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   vBulletin CMS Prevents Uninstalling of Products (https://vborg.vbsupport.ru/showthread.php?t=288359)

Lilmikeishere 09-26-2012 07:35 PM

vBulletin CMS Prevents Uninstalling of Products
 
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:

Code:

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 09-26-2012 08:49 PM

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

Lilmikeishere 09-26-2012 09:46 PM

Quote:

Originally Posted by Lynne (Post 2368814)
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 09-26-2012 10:11 PM

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

Lilmikeishere 09-26-2012 10:15 PM

Quote:

Originally Posted by Lynne (Post 2368843)
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/show...n-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 09-26-2012 11:25 PM

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 09-26-2012 11:38 PM

Quote:

Originally Posted by Lynne (Post 2368864)
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 09-27-2012 01:54 AM

So, you are fine now?

Lilmikeishere 09-27-2012 02:49 AM

Quote:

Originally Posted by Lynne (Post 2368895)
So, you are fine now?

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

Lynne 09-27-2012 03:19 PM

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)?


All times are GMT. The time now is 07:05 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02037 seconds
  • Memory Usage 1,732KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete