Категории |
Где взять обновление с 2.4.1 до 2.4.2 и так до 2.4.5Прошу кто может скиньте, на сайте их нету уже, а хочу один брошенный сайт обновить . Подобные апгрэйды могут закончиться плачевно. Там файлы и не нужны. DROP TABLE IF EXISTS `os_address_format`; CREATE TABLE `os_address_format` ( address_format_id int NOT NULL auto_increment, address_format varchar(255) NOT NULL, address_summary varchar(255) NOT NULL, PRIMARY KEY (address_format_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci; INSERT INTO os_address_format VALUES (1, '$firstname $secondname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'); INSERT INTO os_address_format VALUES (2, '$firstname $secondname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country'); INSERT INTO os_address_format VALUES (3, '$firstname $secondname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country'); INSERT INTO os_address_format VALUES (4, '$firstname $secondname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'); INSERT INTO os_address_format VALUES (5, '$firstname $secondname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country'); INSERT INTO `os_configuration` VALUES ('', 'DISPLAY_MEMORY_USAGE', 'false', 10, 6, NULL, '0000-00-00 00:00:00', NULL, 'os_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `os_configuration` VALUES ('', 'YML_SALES_NOTES', '', 23, 14, NULL, '0000-00-00 00:00:00', NULL, NULL); update `os_configuration` set configuration_group_id='31', sort_order='2' where configuration_key='SEARCH_ENGINE_FRIENDLY_URLS'; INSERT INTO `os_configuration` VALUES ('', 'VIS_BOX_NEWS', 'true', 30, 0, NULL, '0000-00-00 00:00:00', NULL, 'os_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `os_configuration` VALUES ('', 'SEO_URL_PRODUCT_GENERATOR', 'true', 31, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'os_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `os_content_manager` VALUES (12, 0, 0, '', 1, 'Прайс-лист', 'Прайс-лист', '', '', 0, 0, 'price_list.php', 1, 12, 0, '', '', '', ''); update `os_configuration` set configuration_value='false' where configuration_key='CONFIG_CALCULATE_IMAGE_SIZE'; 2.4.3-to-2.4.4 ALTER TABLE os_admin_access ADD general_index INT( 1 ) NOT NULL ; UPDATE os_admin_access SET general_index = 1 WHERE customers_id = 1 LIMIT 1; delete from `os_configuration` where configuration_key='VIS_ADMIN_WIKI'; 2.4.4-to-2.4.5 DELETE FROM os_configuration WHERE configuration_group_id=25 2.4.5-to-2.5.0 ALTER TABLE os_admin_access DROP cip_manager; ALTER TABLE os_admin_access DROP orders_send; ALTER TABLE os_admin_access DROP themes_admin; ALTER TABLE os_admin_access DROP module_edit; ALTER TABLE os_admin_access DROP module_export; ALTER TABLE os_admin_access ADD stats_stock_warning INT( 1 ) NOT NULL ; UPDATE os_admin_access SET stats_stock_warning = 1 WHERE customers_id = 1 LIMIT 1; ALTER TABLE os_admin_access ADD plugins INT( 1 ) NOT NULL ; UPDATE os_admin_access SET plugins = 1 WHERE customers_id = 1 LIMIT 1; CREATE TABLE os_plugins ( plugins_id int NOT NULL auto_increment, plugins_key varchar(64) NOT NULL, plugins_name varchar(64) NOT NULL, plugins_value varchar(255) NOT NULL, sort_order int(5) NULL, sort_plugins int(5) NULL, use_function varchar(255) NULL, PRIMARY KEY (plugins_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci; ALTER TABLE os_admin_access ADD products_expected INT( 1 ) NOT NULL ; UPDATE os_admin_access SET products_expected = 1 WHERE customers_id = 1 LIMIT 1; DROP TABLE IF EXISTS os_cip; DROP TABLE IF EXISTS os_cip_depend; ALTER TABLE os_faq ADD faq_page_url VARCHAR(256) NOT NULL; DELETE FROM os_configuration WHERE configuration_group_id=16; INSERT INTO os_configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('DISPLAY_DB_QUERY', 'false', 10, 6, NULL, '', NULL, 'os_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO os_configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('DB_CACHE_PRO', 'true', 11, 7, NULL, '', NULL, 'os_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO os_configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('SET_WHOS_ONLINE', 'false', '17', '18', NULL, '0000-00-00 00:00:00', NULL, 'os_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO os_configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('VIS_BANNER', 'false', 30, 32, NULL, '', NULL, 'os_cfg_select_option(array(\'true\', \'false\'),'); DELETE FROM `os_configuration_group` WHERE `configuration_group_id` = 25 LIMIT 1; |
|