Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Tax Zones


tnntwister

Recommended Posts

I wanted to insert a new tax zone (European Union). But when i click on the brand new entry, i have that :

 

Tax Zones 	 
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 '-20, 20' at line 1

select a.association_id, a.zone_country_id, c.countries_name, a.zone_id, a.geo_zone_id, a.last_modified, a.date_added, z.zone_name from zones_to_geo_zones a left join countries c on a.zone_country_id = c.countries_id left join zones z on a.zone_id = z.zone_id where a.geo_zone_id = 7 order by association_id limit -20, 20

[TEP STOP]

 

is there a configuration error or something more tricky ?

 

thanks !!

 

FX

Link to comment
Share on other sites

dans catalog/admin/includes/classes/split_page_results.php

 

a la ligne 38

 

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

tu rajoutes

if ($offset < 0) {$offset=0;}

 

That'all :)

Link to comment
Share on other sites

a la ligne 38

 

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

tu rajoutes

if ($offset < 0) {$offset=0;}

the translation for non-french users :

 

inline 38

 

[find] -------------

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

 

[before, add] ----------

if ($offset < 0) {$offset=0;}

 

works fine :)

thx dude ;)

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...