Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: perkins on November 06, 2012, 11:01:09 AM

Title: Unknown column product_price_vdate
Post by: perkins on November 06, 2012, 11:01:09 AM
Hi,

by clicking on the Star Migration button the system displays the message

http://forum.virtuemart.net/index.php?topic=95236.0
(point 12)

vmError: TableProduct_prices::store failed - Unknown column 'product_price_vdate' in 'field list' SQL=INSERT INTO `j25_virtuemart_product_prices` (`virtuemart_product_id`,`product_price`,`product_tax_id`,`product_discount_id`,`product_currency`,`product_price_vdate`,`product_price_edate`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('1','219.99000','8','1','47','0','0','0','0','2012-11-06 08:32:21','0','2012-11-06 08:31:51','62')

Product price is missing on the product detail page.

The table j25_virtuemart_product_prices is empty.

Joomla 2.5.7 , virtuemart 2.0.12f  (from joomla 1.5.15 , virtuemart 1.1.9)

Thanks for your help.
Title: Re: Unknown column product_price_vdate
Post by: WebStuff on November 06, 2012, 14:02:45 PM
If you use the 2.0.10 package to update products it works. Obviously a bug in 2.0.12f migrate procedure.

Hope this helps.
Title: Re: Unknown column product_price_vdate
Post by: jenkinhill on November 06, 2012, 19:01:16 PM
The migration bug is already fixed in SVN ready for the next release. Well spotted.
Title: Re: Unknown column product_price_vdate
Post by: Jason Farmer on November 07, 2012, 01:02:05 AM
I expect that this is related...

I get the same sort of error when installing sample data into a new install of vm2.0.12f j2.5.7

QuoteJInstaller::install: /var/www/vhosts/problemsolver.co.uk/vm/administrator/components/com_virtuemart/install/install_sample_data.sql SQL Error DB function failed with error number 1054
Unknown column 'product_price_vdate' in 'field list' SQL=-- -- Dumping data for table `jos_virtuemart_product_prices` -- INSERT INTO `jos_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/vhosts/problemsolver.co.uk/vm/administrator/components/com_virtuemart/install/install_sample_data.sql
Title: Re: Unknown column product_price_vdate
Post by: jenkinhill on November 07, 2012, 09:58:53 AM
No I have not seen that error. Maybe related to your MySQL version, but nothing obvious in the message there?
Title: Re: Unknown column product_price_vdate
Post by: Jason Farmer on November 09, 2012, 14:20:55 PM
Well, I think that both errors stem from the fact that the field {}_virtuemart_product_prices.product_price_vdate has been removed or renamed in 2.0.12f

The sample data sql has obviously not been updated to reflect this change.
Text only | Text with Images