Error when updating from 2.0.4 to 2.0.6

[princessbs]

Joomla 2.5.4
Virtuemart 2.0.4

I have tried upgrading via VM upgrade button and all 3 ways using Joomla extension installer. PHP max timeout is set at 300.

I receive this error in every case:

VmConfig::installVMConfig: COM_VIRTUEMART_SQL_ERROR DB function failed with error number 2006
MySQL server has gone away SQL=INSERT INTO `j2012_virtuemart_configs` (`virtuemart_config_id`, `config`) VALUES ('1', 'shop_is_offline=s:1:"0";|offline_message=czo3MzoiT3VyIFNob3AgaXMgY3VycmVudGx5IGRvd24gZm9yIG1haW50ZW5hbmNlLiBQbGVhc2UgY2hlY2sgYmFjayBhZ2FpbiBzb29uLiI7|use_as_catalog=s:1:"0";|currency_converter_module=s:14:"convertECB.php";|order_mail_html=s:1:"1";|dateformat=s:8:"%m/%d/%y";|useSSL=s:1:"0";|dangeroustools=s:1:"0";|debug_enable=s:4:"none";|google_jquery=s:1:"1";|multix=s:4:"none";|pdf_button_enable=s:1:"1";|show_emailfriend=s:1:"1";|show_printicon=s:1:"0";|show_out_of_stock_products=s:1:"1";|coupons_enable=s:1:"0";|coupons_default_expire=s:3:"1,D";|weight_unit_default=s:2:"KG";|lwh_unit_default=s:1:"m";|list_limit=s:2:"10";|showReviewFor=s:3:"all";|reviewMode=s:10:"registered";|showRatingFor=s:3:"all";|ratingMode=s:10:"registered";|reviews_autopublish=s:1:"1";|reviews_minimum_comment_length=s:3:"100";|reviews_maximum_comment_length=s:4:"2000";|vmtemplate=s:7:"default";|categorytemplate=s:7:"default";|showCategory=s:1:"1";|categorylayout=s:7:"default";|categories_per_row=s:1:"3";|productlayout=s:7:"default";|products_per_row=s:1:"3";|vmlayout=s:7:"default";|show_featured=s:1:"1";|featured_products_per_row=s:1:"3";|show_topTen=s:1:"1";|topten_products_per_row=s:1:"3";|show_recent=s:1:"1";|show_latest=s:1:"1";|assets_general_path=s:33:"components/com_virtuemart/assets/";|media_category_path=s:35:"images/stories/virtuemart/category/";|media_product_path=s:34:"images/stories/virtuemart/product/";|media_manufacturer_path=s:39:"images/stories/virtuemart/manufacturer/";|media_vendor_path=s:33:"images/stories/virtuemart/vendor/";|img_resize_enable=s:1:"1";|img_width=s:2:"90";|img_height=s:2:"90";|no_image_set=s:11:"noimage.gif";|no_image_found=s:11:"warning.png";|browse_orderby_field=s:23:"p.virtuemart_product_id";|browse_orderby_fields=a:4:{i:0;s:11:"product_sku";i:1;s:13:"category_name";i:2;s:7:"mf_name";i:3;s:12:"product_name";}|browse_search_fields=a:6:{i:0;s:11:"product_sku";i:1;s:13:"category_name";i:2;s:20:"category_description";i:3;s:7:"mf_name";i:4;s:12:"product_name";i:5;s:14:"product_s_desc";}|show_prices=s:1:"1";|price_access_level_published=s:1:"0";|price_show_packaging_pricelabel=s:1:"0";|show_tax=s:1:"1";|basePrice=s:1:"1";|basePriceText=s:1:"1";|basePriceRounding=s:1:"2";|variantModification=s:1:"1";|variantModificationText=s:1:"1";|variantModificationRounding=s:1:"2";|basePriceVariant=s:1:"1";|basePriceVariantText=s:1:"1";|basePriceVariantRounding=s:1:"2";|basePriceWithTax=s:1:"1";|basePriceWithTaxText=s:1:"1";|basePriceWithTaxRounding=s:1:"2";|discountedPriceWithoutTax=s:1:"1";|discountedPriceWithoutTaxText=s:1:"1";|discountedPriceWithoutTaxRounding=s:1:"2";|salesPriceWithDiscount=s:1:"1";|salesPriceWithDiscountText=s:1:"1";|salesPriceWithDiscountRounding=s:1:"2";|salesPrice=s:1:"1";|salesPriceText=s:1:"1";|salesPriceRounding=s:1:"2";|priceWithoutTax=s:1:"1";|priceWithoutTaxText=s:1:"1";|priceWithoutTaxRounding=s:1:"2";|discountAmount=s:1:"1";|discountAmountText=s:1:"1";|discountAmountRounding=s:1:"2";|taxAmount=s:1:"1";|taxAmountText=s:1:"1";|taxAmountRounding=s:1:"2";|check_stock=s:1:"0";|automatic_payment=s:1:"1";|automatic_shipment=s:1:"1";|agree_to_tos_onorder=s:1:"0";|oncheckout_show_legal_info=s:1:"1";|oncheckout_show_register=s:1:"1";|oncheckout_show_steps=s:1:"0";|oncheckout_show_register_text=s:47:"COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER";|seo_disabled=s:1:"0";|seo_translate=s:1:"0";|seo_use_id=s:1:"0";|soap_ws_cat_on=s:1:"0";|soap_ws_cat_cache_on=s:1:"1";|soap_auth_getcat=s:1:"1";|soap_auth_addcat=s:1:"1";|soap_auth_upcat=s:1:"1";|soap_auth_delcat=s:1:"1";|soap_auth_cat_otherget=s:1:"1";|soap_auth_cat_otheradd=s:1:"1";|soap_auth_cat_otherupdate=s:1:"1";|soap_auth_cat_otherdelete=s:1:"1";|soap_ws_user_on=s:1:"0";|soap_ws_user_cache_on=s:1:"1";|soap_auth_getuser=s:1:"1";|soap_auth_adduser=s:1:"1";|soap_auth_upuser=s:1:"1";|soap_auth_deluser=s:1:"1";|soap_auth_user_otherget=s:1:"1";|soap_auth_user_otheradd=s:1:"1";|soap_auth_user_otherupdate=s:1:"1";|soap_auth_user_otherdelete=s:1:"1";|soap_ws_prod_on=s:1:"0";|soap_ws_prod_cache_on=s:1:"1";|soap_auth_getprod=s:1:"1";|soap_auth_addprod=s:1:"1";|soap_auth_upprod=s:1:"1";|soap_auth_delprod=s:1:"1";|soap_auth_prod_otherget=s:1:"1";|soap_auth_prod_otheradd=s:1:"1";|soap_auth_prod_otherupdate=s:1:"1";|soap_auth_prod_otherdelete=s:1:"1";|soap_ws_order_on=s:1:"0";|soap_ws_order_cache_on=s:1:"1";|soap_auth_getorder=s:1:"1";|soap_auth_addorder=s:1:"1";|soap_auth_uporder=s:1:"1";|soap_auth_delorder=s:1:"1";|soap_auth_order_otherget=s:1:"1";|soap_auth_order_otheradd=s:1:"1";|soap_auth_order_otherupdate=s:1:"1";|soap_auth_order_otherdelete=s:1:"1";|soap_ws_sql_on=s:1:"0";|soap_ws_sql_cache_on=s:1:"1";|soap_auth_execsql=s:1:"1";|soap_auth_execsql_select=s:1:"1";|soap_auth_execsql_insert=s:1:"1";|soap_auth_execsql_update=s:1:"1";|soap_ws_custom_on=s:1:"0";|soap_ws_custom_cache_on=s:1:"1";|soap_EP_custom=s:24:"VM_CustomizedService.php";|soap_wsdl_custom=s:18:"VM_Customized.wsdl";')
SQL =

INSERT INTO `#__virtuemart_configs` (`virtuemart_config_id`, `config`) VALUES ('1', 'shop_is_offline=s:1:"0";|offline_message=czo3MzoiT3VyIFNob3AgaXMgY3VycmVudGx5IGRvd24gZm9yIG1haW50ZW5hbmNlLiBQbGVhc2UgY2hlY2sgYmFjayBhZ2FpbiBzb29uLiI7|use_as_catalog=s:1:"0";|currency_converter_module=s:14:"convertECB.php";|order_mail_html=s:1:"1";|dateformat=s:8:"%m/%d/%y";|useSSL=s:1:"0";|dangeroustools=s:1:"0";|debug_enable=s:4:"none";|google_jquery=s:1:"1";|multix=s:4:"none";|pdf_button_enable=s:1:"1";|show_emailfriend=s:1:"1";|show_printicon=s:1:"0";|show_out_of_stock_products=s:1:"1";|coupons_enable=s:1:"0";|coupons_default_expire=s:3:"1,D";|weight_unit_default=s:2:"KG";|lwh_unit_default=s:1:"m";|list_limit=s:2:"10";|showReviewFor=s:3:"all";|reviewMode=s:10:"registered";|showRatingFor=s:3:"all";|ratingMode=s:10:"registered";|reviews_autopublish=s:1:"1";|reviews_minimum_comment_length=s:3:"100";|reviews_maximum_comment_length=s:4:"2000";|vmtemplate=s:7:"default";|categorytemplate=s:7:"default";|showCategory=s:1:"1";|categorylayout=s:7:"default";|categories_per_row=s:1:"3";|productlayout=s:7:"default";|products_per_row=s:1:"3";|vmlayout=s:7:"default";|show_featured=s:1:"1";|featured_products_per_row=s:1:"3";|show_topTen=s:1:"1";|topten_products_per_row=s:1:"3";|show_recent=s:1:"1";|show_latest=s:1:"1";|assets_general_path=s:33:"components/com_virtuemart/assets/";|media_category_path=s:35:"images/stories/virtuemart/category/";|media_product_path=s:34:"images/stories/virtuemart/product/";|media_manufacturer_path=s:39:"images/stories/virtuemart/manufacturer/";|media_vendor_path=s:33:"images/stories/virtuemart/vendor/";|img_resize_enable=s:1:"1";|img_width=s:2:"90";|img_height=s:2:"90";|no_image_set=s:11:"noimage.gif";|no_image_found=s:11:"warning.png";|browse_orderby_field=s:23:"p.virtuemart_product_id";|browse_orderby_fields=a:4:{i:0;s:11:"product_sku";i:1;s:13:"category_name";i:2;s:7:"mf_name";i:3;s:12:"product_name";}|browse_search_fields=a:6:{i:0;s:11:"product_sku";i:1;s:13:"category_name";i:2;s:20:"category_description";i:3;s:7:"mf_name";i:4;s:12:"product_name";i:5;s:14:"product_s_desc";}|show_prices=s:1:"1";|price_access_level_published=s:1:"0";|price_show_packaging_pricelabel=s:1:"0";|show_tax=s:1:"1";|basePrice=s:1:"1";|basePriceText=s:1:"1";|basePriceRounding=s:1:"2";|variantModification=s:1:"1";|variantModificationText=s:1:"1";|variantModificationRounding=s:1:"2";|basePriceVariant=s:1:"1";|basePriceVariantText=s:1:"1";|basePriceVariantRounding=s:1:"2";|basePriceWithTax=s:1:"1";|basePriceWithTaxText=s:1:"1";|basePriceWithTaxRounding=s:1:"2";|discountedPriceWithoutTax=s:1:"1";|discountedPriceWithoutTaxText=s:1:"1";|discountedPriceWithoutTaxRounding=s:1:"2";|salesPriceWithDiscount=s:1:"1";|salesPriceWithDiscountText=s:1:"1";|salesPriceWithDiscountRounding=s:1:"2";|salesPrice=s:1:"1";|salesPriceText=s:1:"1";|salesPriceRounding=s:1:"2";|priceWithoutTax=s:1:"1";|priceWithoutTaxText=s:1:"1";|priceWithoutTaxRounding=s:1:"2";|discountAmount=s:1:"1";|discountAmountText=s:1:"1";|discountAmountRounding=s:1:"2";|taxAmount=s:1:"1";|taxAmountText=s:1:"1";|taxAmountRounding=s:1:"2";|check_stock=s:1:"0";|automatic_payment=s:1:"1";|automatic_shipment=s:1:"1";|agree_to_tos_onorder=s:1:"0";|oncheckout_show_legal_info=s:1:"1";|oncheckout_show_register=s:1:"1";|oncheckout_show_steps=s:1:"0";|oncheckout_show_register_text=s:47:"COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER";|seo_disabled=s:1:"0";|seo_translate=s:1:"0";|seo_use_id=s:1:"0";|soap_ws_cat_on=s:1:"0";|soap_ws_cat_cache_on=s:1:"1";|soap_auth_getcat=s:1:"1";|soap_auth_addcat=s:1:"1";|soap_auth_upcat=s:1:"1";|soap_auth_delcat=s:1:"1";|soap_auth_cat_otherget=s:1:"1";|soap_auth_cat_otheradd=s:1:"1";|soap_auth_cat_otherupdate=s:1:"1";|soap_auth_cat_otherdelete=s:1:"1";|soap_ws_user_on=s:1:"0";|soap_ws_user_cache_on=s:1:"1";|soap_auth_getuser=s:1:"1";|soap_auth_adduser=s:1:"1";|soap_auth_upuser=s:1:"1";|soap_auth_deluser=s:1:"1";|soap_auth_user_otherget=s:1:"1";|soap_auth_user_otheradd=s:1:"1";|soap_auth_user_otherupdate=s:1:"1";|soap_auth_user_otherdelete=s:1:"1";|soap_ws_prod_on=s:1:"0";|soap_ws_prod_cache_on=s:1:"1";|soap_auth_getprod=s:1:"1";|soap_auth_addprod=s:1:"1";|soap_auth_upprod=s:1:"1";|soap_auth_delprod=s:1:"1";|soap_auth_prod_otherget=s:1:"1";|soap_auth_prod_otheradd=s:1:"1";|soap_auth_prod_otherupdate=s:1:"1";|soap_auth_prod_otherdelete=s:1:"1";|soap_ws_order_on=s:1:"0";|soap_ws_order_cache_on=s:1:"1";|soap_auth_getorder=s:1:"1";|soap_auth_addorder=s:1:"1";|soap_auth_uporder=s:1:"1";|soap_auth_delorder=s:1:"1";|soap_auth_order_otherget=s:1:"1";|soap_auth_order_otheradd=s:1:"1";|soap_auth_order_otherupdate=s:1:"1";|soap_auth_order_otherdelete=s:1:"1";|soap_ws_sql_on=s:1:"0";|soap_ws_sql_cache_on=s:1:"1";|soap_auth_execsql=s:1:"1";|soap_auth_execsql_select=s:1:"1";|soap_auth_execsql_insert=s:1:"1";|soap_auth_execsql_update=s:1:"1";|soap_ws_custom_on=s:1:"0";|soap_ws_custom_cache_on=s:1:"1";|soap_EP_custom=s:24:"VM_CustomizedService.php";|soap_wsdl_custom=s:18:"VM_Customized.wsdl";'

I've seen similar problems but have not found a solution. Your input is greatly appreciated.

[princessbs]

UPDATE:  Thinking it was my max_execution time I emailed my hosting company and they replied:
"The problem in this case is not related with the max_execution_time setting of PHP, it comes from the slow MySQL queries your application generates. Increasing the value of the setting will not resolve the problem because it will not affect the queries."

So is there a way to manually upgrade and/or a way perform the MySQL queries ?

[AngelinaC]

Also had to get assistance with a custom php.ini file and increased time for uploads from my server company but that did the trick. 

[jenkinhill]

I have never had a problem installing VM2 components, and have done it many hundreds of times for different tests and for client use. The key settings on the Linux servers I use are:

PHP Version 5.3.10  (compiled to include BZip2 Support  - BZ2) Edited: now running PHP5.4.21 and runs OK as before

Important php.ini settings are:

; Resource Limits ;
max_execution_time = 120
memory_limit = 128M

; File Uploads ;
upload_max_filesize = 32M

post_max_size = 32M

The MySQL Version is  5.1.65

I also make sure that there is plenty of spare disk space for each domain.

Note: anyone using localhost must set the values in php.ini at a higher level than those above, as localhost is much slower in operation than a real Linux server.

There is evidence that Joomla 2.5 works better on a server with memory_limit set at 256Mb, but there is no benefit in allocating more than this.

[princessbs]

I tried with the suggested settings but still receive the same error. Hosting company insist that it is due to slow MySQL queries. I really want to keep Virtuemart on this site, PLEASE is there a way to manually upgrade the database and files?

[jenkinhill]

Info on MySQL 2006 errors: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html   - tried a Google on the error and there are many reports of this problem with a variety of Joomla & other programs. Seems to be mostly associated with low end shared servers. Solutions seem to be to increase the php limits and where that fails (according to a contact of mine), to increase max_allowed_packet on MySQL conf and maybe also wait_timeout - but this would need the host to recompile MySQL on the server.

You can ftp the files, and I think you can run the update script install/script.virtuemart.php - but then you will run into the same MySQL problem you are already seeing.

If you have to use that host, then an approach would be to use Akeeba to make a copy of the site, install it on a localhost and uodate it there. Then use Akeeba again to copy that site and install it back on the sever.

[princessbs]

It is true, wonders never cease.  My hosting company has agreed to perform the upgrade free of charge. Hopefully, future upgrades will not have any problems.