VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: julos0877 on February 10, 2015, 10:43:12 AM

Title: Renew config by file issue
Post by: julos0877 on February 10, 2015, 10:43:12 AM
Hello Virtuemart people,

I found a strange thing with my websites with virtuemart.
The SQL table virtuemart_configs has been reset without any action from me.

I have 3 websites with virtuemart in my server and the 3 websites virtuemart config have been reseted.

Do you know if we can disable this possibility ? Do you know if it's possible that a robot can launch the process ?

Problem appeared with : Virtuemart 2.0.20b, 2.6.10 & 2.6.12 with Joomla 2.5.28.

Many thanks in advance
Title: Re: Renew config by file issue
Post by: jjk on February 10, 2015, 19:40:16 PM
Did you click 'Renew config by file'?

Renew config by file
Deletes the stored configuration in the database and reset it with the values from the file /administrator/components/com_virtuemart/virtuemart.cfg. Be aware that it does not take the values from the virtuemart_defaults.cfg-dist. This file contains the default configuration shipped with the core. So you can adjust the virtuemart.cfg to your needs and use it as a kind of backup.

If you didn't, I would take take a look into the _virtuemart_configs table and note the exact time it was modified and the user id in the modified_by column. Then check which user has this id. With the time stamp you can also check your access log and have a look what was going on at that time.
Title: Re: Renew config by file issue
Post by: julos0877 on February 11, 2015, 10:53:12 AM
Hello jjk,

The reset has not been done by me or other people.
I checked my database backup and see below the difference between before and after the issue :
The modified on and by are equal to 0 after the reset.

Before :

INSERT INTO `j2uyi5_virtuemart_configs` VALUES (1,'shop_is_offline=s:1:\"0\";|offline_message=czo3MzoiT3VyIFNob3AgaXMgY3VycmVudGx5IGRvd24gZm9yIG1haW50ZW5hbmNlLiBQbGVhc2UgY2hlY2sgYmFjayBhZ2FpbiBzb29uLiI7|use_as_catalog=s:1:\"1\";|currency_converter_module=s:14:\"convertECB.php\";|order_mail_html=s:1:\"1\";|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:\"1\";|show_out_of_stock_products=s:1:\"1\";|coupons_enable=s:1:\"0\";|show_uncat_child_products=s:1:\"0\";|coupons_default_expire=s:3:\"1,D\";|weight_unit_default=s:2:\"KG\";|lwh_unit_default=s:1:\"M\";|showReviewFor=s:4:\"none\";|reviewMode=s:4:\"none\";|showRatingFor=s:4:\"none\";|ratingMode=s:4:\"none\";|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:1:\"0\";|categories_per_row=s:1:\"3\";|productlayout=s:1:\"0\";|products_per_row=s:1:\"3\";|vmlayout=s:1:\"0\";|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/\";|forSale_path_thumb=s:42:\"images/stories/virtuemart/forSale/resized/\";|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:12:\"product_name\";|browse_orderby_fields=a:2:{i:0;s:12:\"product_name\";i:1;s:14:\"`p`.created_on\";}|browse_search_fields=a:5:{i:0;s:12:\"product_name\";i:1;s:14:\"product_s_desc\";i:2;s:13:\"category_name\";i:3;s:20:\"category_description\";i:4;s:7:\"mf_name\";}|show_prices=s:1:\"1\";|price_show_packaging_pricelabel=s:1:\"0\";|show_tax=s:1:\"1\";|basePrice=s:1:\"1\";|basePriceText=s:1:\"1\";|basePriceRounding=s:2:\"-1\";|variantModification=s:1:\"1\";|variantModificationText=s:1:\"1\";|variantModificationRounding=s:2:\"-1\";|basePriceVariant=s:1:\"1\";|basePriceVariantText=s:1:\"1\";|basePriceVariantRounding=s:2:\"-1\";|basePriceWithTax=s:1:\"1\";|basePriceWithTaxText=s:1:\"1\";|basePriceWithTaxRounding=s:2:\"-1\";|discountedPriceWithoutTax=s:1:\"1\";|discountedPriceWithoutTaxText=s:1:\"1\";|discountedPriceWithoutTaxRounding=s:2:\"-1\";|salesPriceWithDiscount=s:1:\"1\";|salesPriceWithDiscountText=s:1:\"1\";|salesPriceWithDiscountRounding=s:2:\"-1\";|salesPrice=s:1:\"1\";|salesPriceText=s:1:\"1\";|salesPriceRounding=s:2:\"-1\";|priceWithoutTax=s:1:\"1\";|priceWithoutTaxText=s:1:\"1\";|priceWithoutTaxRounding=s:2:\"-1\";|discountAmount=s:1:\"1\";|discountAmountText=s:1:\"1\";|discountAmountRounding=s:2:\"-1\";|taxAmount=s:1:\"1\";|taxAmountText=s:1:\"1\";|taxAmountRounding=s:2:\"-1\";|addtocart_popup=s:1:\"1\";|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\";|sctime=d:1413816990.7995059;|vmlang=s:5:\"fr_fr\";|virtuemart_config_id=i:1;|enable_content_plugin=s:1:\"0\";|active_languages=a:2:{i:0;s:5:\"en-GB\";i:1;s:5:\"fr-FR\";}|enableEnglish=s:1:\"1\";|pdf_icon=s:1:\"0\";|ask_question=s:1:\"0\";|asks_minimum_comment_length=s:2:\"10\";|asks_maximum_comment_length=s:4:\"2000\";|product_navigation=s:1:\"1\";|recommend_unauth=s:1:\"1\";|display_stock=s:1:\"0\";|latest_products_days=s:1:\"7\";|latest_products_orderBy=s:10:\"created_on\";|lstockmail=s:1:\"0\";|stockhandle=s:4:\"none\";|rised_availability=s:0:\"\";|image=s:0:\"\";|show_manufacturers=s:1:\"1\";|manufacturer_per_row=s:1:\"3\";|forSale_path=s:74:\"/home/kinetec/public_html/administrator/components/com_virtuemart/vmfiles/\";|show_store_desc=s:1:\"0\";|show_categories=s:1:\"1\";|homepage_categories_per_row=s:1:\"3\";|homepage_products_per_row=s:1:\"3\";|featured_products_rows=s:1:\"1\";|topTen_products_rows=s:1:\"1\";|recent_products_rows=s:1:\"1\";|latest_products_rows=s:1:\"1\";|css=s:1:\"1\";|jquery=s:1:\"1\";|jprice=s:1:\"1\";|jsite=s:1:\"1\";|askprice=s:1:\"0\";|rappenrundung=s:1:\"0\";|roundindig=s:1:\"0\";|cVarswT=s:1:\"1\";|unitPrice=s:1:\"0\";|unitPriceText=s:1:\"1\";|unitPriceRounding=s:1:\"2\";|vmlang_js=s:1:\"0\";|oncheckout_only_registered=s:1:\"0\";|oncheckout_show_images=s:1:\"0\";|browse_cat_orderby_field=s:13:\"category_name\";|seo_sufix=s:7:\"-detail\";|task=s:4:\"save\";|option=s:14:\"com_virtuemart\";|view=s:6:\"config\";|e7cc295f7c0c5c2f1ce58371833643a6=s:1:\"1\";|llimit_init_BE=s:2:\"20\";|llimit_init_FE=s:2:\"20\";|useVendorEmail=s:1:\"1\";|cp_rm=a:1:{i:0;s:1:\"C\";}|rr_os=a:1:{i:0;s:1:\"C\";}|mediaLimit=s:2:\"20\";|pagseq=s:0:\"\";|pagseq_1=s:0:\"\";|pagseq_2=s:0:\"\";|pagseq_3=s:0:\"\";|pagseq_4=s:0:\"\";|pagseq_5=s:0:\"\";|feed_cat_published=s:1:\"0\";|feed_cat_show_images=s:1:\"0\";|feed_cat_show_prices=s:1:\"0\";|feed_cat_show_description=s:1:\"0\";|feed_cat_description_type=s:14:\"product_s_desc\";|feed_cat_max_text_length=s:3:\"500\";|feed_latest_published=s:1:\"0\";|feed_latest_nb=s:1:\"5\";|feed_topten_published=s:1:\"0\";|feed_topten_nb=s:1:\"5\";|feed_featured_published=s:1:\"0\";|feed_featured_nb=s:1:\"5\";|feed_home_show_images=s:1:\"0\";|feed_home_show_prices=s:1:\"0\";|feed_home_show_description=s:1:\"0\";|feed_home_description_type=s:14:\"product_s_desc\";|feed_home_max_text_length=s:3:\"500\";|usefancy=s:1:\"1\";|jchosen=s:1:\"0\";|popup_rel=s:1:\"1\";|oncheckout_opc=s:1:\"1\";|inv_os=a:1:{i:0;s:1:\"C\";}|email_os_s=a:5:{i:0;s:1:\"U\";i:1;s:1:\"C\";i:2;s:1:\"X\";i:3;s:1:\"R\";i:4;s:1:\"S\";}|email_os_v=a:4:{i:0;s:1:\"U\";i:1;s:1:\"C\";i:2;s:1:\"X\";i:3;s:1:\"R\";}|oncheckout_change_shopper=s:1:\"0\";|del_date_type=s:1:\"m\";|prd_brws_orderby_dir=s:3:\"ASC\";|cat_brws_orderby_dir=s:3:\"ASC\";|handle_404=s:1:\"1\";|c54e7820e1868f20d437ade22998116f=s:1:\"1\";|201c5969d2496922529a075fb3461752=s:1:\"1\";|8e3cc3ccbff539007495f8bbfce48f82=s:1:\"1\";|af9f7a51d3990ca9b028985a8a36a2ff=s:1:\"1\";|c95e95a6da9572259932a0d5d09a7db1=s:1:\"1\";|6d322d0c2eb72459b7f40725f457a4ef=s:1:\"1\";|reg_captcha=s:1:\"0\";|ask_captcha=s:1:\"0\";|add_img_main=s:1:\"0\";|a1877b4599637bf86788b0440774279e=s:1:\"1\";|1b0c09a736b918648a8bb6cfc665cac5=s:1:\"1\";|f5415e4c973b3aefdd8535915d204697=s:1:\"1\";|2479046a0ab89a76e1bea220411315b6=s:1:\"1\";','0000-00-00 00:00:00',0,'2014-10-20 14:56:30',62,'0000-00-00 00:00:00',0);

After :

INSERT INTO `j2uyi5_virtuemart_configs` 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\";|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\";|show_uncat_child_products=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:\"20\";|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:1:\"0\";|categories_per_row=s:1:\"3\";|productlayout=s:1:\"0\";|products_per_row=s:1:\"3\";|vmlayout=s:1:\"0\";|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/\";|forSale_path_thumb=s:42:\"images/stories/virtuemart/forSale/resized/\";|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_show_packaging_pricelabel=s:1:\"0\";|show_tax=s:1:\"1\";|basePrice=s:1:\"1\";|basePriceText=s:1:\"1\";|basePriceRounding=s:2:\"-1\";|variantModification=s:1:\"1\";|variantModificationText=s:1:\"1\";|variantModificationRounding=s:2:\"-1\";|basePriceVariant=s:1:\"1\";|basePriceVariantText=s:1:\"1\";|basePriceVariantRounding=s:2:\"-1\";|basePriceWithTax=s:1:\"1\";|basePriceWithTaxText=s:1:\"1\";|basePriceWithTaxRounding=s:2:\"-1\";|discountedPriceWithoutTax=s:1:\"1\";|discountedPriceWithoutTaxText=s:1:\"1\";|discountedPriceWithoutTaxRounding=s:2:\"-1\";|salesPriceWithDiscount=s:1:\"1\";|salesPriceWithDiscountText=s:1:\"1\";|salesPriceWithDiscountRounding=s:2:\"-1\";|salesPrice=s:1:\"1\";|salesPriceText=s:1:\"1\";|salesPriceRounding=s:2:\"-1\";|priceWithoutTax=s:1:\"1\";|priceWithoutTaxText=s:1:\"1\";|priceWithoutTaxRounding=s:2:\"-1\";|discountAmount=s:1:\"1\";|discountAmountText=s:1:\"1\";|discountAmountRounding=s:2:\"-1\";|taxAmount=s:1:\"1\";|taxAmountText=s:1:\"1\";|taxAmountRounding=s:2:\"-1\";|addtocart_popup=s:1:\"1\";|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\";','0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0);
Title: Re: Renew config by file issue
Post by: julos0877 on February 12, 2015, 13:35:03 PM
The same problem came back yesterday but only on 2 websites.
Configurations has been reseted.