SQL 1064 error completing an order

[hughesenergy]

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 's rd [x_city] => Beverley Hills [x_state] => California [x_zip] => 90210 ' at line 1
in:

I assume this is regarding the apostrophe in an address on a live order i placed.How do i fix this so customers can type addresses correctly?I have had a few dropped orders where customers complain of mismatched addresses so this may be the cause,im not sure.

Also have one other anomaly that i caught today and it is the image below-why do i have 2 CC input fields?I dont see anything in zencart admin/config that has caused this?