Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL Syntax Error in Royal Mail Zones


Recommended Posts

Please help! I am new here!


I tried to install the UK Royal Mail Shipping Module and got:


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 'd (2):', '6', '0', now())' at line 1.


This information follows the above warning:


insert into oscommerce_configuration(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order. date_added) values (",'MODULE_SHIPPING_ROYALMAIL_ZONES_COST_1', ",'Rates cont'd (2):', '6', '0', now())



Link to comment
Share on other sites

Hi Vger


Thanks for this. I did suspect the ' by itself was causing the problem but I'm not familier with the codes yet. I am an ex C++ which is different.


Your advice worked a treat!


Thanks a million!



Link to comment
Share on other sites


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

  • Create New...