News:

Looking for documentation? Take a look on our wiki

Main Menu

Error during an update

Started by iCon, February 19, 2012, 16:27:30 PM

Previous topic - Next topic

iCon

I wanted to install a new version of the 2.0.k. But I got the mysql error. And site index in the Admin panel, I can see only the title appears open, but when I click on the products.

I received the error:

VmConfig::installVMConfig: SQL Error DB işlevi 2006 numaralı hatadan ötürü başarısız
MySQL server has gone away SQL=INSERT INTO `vzken_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_shipping=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_shipping=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";')


What should I do? If you help would be satisfied.

thank you.

sample site: www.okuritriyat.com.tr

sample product link ( error ) : https://www.okuritriyat.com.tr/index.php/component/virtuemart/238/38/sac-boyas/syoss-kit/syoss-1-4-mavi-siyah-detaylar?Itemid=410