News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

unable to install sample data

Started by rainman127, March 08, 2008, 23:34:31 PM

Previous topic - Next topic

rainman127

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'
VirtueMart Version: VirtueMart_1.1.0_RC1-COMPLETE_PACKAGE.j15

Joomla/Mambo Version: Joomla 1.5

windows xp sp2
apache 2.2
php version: 5.2.5
mysql version: 5.0.41-community-nt


websnail

#2
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.