Ошибка при установке демо-данных в Virtuemart 2.0.12f

Ноябрь 5, 2012

Ошибка выглядит следующим образом:

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

В файле заменяем:

  1. product_price_vdate --> to product_price_publish_up
  2. product_price_edate --> to product_price_publish_down

Сохраняем файл и:

  1. переходим Компоненты - Virtuemart - Инструменты - Панель управления - Настройки.
  2. Отмечаем "Обновление базы данных" и сохраняем изменения.
  3. переходим в "Инструменты и миграция".
  4. нажимаем "Восстановить таблицы и установить демо данные".
Видим сообщение об успешном обновлении:
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: ,

Запись опубликована Понедельник, Ноябрь 5, 2012 в 09:25 и находится в Joomla . Вы можете следить за ответами к этой записи через RSS 2.0 ленту. Вы можете оставить комментарий, или обратиться к записи со своего сайта.

Оставить Комментарий

*