VirtueMart Forum

VirtueMart Dev/Coding Central: VM1 (old version) => Quality & Testing VirtueMart 1.1.x => Virtuemart 1.1 Development (Archiv) => Q&T Resolved => Topic started by: rainman127 on March 08, 2008, 23:34:31 PM

Title: unable to install sample data
Post by: rainman127 on March 08, 2008, 23:34:31 PM
Steps to replicate:
VirtueMart 1.1 installs just fine but insert sample data returns a screen that says Update Log. does not insert sample data.

Proposed fix(es):
in jos_vm_shipping_rate table the shipping_rate_value  field type=decimal(10,2).

in virtuemart.sample_data.sql replace commas with periods in value reference to this field.
example:
INSERT INTO `jos_vm_shipping_rate` VALUES (5,'EU+ >  4kg','1','AND;BEL;DNK;FRO;FIN;FRA;GRC;GRL;GBR;IRL;ITA;LIE;LUX;MCO;NLD;AUT;POL;PRT;SMR;SWE;CHE;SVK;ESP;CZE','00000','99999','0.0','4.0','14,57','2','47','0','5');

change the value '14,57' to '14.57'
Title: Re: unable to install sample data
Post by: aravot on March 11, 2008, 21:59:46 PM
I could not duplicate this, installed it 2 times both times was successful.
Title: Re: unable to install sample data
Post by: websnail on March 27, 2008, 16:45:34 PM
Quote from: aravot on March 11, 2008, 21:59:46 PM
I could not duplicate this, installed it 2 times both times was successful.
Edit:  Removed as problem related to the virtuemart.installation.joomla.sql file.