Can't click to view the order when the zone name has '

[nycbags]

Hi all,

 

This is a weird problem i've ever seen. For almost a year, I can click to view the orders and process them. However, recently there is one order with the state name cote d'azur in France. When I click to view the order details, it shows

 

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 'azur'' at line 1

 

select * from zones where zone_country_id = '73' and zone_name = 'cote d'azur'

 

[TEP STOP]

 

 

I try to take the ' out in the entry_state field in address_book table in db. still, the problem remains.

 

In the table zones in db, there are no value of 73 for zone_country_id and cote d'azur for zone_name

 

Any solutions to this? Thankss loads

[L!mit]

hmm- maybe its the apostrophe messing it up ? You can always try removing the apostrophe from the database zone_name and see if it makes a difference. Backup first!