if anyone has a fix for this please let me know but, I have done alot of testing to make sure that i did "find" this error and have it narrowed down to what it is.

I have a Product called

-O'Keeffe's Working Hands

and the Products Manufacturer is

-O'Keeffe's

I only have one payment option inabled and that's
authorize.net (aim)

if you have a quote in the product name it will error out your checkout on the final step.

but if you take the sigle quote out of the name it works just fine.

the error i get is

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 'Keeffe's Working Hands(qty: 1) [Date] => July 6, 2007, 2:52 pm [IP] => ' at line 1
in:
[insert into zen_authorizenet (id, customer_id,order_id, response_code, response_text, authorization_type, transaction_id, sent, received, time, session_id) values ('', '1', '1', '3', '(TESTMODE) The merchant login ID or password is invalid or the account is inactive.', 'auth_capture', '0', 'Array ( [x_login] => ******* [x_tran_key] => ******* [x_relay_response] => FALSE [x_delim_data] => TRUE [x_version] => 3.1 [x_type] => AUTH_CAPTURE [x_method] => CC [x_amount] => 17.33 [x_card_num] => *******0015 [x_exp_date] => 0109 [x_card_code] => ******* [x_email_customer] => FALSE [x_email_merchant] => FALSE [x_cust_id] => 1 [x_invoice_num] => TEST-1 [x_first_name] => William [x_last_name] => Lamoreaux [x_company] => [x_address] => 1500 Preston Rd [x_city] => Dallas [x_state] => Texas [x_zip] => 75093 [x_country] => United States [x_phone] => 469-212-4850 [x_email] => WilliamLamoreaux###################### [x_ship_to_first_name] => William [x_ship_to_last_name] => Lamoreaux [x_ship_to_address] => 1500 Preston Rd [x_ship_to_city] => Dallas [x_ship_to_state] => Texas [x_ship_to_zip] => 75093 [x_ship_to_country] => United States [x_description] => O'Keeffe's Working Hands(qty: 1) [Date] => July 6, 2007, 2:52 pm [IP] => 71.123.143.121 [Session] => 0ae8875fe62a244c35dc3021f57ed2db [x_test_request] => TRUE [url] => https://secure.authorize.net/gateway/transact.dll ) ', '1=3&2=2&3=13&4=%28TESTMODE%29+The+merchant+login+ID+or+password+is+invalid+or+t he+account+is+inactive.&5=000000&6=P&7=0&8=&9=&10=17.33&11=&12=auth_capture&13=& 14=&15=&16=&17=&18=&19=&20=&21=&22=&23=&24=&25=&26=&27=&28=&29=&30=&31=&32=&33=& 34=&35=&36=&37=&38=9F7D8E6783D5B5C8D3989A95DA9AF5AF&39=&40=&41=&42=&43=&44=&45=& 46=&47=&48=&49=&50=&51=&52=&53=&54=&55=&56=&57=&58=&59=&60=&61=&62=&63=&64=&65=& 66=&67=&68=&69=July+6+2007+2%3A52+pm&70=71.123.143.121&71=0ae8875fe62a244c35dc30 21f57ed2db', 'July 6, 2007, 2:52 pm', '0ae8875fe62a244c35dc3021f57ed2db')]