Missing order details -- Authorize.net

BS”D

I am using Authorize.net (AIM).

The customer completes the purchase and we both get an email confirmation from Authorize.net but the order does not show up in ZenCart. I have no way to tell what attributes the customer chose or their shipping method. Since the order doesn’t show in ZenCart, the next customer who orders gets the same order/invoice number. How can I fix this?

Mordechai

Can you please provide more details ...

1. a)Click the "Reply" button below, and answer all the questions listed on the next screen.
   b) Please be very detailed in the exact symptoms that occur as the checkout completes ... do you see the order confirmation screen? Do you get a blank screen somewhere?
2. Turn on debug logging in your AIM module and post the logs it generates after placing an order.
3. Install the debug logging util from step 2a of this FAQ article, and post the errors it logs after placing an order: https://www.zen-cart.com/tutorials/index.php?article=82

BS”D

I am using Authorize.net (AIM) and Version Zen Cart 1.3.7.1

I read about the problem with quotes and apostrophes causing the problem with an order going to Authorize.net but then does not show up in ZenCart. Some of out product names have apostrophes. I did a test and was able to duplicate the problem. When I hit confirm I got a white screen with this code:

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(qty: 1) [Date] => February 10, 2009, 4:39 pm [IP] => 75.161.193.6 ' 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 ('', '27', '910', '1', 'This transaction has been approved.', 'auth_capture', '2298531104', '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] => 0.02 [x_card_num] => *******3743 [x_exp_date] => 0910 [x_card_code] => ******* [x_email_customer] => TRUE [x_email_merchant] => TRUE [x_cust_id] => 27 [x_invoice_num] => 910 [x_first_name] => Mark [x_last_name] => Dorfman [x_company] => [x_address] => 1747 Ford Parkway [x_city] => St Paul [x_state] => Minnesota [x_zip] => 55116 [x_country] => United States [x_phone] => 651-284-0503 [x_email] => [email protected] [x_ship_to_first_name] => [x_ship_to_last_name] => [x_ship_to_address] => [x_ship_to_city] => [x_ship_to_state] => [x_ship_to_zip] => [x_ship_to_country] => [x_description] => Test MD's(qty: 1) [Date] => February 10, 2009, 4:39 pm [IP] => 75.161.193.6 [Session] => 2v79dnpdj760efi3noaekip8u7 [url] => https://secure.authorize.net/gateway/transact.dll ) ', '1=1&2=1&3=1&4=This+transaction+has+been+approved.&5=551453&6=Y&7=2298531104&8=910&9=Test+MD%27s%28qty%3A+1%29&10=0.02&11=CC&12=auth_capture&13=27&14=Mark&15=Dorfman&16=&17=1747+Ford+Parkway&18=St+Paul&19=Minnesota&20=55116&21=United+States&22=651-284-0503&23=&24=thedorfmans%40gmail.com&25=&26=&27=&28=&29=&30=&31=&32=&33=&34=&35=&36=&37=&38=9D29C7101665B1DD5CBCF877DC705938&39=M&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=February+10+2009+4%3A39+pm&70=75.161.193.6&71=2v79dnpdj760efi3noaekip8u7', 'February 10, 2009, 4:39 pm', '2v79dnpdj760efi3noaekip8u7')]

How can I fix this problem?

Thanks,
Mordechai

There's an updated module for your old version of Zen Cart:
http://www.zen-cart.com/forum/showthread.php?p=441023#post441023

BS"D

It works but I get this Error message:
WARNING: Security hash problem. Please contact store-owner immediately. Your order has not been fully authorized.

When I set the MD5 hash 'phrase' in your Authorize.net merchant account settings can I use any phrase?

Where do I enter that same phrase in your Zen Cart AIM module settings? I do not see a field for it in the Admin>Modules>Payment Modules>Authorize.net (AIM)

BS"D

In the ZenCart Admin>Modules>Payment Modules I uninstalled Authorize.net (AIM) and then re-installed it. The proper fields (including MD5 Hash) showed up and I re-populated the fields with the settings I had saved from before.

I chose to leave the MD5 Hash filed blank here and in my Authorize.net settings at least for now. Is it really better to put in a phrase?

Now it works fine without any error messages.

The only differences I noticed is that, with the email notifications of the transactions from Authorize.net, it now adds a hyphen and 6 random characters at the end of the Invoice Number. Does this matter?

Also, with the new module there is nolonger the option to Store the Credit Card Number.

Thanks for your help Dr. Byte! This has cleared up a problem that has been bugging us for months.

Regards,
Mordechai

You don't need to set a hash in the AIM module. The hash is mostly for backward compatibility for the less-reliable SIM module. It's fine to leave it blank.

The added letters at the end of the order number are an added feature to keep order numbers unique on the authnet end in the rare event that a duplicate order "number" (digits only) gets submitted due to 2 people clicking to confirm their order at the same time.

As for storing CC number, none of the modules will do that now, for security reasons.

hi.
i'm using 1.3.7.1 and getting the same 1064 error mentioned above. i don't really understand from this thread what's causing the error. is it something in the description of the products? do i just need to reinstall the authorize.net mod. i'm just getting the error but not the issue with the order not going through.

If the error message is identical, then the solution is the same.

I'm not asking what the solution is. I'm asking what is the cause of this error.

Okay, let me rephrase. If the error message is in fact identical, then the cause is also the same: apostrophes in the product names.