Shipping Module Setup

[aiostore]

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())

 

[TEP STOP]

[♥Vger]

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 ;

}

 

Vger