Cannot add Countries to Tax Code

[Possum Blossom]

The prices of my products are showing up as zero, and I suspect it is because my Tax Zones are not set up correctly. From reading previous postings, I can see that I need to put each Country in a Tax Zones by clicking on the Details button for each Tax Zone.

 

I cannot do this. When I click on the Details button for a Tax Zone, I get the following error message.

 

------------------------------------------------

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 = 1 order by association_id limit -20, 20

-------------------------------------------------

 

I was getting this error message right from the start of using this OSC template that I purchased, so I know that the error is not happening because of something I did wrong. I am very new at using PHP and MySQL and I have tried the following but nothing fixed it.

(1) I changed "order by association_id" to "order by a.association_id" in geozones.php

(2) I uploaded geozones.php from the OSC Default Template but it didn't fix it

(3) I have checked all the field names in the MySQL database

(4) I have deleted all Tax Zones and entered new ones.

 

Please help. Any suggestions would be much appreciated. Thanks, jo

[Daemonj]

This page will provide the correction to your immediate problem.

 

I advise you to follow all of the steps to ensure that your site is secure and update to date.

[Possum Blossom]

This page will provide the correction to your immediate problem.

 

I advise you to follow all of the steps to ensure that your site is secure and update to date.

[Possum Blossom]

Thanks Daemonj,

 

Your helpful advice solved the problem and I can now add details to my Tax Zones. (My prices are still coming up as zero, but I'll keep working on it.)

 

Thanks for the extra info about all the fixes I need to do. (It will take me a while to work through them!)

 

I really appreciate your help. It saved me a lot of time and frustration.

 

jo