PDA

View Full Version : Database error when uninstalling a product


pericolosogr
08-16-2010, 03:03 PM
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:

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 :

Eric
08-16-2010, 04:00 PM
<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.

Brandon Sheley
08-16-2010, 05:28 PM
also make sure you've removed any extra .xml files in your includes folder

pericolosogr
08-18-2010, 11:37 AM
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

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!

Lynne
08-18-2010, 02:28 PM
The database error is a server problem. You need to talk to your host about it in order to get it resolved.