Database problem? Bug? Help?!?

[buzzville]

I have a new problem I've never seen before. A customer emailed to say that she was unable to check out and received an error message that her credit card billing information is invalid. I logged into my authorize.net account, but her transaction is not listed as declined, making me think the transaction didn't make it as far as authorize.net.

I went to my admin home to look at her account details to see if I could find a clue. Her name was still listed on the Admin Home page under New Customers. When I clicked on her name to review her account, it came up along with another, older customer account. I thought that must be the problem - maybe they have a similar address or email or something that is causing a problem. I reviewed the account info for both, and there is absolutely nothing similar between the two. If I click on any other "New Customer", I only get one customer account displayed. But for some reason, 2 accounts are displayed when I click on hers.

Of course, I don't know that the 2 issues are connected at all, but I thought this might be a clue. The customer says she double checked the billing info and hasn't had trouble using this card. I'm using ZC 1.3.6 with Image Handler, Newsletter Only, Attributes Controller, Email Exporter, Cross Sell, and Stock by Attributes. Does anyone have a suggestion as to what might be going on? Thanks!

[buzzville]

As a follow-up to the puzzle, the customer was trying to purchase a gift certificate and nothing else. She used the same address for shipping and billing. Any ideas?

[Ajeh]

Usually when this happens it is the customer not entering a proper:

credit card number
Expiration Date
CVV

Credit card billing address must match the billing address set in Zen Cart for the order ...

Also, ensure that the card is one that you take ...

Has anyone else had a problem with purchasing just a GV with your site?

It is unusual once you have AuthorizeNet working to have it fail for one person on the validation ... unless the customer is making an error ...

As the error does not sound like it is coming from AuthorizeNet, I would have to think it is the credit card info or ... a possible database error on the customer information ...

If there is in fact a bad record for the customer, this can only be determined through some searching of the database tables in phpMyAdmin to ensure there is only:
customers 1 record
customers_info 1 record
address_book 1 record marked as default but can have multiple records ... note the default should be referenced in the customers table
customers_basket 1 record

Note: just for giggles, ensure that you have in Configuration ... Credit Cards ... all of the cards marked that you do accept via AuthorizeNet