Totally Zenned
- Join Date:
- Feb 2011
- Location:
- Lumberton, TX
- Posts:
- 636
- Plugin Contributions:
- 0
Odd Problems with one Order Missing and One totaling incorrect.
Server Information
Server Host: server.radiant-holidays.com (162.144.60.198) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.32-431.3.1.el6.x86_64 Database: MySQL 5.5.36-cll
Server Date: 03/11/2014 18:51:40 Database Date: 03/12/2014 00:51:40
Server Up Time: 00:51:40 up 44 days, 2:29, 0 users, load average: 0.00, 0.15, 0.14 HTTP Server: Apache
PHP Version: 5.3.26 (Zend: 2.3.0) PHP Memory Limit: 128M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 50M POST Max Size: 10M
Database Data Size: 10,410 kB Database Index Size: 2,196 kB
Well, I have a missing order. PP went through fine but I cannot locate the order or the transaction ID in any of the database files (checked back office first and did not find anything) via SQL. I have only an amount, PP transaction ID and the zenID from PP. There are NO order numbers skipped period. How do I go about looking further than looking for the last name in the order tables and the PP Transaction number in the PP tables??
As for the Subtotal and Totals, the amounts listed in the Admin do not match. If you add up the extended amounts, the total is off by over $13? How would I go about looking for this problem??
I did check my PP info in the Payment Module to make sure that has not been hacked.