1064 - You have an error

[thumb]

Moved to a new server and when I click on checkout, I get this error:

 

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 ') left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_cou' at line 1

 

select tax_description from (tax_rates tr) left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id)) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '49') and tr.tax_class_id = '1' order by tr.tax_priority

 

Before this error, I could not add anything to the cart then I did the "how to fix the 1054-problem". Now I can add to the cart but get the above error when clicking on Checkout

[thumb]

Anyone have an idea? Here's the link to the site. To see the error, just click on an item, click on the buy button, and then click on checkout. Since you're on the site for the first time, it may ask for info for an account, just put in anything

 

https://www.tamjets.com/original/

[MrPhil]

You did it wrong. Change

select tax_description from (tax_rates tr) left join

to

select tax_description from (tax_rates tr left join

Actually, since there is no comma-separated list of tables, you could even do this:

select tax_description from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join

[thumb]

You did it wrong. Change

select tax_description from (tax_rates tr) left join

to

select tax_description from (tax_rates tr left join

Actually, since there is no comma-separated list of tables, you could even do this:

select tax_description from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join

 

Thanks MrPhil! Although that wasn't what was causing the error, your fix pointed me to the right place that needed to be fixed. I actually had changed it from this:

select tax_description from (tax_rates tr left join

and then back to this and it worked:

select tax_description from (tax_rates tr) left join

 

It was a PHP 5.0 fix that needs that to be closed. I don't know why it gave me the error in the first place.