Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-28-2012, 06:11 AM
karma010 karma010 is offline
 
Join Date: Sep 2012
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default CMS related database error

Ok, so like a fool, I attempted to uninstall the CMS via Plugin Manager. It then gave me this error while attempting to uninstall it:

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

MySQL Error   : Table 'xxxx.cms_widgettype' doesn't exist
Error Number  : 1146
Request Date  : Sunday, October 28th 2012 @ 01:04:08 AM
Error Date    : Sunday, October 28th 2012 @ 01:04:08 AM
Script        : http://domain.com/admincp/plugin.php?do=productkill
Referrer      : http://domain.com/admincp/plugin.php?do=productdelete&productid=vbcms&s=
IP Address    : xxxx
Username      : xxxx
Classname     : vB_Database
MySQL Version : 5.5.23-55
Now whenever I try to uninstall any other plugins, I get that same database error and the plguin fails to uninstall. I tried running the upgrade script, but get another database error on step 31:

Code:
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 'xxxx.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 'xxxx.cms_node' doesn't exist<br />
<strong>Error Number</strong>  : 1146<br />
<strong>Request Date</strong>  : Sunday, October 28th 2012 @ 01:06:28 AM<br />
<strong>Error Date</strong>    : Sunday, October 28th 2012 @ 01:06:29 AM<br />
<strong>Script</strong>        : http://domain.com/install/upgrade.php<br />
<strong>Referrer</strong>      : http://domain.com/install/upgrade.php<br />
<strong>Classname</strong>     : vB_Database<br />
<strong>MySQL Version</strong> : 5.5.23-55<br />
So apparently when I attempted the CMS uninstall, it removed the database tables, but didn't complete the process? After some searching (which I should have done to begin with) I now realize that I should have just disabled the CMS, not uninstalled.

My question now is: How do I rectify this while still keeping my forum intact? As it is now, I can't uninstall any plugins...it just gives me the 1st database error I posted. Like I said, I tried the upgrade script, but that gives me an error, I tried manually adding the tables, still get errors, I tried reinstalling CMS using the XML file via Plugin Manager...another error.

Any help would be greatly appreciated!
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:20 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.11676 seconds
  • Memory Usage 2,395KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (1)post_thanks_box_bit
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete