News:

Support the VirtueMart project and become a member

Main Menu

Renew config by file issue

Started by julos0877, February 10, 2015, 10:43:12 AM

Previous topic - Next topic

julos0877

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

jjk

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.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

julos0877

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);

julos0877

The same problem came back yesterday but only on 2 websites.
Configurations has been reseted.