[ashum]

На хостинге при восстановлении бэкапа через административную панель выдаётся такой текст:

Код: [Выделить]

Warning: [MYSQL] Note (1051): Unknown table 'osc_counter_history' [QUERY] drop table if exists osc_administrators, osc_administrators_access, osc_administrators_log, osc_address_book, osc_banners, osc_banners_history, osc_categories, osc_categories_description, osc_configuration, osc_configuration_group, osc_counter, osc_counter_history, osc_countries, osc_credit_cards, osc_currencies, osc_customers, osc_geo_zones, osc_languages, osc_languages_definitions, osc_manufacturers, osc_manufacturers_info, osc_newsletters, osc_newsletters_log, osc_orders, osc_orders_products, osc_orders_products_download, osc_orders_products_variants, osc_orders_status, osc_orders_status_history, osc_orders_total, osc_orders_transactions_history, osc_orders_transactions_status, osc_product_attributes, osc_products, osc_products_description, osc_products_images, osc_products_images_groups, osc_products_notifications, osc_products_to_categories, osc_products_variants, osc_products_variants_groups, osc_products_variants_values, osc_reviews, osc_ in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_address_book' [QUERY] drop table if exists osc_address_book in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_administrators' [QUERY] drop table if exists osc_administrators in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_administrators_access' [QUERY] drop table if exists osc_administrators_access in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_administrators_log' [QUERY] drop table if exists osc_administrators_log in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_banners' [QUERY] drop table if exists osc_banners in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_banners_history' [QUERY] drop table if exists osc_banners_history in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_categories' [QUERY] drop table if exists osc_categories in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_categories_description' [QUERY] drop table if exists osc_categories_description in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_configuration' [QUERY] drop table if exists osc_configuration in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_configuration_group' [QUERY] drop table if exists osc_configuration_group in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_counter' [QUERY] drop table if exists osc_counter in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_countries' [QUERY] drop table if exists osc_countries in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_credit_cards' [QUERY] drop table if exists osc_credit_cards in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_currencies' [QUERY] drop table if exists osc_currencies in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_customers' [QUERY] drop table if exists osc_customers in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_geo_zones' [QUERY] drop table if exists osc_geo_zones in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_languages' [QUERY] drop table if exists osc_languages in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_languages_definitions' [QUERY] drop table if exists osc_languages_definitions in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_manufacturers' [QUERY] drop table if exists osc_manufacturers in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_manufacturers_info' [QUERY] drop table if exists osc_manufacturers_info in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_newsletters' [QUERY] drop table if exists osc_newsletters in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_newsletters_log' [QUERY] drop table if exists osc_newsletters_log in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders' [QUERY] drop table if exists osc_orders in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders_products' [QUERY] drop table if exists osc_orders_products in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders_products_download' [QUERY] drop table if exists osc_orders_products_download in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders_products_variants' [QUERY] drop table if exists osc_orders_products_variants in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders_status' [QUERY] drop table if exists osc_orders_status in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders_status_history' [QUERY] drop table if exists osc_orders_status_history in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders_total' [QUERY] drop table if exists osc_orders_total in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders_transactions_history' [QUERY] drop table if exists osc_orders_transactions_history in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_orders_transactions_status' [QUERY] drop table if exists osc_orders_transactions_status in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_product_attributes' [QUERY] drop table if exists osc_product_attributes in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products' [QUERY] drop table if exists osc_products in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products_description' [QUERY] drop table if exists osc_products_description in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products_images' [QUERY] drop table if exists osc_products_images in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products_images_groups' [QUERY] drop table if exists osc_products_images_groups in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products_notifications' [QUERY] drop table if exists osc_products_notifications in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products_to_categories' [QUERY] drop table if exists osc_products_to_categories in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products_variants' [QUERY] drop table if exists osc_products_variants in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products_variants_groups' [QUERY] drop table if exists osc_products_variants_groups in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_products_variants_values' [QUERY] drop table if exists osc_products_variants_values in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_reviews' [QUERY] drop table if exists osc_reviews in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_sessions' [QUERY] drop table if exists osc_sessions in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_shipping_availability' [QUERY] drop table if exists osc_shipping_availability in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_shopping_carts' [QUERY] drop table if exists osc_shopping_carts in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_shopping_carts_custom_variants_values' [QUERY] drop table if exists osc_shopping_carts_custom_variants_values in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_specials' [QUERY] drop table if exists osc_specials in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_tax_class' [QUERY] drop table if exists osc_tax_class in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_tax_rates' [QUERY] drop table if exists osc_tax_rates in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_templates' [QUERY] drop table if exists osc_templates in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_templates_boxes' [QUERY] drop table if exists osc_templates_boxes in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_templates_boxes_to_pages' [QUERY] drop table if exists osc_templates_boxes_to_pages in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_weight_classes' [QUERY] drop table if exists osc_weight_classes in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_weight_classes_rules' [QUERY] drop table if exists osc_weight_classes_rules in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_whos_online' [QUERY] drop table if exists osc_whos_online in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_zones' [QUERY] drop table if exists osc_zones in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Note (1051): Unknown table 'osc_zones_to_geo_zones' [QUERY] drop table if exists osc_zones_to_geo_zones in /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php on line 141

Warning: [MYSQL] Incorrect integer value: '' for column 'configuration_id' at row 1 (1366): [QUERY] insert into osc_configuration values ("", "Last Database Restore", "DB_LAST_RESTORE", 'db_cl20333_oscom-20101006154431.sql', "Last database restore file", "6", "", "", now(), "", "") in /home/c/cl20333/vadim/public_html/includes/classes/database.php on line 72

Warning: Cannot modify header information - headers already sent by (output started at /home/c/cl20333/vadim/public_html/includes/classes/database/mysqli.php:141) in /home/c/cl20333/vadim/public_html/admin/includes/functions/general.php on line 46

[Love]

Вы когда пишите вопросы. пишите, такой то движок, такая то модификация установлена.
На родном дефолтном движке оно не работало.

[ashum]

На движок 3.0 сп 1.2 был установлен сервис-пак 1.5. Восстановление не работало ни до, ни после.

[ashum]

Поставил сервис-пак 1.5 на чистый дистрибутив 3.0. Такая же проблема - не работает восстановление.

[musicman]

На чистом движке зачем восстанавливаться? Для проверки? А вообще похоже надо копать хостера или почитать темы про бэкап на форуме ( о его плохой работе и методе исправления).

[ashum]

На чистом проверяю для того, чтобы на боевой базе не столкнуться с таким косяком. Хостеру написал, он посоветовал обратиться в поддержку OSCommerce.

[Love]

На чистом проверяю для того, чтобы на боевой базе не столкнуться с таким косяком. Хостеру написал, он посоветовал обратиться в поддержку OSCommerce.

Сказать нечего. Если стоит SP 1.5 с небольшой доработкой, она где-то описана на форуме, то все работает.

[luniov_yuri]

Точь в точь такая же проблема только не на хостинге, а на Денвере.
Движок 3,0. сп 1.5.

[musicman]

Читайте форум - https://forum.oscommerce.ru/index.php?topic=148.30

Все написано.

[Love]

Восстановление работает в любом случае после тех исправлений что по ссылке выше.
Одно но, он где-то выполняет двойной drop и поэтому сыпятся эти ошибки.

А чтоб на экране они не сыпались, а записывались только в лог надо в php.ini установить output_buffering = On.

Проблему двойного drop`а надо найти будет.

[Love]

Читаем и тестим
https://forum.oscommerce.ru/index.php?topic=148.45