Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

can not create a sub tax zone in a newly created tax zone


Recommended Posts

hi all,


can you please help. i have been trying to create a new tax zone and its sub zone under Administration pages but with no join. Here is what i can do, i can create a new tax zone without any problems. Here what i can't do, when I click on a new tax zone hoping to go in and create a sub tax zone but all i get is the following message.


Tax Zones


Country Zone Action

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 '-4, 4' 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 = 9 order by association_id limit -4, 4




can you guys please help.





Link to comment
Share on other sites


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

  • Create New...