Ошибка выглядит следующим образом:
JInstaller::install: /var/www/kroko/administrator/components/com_virtuemart/install/install_sample_data.sql Ошибка SQL Ошибка базы данных с номером 1054 Unknown column 'product_price_vdate' in 'field list' SQL=-- -- Dumping data for table `B4kn1_virtuemart_product_prices` -- INSERT INTO `B4kn1_virtuemart_product_prices` (`virtuemart_product_price_id`, `virtuemart_product_id`, `product_price`, `override`, `product_override_price`, `product_tax_id`, `product_discount_id`, `product_currency`, `product_price_vdate`, `product_price_edate`, `virtuemart_shoppergroup_id`, `price_quantity_start`, `price_quantity_end`) VALUES (1, 5, '24.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (2, 1, '4.49000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (3, 2, '39.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (4, 3, '24.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (5, 4, '17.99000', 1, '77.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (6, 6, '4.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (7, 7, '149.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (8, 8, '220.90000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (9, 9, '48.12000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (10, 10, '74.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (11, 11, '2.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (12, 12, '14.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (13, 13, '79.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (14, 14, '49.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (15, 15, '59.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (16, 16, '3.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0); SQL = -- -- Dumping data for table `#__virtuemart_product_prices` -- INSERT INTO `#__virtuemart_product_prices` (`virtuemart_product_price_id`, `virtuemart_product_id`, `product_price`, `override`, `product_override_price`, `product_tax_id`, `product_discount_id`, `product_currency`, `product_price_vdate`, `product_price_edate`, `virtuemart_shoppergroup_id`, `price_quantity_start`, `price_quantity_end`) VALUES (1, 5, '24.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (2, 1, '4.49000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (3, 2, '39.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (4, 3, '24.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (5, 4, '17.99000', 1, '77.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (6, 6, '4.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (7, 7, '149.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (8, 8, '220.90000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (9, 9, '48.12000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (10, 10, '74.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (11, 11, '2.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (12, 12, '14.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (13, 13, '79.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (14, 14, '49.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (15, 15, '59.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (16, 16, '3.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0); vmError: Problems execution of SQL File /var/www/kroko/administrator/components/com_virtuemart/install/install_sample_data.sql
Будем считать, что явно что-то нехорошее. Однако, решение простое. Переходим в данную папку:
/administrator/components/com_virtuemart/install
и открываем файл: install_sample_data.sql
В файле заменяем:
- product_price_vdate --> to product_price_publish_up
- product_price_edate --> to product_price_publish_down
Сохраняем файл и:
- переходим Компоненты - Virtuemart - Инструменты - Панель управления - Настройки.
- Отмечаем "Обновление базы данных" и сохраняем изменения.
- переходим в "Инструменты и миграция".
- нажимаем "Восстановить таблицы и установить демо данные".
Видим сообщение об успешном обновлении:
Dropped virtuemart table adminmenuentries, calc_categories, calc_countries, calc_shoppergroups, calc_states, calcs, categories, categories_ru_ru, category_categories, category_medias, configs, countries, coupons, currencies, customs, invoices, manufacturer_medias, manufacturercategories, manufacturercategories_ru_ru, manufacturers, manufacturers_ru_ru, medias, migration_oldtonew_ids, modules, order_calc_rules, order_histories, order_items, order_userinfos, orders, orderstates, paymentmethod_shoppergroups, paymentmethods, paymentmethods_ru_ru, permgroups, product_categories, product_customfields, product_manufacturers, product_medias, product_prices, product_relations, product_shoppergroups, products, products_ru_ru, rating_reviews, rating_votes, ratings, shipmentmethod_shoppergroups, shipmentmethods, shipmentmethods_ru_ru, shoppergroups, states, userfield_values, userfields, userinfos, vendor_medias, vendors, vendors_ru_ru, vmuser_shoppergroups, vmusers, waitingusers, worldzones System succesfull restored and sampledata installed, user id of the mainvendor is 990 Info: created table B4kn1_virtuemart_products_ru_ru Info: created table B4kn1_virtuemart_vendors_ru_ru Info: created table B4kn1_virtuemart_categories_ru_ru Info: created table B4kn1_virtuemart_manufacturers_ru_ru Info: created table B4kn1_virtuemart_manufacturercategories_ru_ru Info: created table B4kn1_virtuemart_paymentmethods_ru_ru Info: created table B4kn1_virtuemart_shipmentmethods_ru_ru Info: Данные сохранились Info: Данные сохранены Info: Демо-данные установлены! Info: Taking config from file
Ссылки по теме
Tags: Joomla VM, Virtuemart
Запись опубликована
Понедельник, Ноябрь 5, 2012 в
09:25 и находится в
Joomla .
Вы можете следить за ответами к этой записи через
RSS 2.0 ленту.
Вы можете оставить комментарий, или обратиться к записи со своего сайта.