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

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2010, 03:03 PM
pericolosogr pericolosogr is offline
 
Join Date: Mar 2007
Location: Greece
Posts: 85
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error when uninstalling a product

Each time i uninstall a product (any product) i get a database error!
This started happening since i upgraded to vb4!

The product is removed but i have to log back again to acp after refresh!

Do you know if this is a common issue and if there is somethin i could do about it?
Thanx

Example:

Code:
Database error in vBulletin 4.0.4:

Invalid SQL:
DELETE FROM  blocktype WHERE blocktypeid NOT IN (-1, 1, 2, 3, 4, 5, 6, 7);

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, August 16th 2010 @ 06:59:20 PM
Error Date    : Monday, August 16th 2010 @ 06:59:21 PM
Script        : http://www.xxxx.xx/admincp/plugin.php?do=productkill
Referrer      : http://www.xxxx.xx/admincp/plugin.php?do=productdelete&productid=digitalpoint_usermap&s=
IP Address    : 94.xx.xxx.xxx
Username      : xxxxxxxxxx
Classname     : vB_Database
MySQL Version :
Reply With Quote
  #2  
Old 08-16-2010, 04:00 PM
Eric's Avatar
Eric Eric is offline
 
Join Date: May 2006
Location: Kentucky
Posts: 792
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="http://dev.mysql.com/doc/refman/5.0/en/gone-away.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/gone-away.html</a>

More than likely, your mysql server timed out when vBulletin tried to run that query.
Reply With Quote
  #3  
Old 08-16-2010, 05:28 PM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

also make sure you've removed any extra .xml files in your includes folder
Reply With Quote
  #4  
Old 08-18-2010, 11:37 AM
pericolosogr pericolosogr is offline
 
Join Date: Mar 2007
Location: Greece
Posts: 85
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SecondV View Post
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

More than likely, your mysql server timed out when vBulletin tried to run that query.
This happens everytime i uninstall a product! Other than that everything runs like it should

Quote:
Originally Posted by Loco.M View Post
also make sure you've removed any extra .xml files in your includes folder
Yes i did, when upgrading to 4.0.6 i deleted every file and removed all the products and started over but i am having the same issues with database errors when uninstalling product!
Reply With Quote
  #5  
Old 08-18-2010, 02:28 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The database error is a server problem. You need to talk to your host about it in order to get it resolved.
Reply With Quote
Reply


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 01:43 PM.


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.05550 seconds
  • Memory Usage 2,200KB
  • Queries Executed 13 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (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_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
  • 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
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete