I have a client that received payment for an item that showed up in their payment processor, but there is no record of it in the backend. There are order numbers before and after. What could have caused this?
Mark Newsom Web Consultant P.O. Box 852 Kimberling City, MO 65686
It's very difficult to say with one-off occurrences like this but it may have just been a server glitch right at the time of payment or something along those lines.
Hi Mark, it may be there, but just as an unauthorized order. Have they checked there? Sometimes orders come in out of sync as well. In other words, if a customer abandons a cart where they have made it as far as the shipping options, then an order number is assigned at that point. If the customer comes back the next day and completes checkout, then when looking at the list of orders in the admin, it will not always be the most recent order in the system.
Of course I understand you (and your client) may already know these things, but sometimes here on the forum, I have seen where some people have not seen this before. There is also a number of ways to locate orders, so it depends on how users do this, as to whether an order might go unnoticed on occasion.
We searched by name and didn't find anything either, so it must have been a total hiccup with the transaction due to server connectivity during the transaction. Luckily their payment gateway collected enough info where they could contact the buyer and figure out what they purchased. Thanks for all of your help, Dave and Andy! Have a good weekend.
Mark Newsom Web Consultant P.O. Box 852 Kimberling City, MO 65686
This is happening again. Here is what my client's customer encountered:
I'm having the same issue as before. On 6/7 I bought a 2 bed Holiday inn Desert Club for $549 after checkout I received a screen that said approved then it showed a screen that said error. I received no invoice to my email but my card was charged. On Monday another listing showed on the site, I wasn't sure if it was the same one being relisted or a new one. I purchased it and had the same error.
Mark Newsom Web Consultant P.O. Box 852 Kimberling City, MO 65686
I'm not a developer so wouldn't be able to properly troubleshoot a third party integration I'm afraid. Can you contact the developer who set it up as I doubt it was done here.
Okay, this is still going on. I had my client set up a test product and when they went through the process of buying it, they got the following error. The transaction shows up in the payment processor, but no record in the store's admin.
"Access denied for user ''@'localhost' (using password: NO)Access denied for user ''@'localhost' (using password: NO)
Cannot find details for order id: 5148"
Mark Newsom Web Consultant P.O. Box 852 Kimberling City, MO 65686
Did this problem start when any change occurred on your site, for example after updating, updating the PHP version, making changes to db_conn_open.php - anything like that as the error suggests a database connection related issue.
No, not that I am aware of. The client doesn't have access to Cpanel, updates, etc. The rest of the store works fine. They are able to add, modify, and delete records, etc.
Mark Newsom Web Consultant P.O. Box 852 Kimberling City, MO 65686
Hi Mark Is it possible that the script is only set up for a mySQL (old) and not a mySQLi (new) database connection? In any case, please send the site FTP login details to vince AT ecommercetemplates DOT com and I'll look into it.
Hi Mark I had a look at the site and it seems the scripts for the payment processor are very out of date, and that is why you are having problems. So can you get a new set of the scripts from here... https://www.ecommercetemplates.com/free_downloads.asp#payment Then follow the instructions here about setting up USA Epay as you now need a PIN number as part of the integration... https://www.ecommercetemplates.com/phphelp/ecommplus/USAepay.asp Then try a test transaction and please let me know how it all goes, but hopefully that should sort it all out for you.
Order in gateway - Not in backend
Posted - 05/30/2019 : 06:30:09
