1. SET NAMES 'utf8'
    
  1. SHOW TABLES LIKE 'cscart_cache'
    
  1. SELECT data FROM cscart_cache WHERE name = 'cache_handlers' AND company_id = 0
    
  1. SELECT data, expiry FROM cscart_cache WHERE name = 'settings.cache_customer' AND company_id = 0 
    
  1. SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
    
  1. SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_objects.edition_type))AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
    
  1. SHOW COLUMNS FROM cscart_cache
    
  1. REPLACE INTO cscart_cache (`name`, `company_id`, `data`, `tags`, `expiry`) VALUES ('settings.cache_customer', '0', 'a:28:{s:7:\"Company\";a:19:{s:12:\"company_name\";s:18:\"Công ty Hà Yến\";s:15:\"company_address\";s:61:\"Số 17 Ngách 26/18 Nguyên Hồng - Đống Đa - Hà Nội\";s:12:\"company_city\";s:9:\"Hà Nội\";s:15:\"company_country\";s:2:\"VN\";s:13:\"company_state\";s:2:\"HN\";s:15:\"company_zipcode\";s:5:\"70000\";s:13:\"company_phone\";s:12:\"+84463257568\";s:15:\"company_phone_2\";s:13:\"0986 96 56 58\";s:11:\"company_fax\";s:0:\"\";s:15:\"company_website\";s:16:\"www.bepgasam.net\";s:18:\"company_start_year\";s:4:\"2012\";s:24:\"company_users_department\";s:28:\"nghiemvui@creativevietnam.vn\";s:26:\"company_site_administrator\";s:28:\"Nghiemvui@creativevietnam.vn\";s:25:\"company_orders_department\";s:28:\"Nghiemvui@creativevietnam.vn\";s:26:\"company_support_department\";s:0:\"\";s:24:\"company_newsletter_email\";s:28:\"Nghiemvui@creativevietnam.vn\";s:10:\"page_title\";s:78:\"Hà Yến - Chuyên cung cấp các loại bếp gas - thiết bị nhà bếp\";s:16:\"meta_description\";s:78:\"Hà Yến - Chuyên cung cấp các loại bếp gas - thiết bị nhà bếp\";s:13:\"meta_keywords\";s:78:\"Hà Yến - Chuyên cung cấp các loại bếp gas - thiết bị nhà bếp\";}s:15:\"skin_name_admin\";s:5:\"basic\";s:18:\"skin_name_customer\";s:5:\"hayen\";s:19:\"show_menu_mouseover\";s:1:\"N\";s:26:\"lh_visitor_data_last_clean\";s:10:\"1160220364\";s:24:\"cart_products_next_check\";s:10:\"1544753020\";s:16:\"translation_mode\";s:1:\"N\";s:18:\"customization_mode\";s:1:\"Y\";s:15:\"hd_request_code\";s:0:\"\";s:9:\"store_key\";s:0:\"\";s:4:\"faqs\";a:2:{s:7:\"general\";a:6:{s:13:\"tags_for_faqs\";s:1:\"Y\";s:11:\"simple_tags\";s:1:\"Y\";s:18:\"faq_posts_per_page\";s:2:\"10\";s:17:\"faq_post_approval\";s:8:\"disabled\";s:17:\"faq_post_ip_check\";s:1:\"N\";s:22:\"faq_notification_email\";s:0:\"\";}s:11:\"faqs_layout\";a:3:{s:28:\"faqs_detailed_default_layout\";s:0:\"\";s:26:\"available_faqs_list_layout\";s:0:\"\";s:24:\"faqs_list_default_layout\";s:0:\"\";}}s:7:\"General\";a:52:{s:15:\"secure_checkout\";s:1:\"N\";s:12:\"secure_admin\";s:1:\"N\";s:11:\"secure_auth\";s:1:\"N\";s:10:\"keep_https\";s:1:\"N\";s:17:\"debugging_console\";s:1:\"N\";s:20:\"alternative_currency\";s:1:\"N\";s:13:\"weight_symbol\";s:3:\"lbs\";s:19:\"weight_symbol_grams\";s:5:\"453.6\";s:16:\"store_access_key\";s:0:\"\";s:14:\"order_start_id\";s:0:\"\";s:13:\"use_shipments\";s:1:\"Y\";s:15:\"tax_calculation\";s:8:\"subtotal\";s:13:\"feedback_type\";s:6:\"manual\";s:18:\"auto_check_updates\";s:1:\"Y\";s:15:\"default_address\";s:11:\"Vu Pham Ham\";s:15:\"default_zipcode\";s:3:\"084\";s:12:\"default_city\";s:6:\"Ha Noi\";s:15:\"default_country\";s:2:\"VN\";s:13:\"default_state\";s:2:\"HN\";s:13:\"default_phone\";s:10:\"0903401686\";s:18:\"inventory_tracking\";s:1:\"Y\";s:21:\"allow_negative_amount\";s:1:\"N\";s:11:\"edp_key_ttl\";s:2:\"24\";s:19:\"low_stock_threshold\";s:1:\"0\";s:32:\"show_products_from_subcategories\";s:1:\"Y\";s:25:\"display_options_modifiers\";s:1:\"Y\";s:15:\"exception_style\";s:4:\"hide\";s:26:\"show_out_of_stock_products\";s:1:\"Y\";s:17:\"use_single_coupon\";s:1:\"Y\";s:22:\"user_multiple_profiles\";s:1:\"N\";s:16:\"min_order_amount\";s:1:\"0\";s:21:\"min_order_amount_type\";s:1:\"S\";s:24:\"allow_anonymous_shopping\";s:1:\"Y\";s:26:\"disable_anonymous_checkout\";s:1:\"N\";s:16:\"redirect_to_cart\";s:1:\"N\";s:17:\"checkout_redirect\";s:1:\"N\";s:22:\"allow_usergroup_signup\";s:1:\"Y\";s:21:\"approve_user_profiles\";s:1:\"N\";s:16:\"address_position\";s:13:\"billing_first\";s:18:\"use_email_as_login\";s:1:\"Y\";s:18:\"quick_registration\";s:1:\"Y\";s:22:\"agree_terms_conditions\";s:1:\"N\";s:5:\"repay\";s:1:\"Y\";s:14:\"checkout_style\";s:10:\"multi_page\";s:22:\"estimate_shipping_cost\";s:1:\"Y\";s:32:\"allow_create_account_after_order\";s:1:\"Y\";s:31:\"disregard_options_for_discounts\";s:1:\"N\";s:10:\"proxy_host\";s:0:\"\";s:10:\"proxy_port\";s:0:\"\";s:10:\"proxy_user\";s:0:\"\";s:14:\"proxy_password\";s:0:\"\";s:14:\"search_objects\";s:0:\"\";}s:9:\"Shippings\";a:9:{s:16:\"disable_shipping\";s:1:\"N\";s:13:\"fedex_enabled\";s:1:\"N\";s:11:\"ups_enabled\";s:1:\"N\";s:12:\"usps_enabled\";s:1:\"N\";s:11:\"dhl_enabled\";s:1:\"N\";s:11:\"aup_enabled\";s:1:\"N\";s:11:\"can_enabled\";s:1:\"N\";s:17:\"swisspost_enabled\";s:1:\"N\";s:11:\"ems_enabled\";s:1:\"N\";}s:7:\"Logging\";a:8:{s:13:\"log_type_news\";a:3:{s:6:\"create\";s:1:\"Y\";s:6:\"delete\";s:1:\"Y\";s:6:\"update\";s:1:\"Y\";}s:15:\"log_type_orders\";a:4:{s:6:\"create\";s:1:\"Y\";s:6:\"delete\";s:1:\"Y\";s:6:\"update\";s:1:\"Y\";s:6:\"status\";s:1:\"Y\";}s:14:\"log_type_users\";a:5:{s:6:\"create\";s:1:\"Y\";s:6:\"delete\";s:1:\"Y\";s:6:\"update\";s:1:\"Y\";s:7:\"session\";s:1:\"Y\";s:12:\"failed_login\";s:1:\"Y\";}s:17:\"log_type_products\";a:4:{s:6:\"create\";s:1:\"Y\";s:6:\"delete\";s:1:\"Y\";s:6:\"update\";s:1:\"Y\";s:9:\"low_stock\";s:1:\"Y\";}s:19:\"log_type_categories\";a:3:{s:6:\"create\";s:1:\"Y\";s:6:\"delete\";s:1:\"Y\";s:6:\"update\";s:1:\"Y\";}s:17:\"log_type_database\";a:4:{s:7:\"restore\";s:1:\"Y\";s:6:\"backup\";s:1:\"Y\";s:8:\"optimize\";s:1:\"Y\";s:6:\"errors\";s:1:\"Y\";}s:17:\"log_type_requests\";a:1:{s:4:\"http\";s:1:\"Y\";}s:16:\"log_type_general\";a:2:{s:7:\"runtime\";s:1:\"Y\";s:10:\"deprecated\";s:1:\"Y\";}}s:0:\"\";a:5:{s:14:\"license_number\";s:0:\"\";s:12:\"ftp_hostname\";s:0:\"\";s:12:\"ftp_username\";s:0:\"\";s:12:\"ftp_password\";s:0:\"\";s:13:\"ftp_directory\";s:0:\"\";}s:7:\"Sitemap\";a:3:{s:9:\"show_cats\";s:1:\"Y\";s:18:\"show_rootcats_only\";s:1:\"N\";s:14:\"show_site_info\";s:1:\"Y\";}s:6:\"Emails\";a:6:{s:18:\"mailer_send_method\";s:4:\"mail\";s:16:\"mailer_smtp_host\";s:0:\"\";s:20:\"mailer_smtp_username\";s:0:\"\";s:20:\"mailer_smtp_password\";s:0:\"\";s:16:\"mailer_smtp_auth\";s:1:\"N\";s:20:\"mailer_sendmail_path\";s:18:\"/usr/sbin/sendmail\";}s:18:\"Image_verification\";a:21:{s:5:\"width\";s:3:\"100\";s:6:\"height\";s:2:\"25\";s:13:\"string_length\";s:1:\"5\";s:12:\"lines_number\";s:2:\"20\";s:10:\"grid_color\";s:6:\"cccccc\";s:13:\"min_font_size\";s:2:\"14\";s:13:\"max_font_size\";s:2:\"16\";s:11:\"string_type\";s:5:\"mixed\";s:11:\"char_shadow\";s:1:\"N\";s:6:\"colour\";s:1:\"N\";s:16:\"background_image\";s:0:\"\";s:14:\"hide_if_logged\";s:1:\"Y\";s:21:\"hide_after_validation\";s:1:\"Y\";s:13:\"use_for_login\";s:1:\"N\";s:16:\"use_for_register\";s:1:\"Y\";s:20:\"use_for_form_builder\";s:1:\"Y\";s:22:\"use_for_send_to_friend\";s:1:\"Y\";s:18:\"use_for_discussion\";s:1:\"Y\";s:16:\"use_for_checkout\";s:1:\"Y\";s:13:\"use_for_polls\";s:1:\"Y\";s:20:\"use_for_track_orders\";s:1:\"N\";}s:8:\"Security\";a:5:{s:25:\"min_admin_password_length\";s:1:\"5\";s:32:\"admin_passwords_must_contain_mix\";s:1:\"N\";s:36:\"change_admin_password_on_first_login\";s:1:\"N\";s:32:\"admin_password_expiration_period\";s:1:\"0\";s:13:\"cron_password\";s:6:\"MYPASS\";}s:13:\"send_feedback\";s:1:\"0\";s:10:\"Appearance\";a:41:{s:22:\"admin_default_language\";s:2:\"VN\";s:21:\"admin_orders_per_page\";s:2:\"10\";s:23:\"admin_products_per_page\";s:2:\"10\";s:20:\"admin_pages_per_page\";s:2:\"10\";s:23:\"admin_elements_per_page\";s:2:\"10\";s:22:\"default_wysiwyg_editor\";s:7:\"tinymce\";s:15:\"show_quick_menu\";s:1:\"N\";s:25:\"customer_default_language\";s:2:\"VN\";s:15:\"orders_per_page\";s:2:\"10\";s:17:\"products_per_page\";s:2:\"12\";s:17:\"elements_per_page\";s:2:\"10\";s:24:\"columns_in_products_list\";s:1:\"4\";s:27:\"show_add_to_card_outofstock\";s:1:\"Y\";s:19:\"show_contact_button\";s:1:\"Y\";s:20:\"contact_us_for_price\";s:2:\"30\";s:27:\"taxes_using_default_address\";s:1:\"N\";s:23:\"show_prices_taxed_clean\";s:1:\"N\";s:19:\"cart_prices_w_taxes\";s:1:\"N\";s:14:\"in_stock_field\";s:1:\"N\";s:18:\"thumbnails_gallery\";s:1:\"N\";s:16:\"quantity_changer\";s:1:\"Y\";s:14:\"top_pagination\";s:1:\"N\";s:23:\"default_image_previewer\";s:11:\"prettyphoto\";s:11:\"header_8159\";s:0:\"\";s:30:\"default_product_details_layout\";s:29:\"default_long_options_template\";s:22:\"product_details_in_tab\";s:1:\"Y\";s:20:\"display_track_orders\";s:1:\"Y\";s:33:\"default_products_layout_templates\";s:63:\"products_multicolumns=Y&products_without_options=Y&short_list=Y\";s:23:\"default_products_layout\";s:21:\"products_multicolumns\";s:20:\"save_selected_layout\";s:1:\"Y\";s:31:\"available_product_list_sortings\";a:6:{s:14:\"timestamp-desc\";s:1:\"Y\";s:11:\"product-asc\";s:1:\"Y\";s:12:\"product-desc\";s:1:\"Y\";s:9:\"price-asc\";s:1:\"Y\";s:10:\"price-desc\";s:1:\"Y\";s:15:\"popularity-desc\";s:1:\"Y\";}s:24:\"default_products_sorting\";s:11:\"product-asc\";s:18:\"disable_quick_view\";s:1:\"N\";s:11:\"date_format\";s:8:\"%d/%m/%Y\";s:11:\"time_format\";s:5:\"%H:%M\";s:8:\"timezone\";s:12:\"Asia/Bangkok\";s:20:\"calendar_date_format\";s:9:\"day_first\";s:20:\"calendar_week_format\";s:12:\"monday_first\";s:15:\"changes_warning\";s:1:\"Y\";s:22:\"show_menu_descriptions\";s:1:\"Y\";s:22:\"notice_displaying_time\";s:1:\"5\";}s:10:\"store_mode\";s:6:\"opened\";s:18:\"store_optimization\";s:4:\"live\";s:7:\"Reports\";a:4:{s:3:\"day\";s:9:\"%a, %b %e\";s:4:\"week\";s:6:\"%U, %b\";s:5:\"month\";s:2:\"%B\";s:4:\"year\";s:2:\"%Y\";}s:24:\"gift_registry_next_check\";s:10:\"1299789068\";s:5:\"DHTML\";a:3:{s:16:\"ajax_add_to_cart\";s:1:\"Y\";s:20:\"ajax_comparison_list\";s:1:\"Y\";s:30:\"customer_ajax_based_pagination\";s:1:\"Y\";}s:9:\"Suppliers\";a:3:{s:16:\"enable_suppliers\";s:1:\"N\";s:16:\"display_supplier\";s:1:\"Y\";s:35:\"display_shipping_methods_separately\";s:1:\"Y\";}s:10:\"Thumbnails\";a:17:{s:26:\"thumbnail_background_color\";s:7:\"#ffffff\";s:10:\"convert_to\";s:8:\"original\";s:12:\"jpeg_quality\";s:2:\"80\";s:29:\"product_lists_thumbnail_width\";s:3:\"240\";s:30:\"product_lists_thumbnail_height\";s:3:\"196\";s:31:\"product_details_thumbnail_width\";s:3:\"493\";s:32:\"product_details_thumbnail_height\";s:3:\"258\";s:28:\"product_detailed_image_width\";s:0:\"\";s:29:\"product_detailed_image_height\";s:0:\"\";s:28:\"product_cart_thumbnail_width\";s:3:\"120\";s:29:\"product_cart_thumbnail_height\";s:0:\"\";s:30:\"category_lists_thumbnail_width\";s:3:\"150\";s:31:\"category_lists_thumbnail_height\";s:3:\"120\";s:32:\"category_details_thumbnail_width\";s:0:\"\";s:33:\"category_details_thumbnail_height\";s:0:\"\";s:29:\"category_detailed_image_width\";s:0:\"\";s:30:\"category_detailed_image_height\";s:0:\"\";}}', 'settings', '0')
    
  1. SELECT data, expiry FROM cscart_cache WHERE name = 'addons.cache_customer' AND company_id = 0 
    
  1. SELECT addon, priority, status FROM cscart_addons ORDER BY priority
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'live_help' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'nice_slideshow' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'news_and_emails' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'tags' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'visitors_counter' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'visitor_counter' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'product_configurator' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'download' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'attachments' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'photos' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'affiliate' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'customers_also_bought' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'gift_registry' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'gift_certificates' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'store_locator' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'statistics' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'webmail' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'rma' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'send_to_friend' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'seo' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'reward_points' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'google_analytics' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'anti_fraud' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'sms_notifications' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'update_settings' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'similar_products' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'product_category' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'manage_files' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'block_data' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'bestsellers' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'form_builder' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'barcode' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'social_network' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'polls' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'access_restrictions' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'banners' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'gmap' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'age_verification' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'discussion' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'wishlist' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'recurring_billing' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'google_sitemap' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'required_products' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'catalog_mode' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. SELECT * FROM cscart_settings_sections WHERE name = 'my_changes' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_sections.edition_type))
    
  1. REPLACE INTO cscart_cache (`name`, `company_id`, `data`, `tags`, `expiry`) VALUES ('addons.cache_customer', '0', 'a:45:{s:9:\"live_help\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:1:\"1\";}s:14:\"nice_slideshow\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"100\";}s:15:\"news_and_emails\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"100\";}s:4:\"tags\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"200\";}s:16:\"visitors_counter\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"230\";}s:15:\"visitor_counter\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"230\";}s:20:\"product_configurator\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"300\";}s:8:\"download\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"600\";}s:11:\"attachments\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"600\";}s:6:\"photos\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:3:\"600\";}s:9:\"affiliate\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:3:\"700\";}s:21:\"customers_also_bought\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:3:\"900\";}s:13:\"gift_registry\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"1000\";}s:17:\"gift_certificates\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"1100\";}s:13:\"store_locator\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"1200\";}s:10:\"statistics\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"1300\";}s:7:\"webmail\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"1400\";}s:3:\"rma\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"1600\";}s:14:\"send_to_friend\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"1700\";}s:3:\"seo\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"1800\";}s:13:\"reward_points\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"1900\";}s:16:\"google_analytics\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"2000\";}s:10:\"anti_fraud\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2100\";}s:17:\"sms_notifications\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"2200\";}s:15:\"update_settings\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"2300\";}s:16:\"similar_products\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2300\";}s:16:\"product_category\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2300\";}s:12:\"manage_files\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2300\";}s:10:\"block_data\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2300\";}s:11:\"bestsellers\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2300\";}s:12:\"form_builder\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2400\";}s:7:\"barcode\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2500\";}s:14:\"social_network\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"2540\";}s:5:\"polls\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2600\";}s:19:\"access_restrictions\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"2700\";}s:7:\"banners\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2800\";}s:4:\"gmap\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"2800\";}s:16:\"age_verification\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"2900\";}s:10:\"discussion\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"3000\";}s:8:\"wishlist\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"3100\";}s:17:\"recurring_billing\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"3400\";}s:14:\"google_sitemap\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"3500\";}s:17:\"required_products\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:4:\"3900\";}s:12:\"catalog_mode\";a:2:{s:6:\"status\";s:1:\"D\";s:8:\"priority\";s:4:\"4200\";}s:10:\"my_changes\";a:2:{s:6:\"status\";s:1:\"A\";s:8:\"priority\";s:10:\"2147483647\";}}', 'addons', '0')
    
  1. SELECT localization_id, custom_weight_settings, weight_symbol, weight_unit FROM cscart_localizations WHERE status = 'A'
    
  1. SELECT cscart_languages.* FROM cscart_languages  WHERE cscart_languages.status = 'A' 
    
  1. SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'VN'  WHERE status = 'A'  ORDER BY a.position
    
  1. SELECT data, expiry FROM cscart_cache WHERE name = 'lang_cache.C_GET_index_index_VN_VND' AND company_id = 0 
    
  1. SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'skin_name_customer' 
    
  1. SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('PRO:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
    
SELECTED SKIN NOT FOUND. REPLACED BY FIRST FOUND
  1. SELECT a.localization_id, a.status, b.localization, a.is_default FROM cscart_localizations as a LEFT JOIN cscart_localization_descriptions as b ON a.localization_id = b.localization_id AND b.lang_code = 'VN' LEFT JOIN cscart_localization_elements AS c ON a.localization_id = c.localization_id AND c.element_type = 'L' RIGHT JOIN cscart_languages AS d ON c.element = d.lang_code AND d.status = 'A'  WHERE a.status = 'A' ORDER BY localization
    
  1. SELECT data, expiry FROM cscart_cache WHERE name = 'seo.VN' AND company_id = 0 
    
  1. SELECT object_id,name FROM cscart_seo_names WHERE type = 'a' AND lang_code = 'VN' 
    

Error_occurred

  1. REPLACE INTO cscart_cache (`name`, `company_id`, `data`) VALUES ('cache_handlers', '0', 'a:8:{s:16:\"settings_objects\";a:2:{s:8:\"settings\";b:1;s:6:\"addons\";b:1;}s:22:\"settings_vendor_values\";a:2:{s:8:\"settings\";b:1;s:6:\"addons\";b:1;}s:21:\"settings_descriptions\";a:2:{s:8:\"settings\";b:1;s:6:\"addons\";b:1;}s:17:\"settings_sections\";a:2:{s:8:\"settings\";b:1;s:6:\"addons\";b:1;}s:17:\"settings_variants\";a:2:{s:8:\"settings\";b:1;s:6:\"addons\";b:1;}s:6:\"addons\";a:1:{s:6:\"addons\";b:1;}s:15:\"language_values\";a:1:{s:10:\"lang_cache\";b:1;}s:19:\"ult_language_values\";a:1:{s:10:\"lang_cache\";b:1;}}')
    
  1. DELETE FROM cscart_cache WHERE tags IN ('')