Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Shipping SQL Errors Help


jamesshirley

Recommended Posts

When I goto Shipping Modules and install Parcelforce 48 I get the following error message.

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':14.25,15:18.25,20:22.25,25:26.25,30:30.25,40:38.25,50:46.25,100:86.50', 'Enter ' at line 1

 

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Parcel Force 48 Rates', 'MODULE_SHIPPING_PARCELFORCE48_COST_1', 10:14.25,15:18.25,20:22.25,25:26.25,30:30.25,40:38.25,50:46.25,100:86.50', 'Enter values upto 5,2 decimal places. (12345.67) Example: .1:1,.25:1.27 - Weights less than or equal to 0.1Kg would cost £1.00, Weights less than or equal to 0.25g but more than 0.1Kg will cost £1.27. Do not enter KG or £ symbols.', '6', '0', now())

 

[TEP STOP]

 

 

Also this happens when I install Initial Citylink

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':11.6,15:14.1,20:16.60,25:19.1,30:21.6,35:24.1,40:26.6,45:29.1,50:31.6,55:34

.1,6' at line 1

 

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Initial Citylink Rates', 'MODULE_SHIPPING_CITYLINK_COST_1', 10:11.6,15:14.1,20:16.60,25:19.1,30:21.6,35:24.1,40:26.6,45:29.1,50:31.6,55:34.1

,60:36.6,65:39.1,70:41.6,75:44.1,80:46.6, 100:56.6,125:69.1,150:81.6,200:106.6, 'Enter values upto 5,2 decimal places. (12345.67) Example: .1:1,.25:1.27 - Weights less than or equal to 0.1Kg would cost £1.00, Weights less than or equal to 0.25g but more than 0.1Kg will cost £1.27. Do not enter KG or £ symbols.', '6', '0', now())

 

[TEP STOP]

 

What am I doing wrong ?

Link to comment
Share on other sites

What am I doing wrong ?

As you can see there is a single quote missing on the beginning of 10:14.25,:

'MODULE_SHIPPING_PARCELFORCE48_COST_1', 10:14.25,15:18.25,20:22.25,25:26.25,30:30.25,40:38.25,50:46.25,100:86.50',

Should be fixed in the code of that query.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...