Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Shipping Module Setup


Recommended Posts

Could someone please help me to install Royal Mail Shipping Module?

I get the following error message while trying to setup.


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


insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('', 'MODULE_SHIPPING_ROYALMAIL_ZONES_COST1_1', '', 'Rates cont'd (2):', '6', '0', now())



Link to comment
Share on other sites

I'm guessing that you deleted the other modules before installing this one, which can cause an error between MySQL 4.1 and osCommerce. This is the fix:


admin/includes/classes/split_page_results.php around lines 37 and 38 you'll find this:


$offset = ($max_rows_per_page * ($current_page_number - 1));

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;


sandwich the code below between the two lines above:


if ($offset < 0)


$offset = 0 ;




Link to comment
Share on other sites


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

  • Create New...