URL: https://store.subitomusic.com
ZC version: v1.5.6a
MYSQL/PHP versions: MySQL 5.7.31 / 7.2.33
MySQL Mode: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION
Last week, I had to migrate a client's site to a new server with the specs shown above. Their ZenCart was previously running on a server with the following specs:
URL: https://store.subitomusic.com
ZC version: v1.5.6a
MYSQL/PHP versions: MySQL 5.6.47 / 5.6.40
MySQL Mode: NO_ENGINE_SUBSTITUTION
Since this migration, they have had a couple of occurrences where a customer placed an order and paid by credit card but the order was never added to ZenCart. There must have been some kind of error shown but the customer clicked confirm a few more times, causing the charge to be duplicated several times in authorize.net but still no order recorded in the zencart database.
I was able to get the customer's IP from authorize.net and search over the debug logs in the logs folder but nothing is coming up that is related to their transaction. The only logs that come up are a warning about a missing language define and this is not from the shopping cart page. It is only from the product info page that they viewed before they ordered the item.
Since this is not happening to every customer, I'm a bit baffled what's going on. I wondered if there was something about either the php version, MYSQL version or MYSQL mode that is interacting differently with authorize.net. Of course, I realize it's next to impossible to determine this without seeing the error that the customer got (or at least having them recount it). I just thought this might ring a bell if someone had something similar.
Thanks for any advice about the issue and/or additional steps I might take to get to the bottom of it.
Bookmarks