romank Posted April 2, 2013 Share Posted April 2, 2013 Hello, we are running 5.0.7 with no option to upgrade due to numerous custom modifications and features. We receive around 10 order every day, using Paypal as the only payment option. We started having a very serious issue with the orders for last couple of months/weeks, when the customer goes through the order process, completes the payment which appears in our Paypal account, but the order (summary) itself is not saved into the database, meaning we dont really know about it. When I search the entire database for the lost order ID, I see records in following tables: store_CubeCart_order_history store_CubeCart_order_inventory store_CubeCart_order_tax store_CubeCart_request_log store_CubeCart_transactions But NOT the all important CubeCart_order_summary. I tried setting up a debug condition for the database classes to detect if there is a "DELETE" and "order_summary" being executed, but Ive got nothing - meaning the summary is not saved at all. Example data of one such lost order: Status Date/Time Processing 13 Mar 2013, 20:39 Pending 13 Mar 2013, 20:37 The order inventory: [snip, three valid products] Transaction log: PayPal Card Payment: Success, Exact match for AVS data. CVV2 correctly matched., TXNID: 4FC98336766[snip, correct TXN ID] Do you have any idea why the order is not being saved? I tried going through the order process in the classes, but I see no vulnerable points - and we have done no adjustments to the order process. Was this a bug fixed in some of the latter versions, or could it be a Paypal issue? Thank you in advance for any input, as this is a very serious issue. Roman Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 2, 2013 Share Posted April 2, 2013 By having an order not be saved in CubeCart_order_summary, I would say that they won't show up in the Orders list in the admin screens. Can you verify that? I would also ask that you verify if your hosting provider has upgraded MySQL at the time the order summaries started going missing. If MySQL was upgraded, the MySQL operating mode may have been set to STRICT mode. CubeCart is not programmed to accommodate a STRICT mode database. Please learn how to check if your database is running in STRICT mode. (Truly, if this is the case, there would be many more anomalies to CubeCart's behavior.) Please view the CubeCart_log tables for messages from the database that may indicate a failed INSERT. Quote Link to comment Share on other sites More sharing options...
romank Posted April 2, 2013 Author Share Posted April 2, 2013 I can verify the orders dont show up in the Orders section. You cant really tell the order has been placed unless you search the database. When I run this code: SELECT @@GLOBAL.sql_mode I get an empty result - from what I have found, that means no mode has been set. There is no CubeCart_log in my installation, but I cant find anything in CubeCart_system_error_log nor CubeCart_admin_error_log tables. We have two 5.0.7 installations running and I just found out the issue is present also in the second installation - which we barely touched and did any mods to - meaning there really is a minimal chance that it is our fault. Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 2, 2013 Share Posted April 2, 2013 (Feel free to create a sig-line with details of your installations.) Of your CC507 installations, is either one of them on a server that you have access to the database server? If so, does the database server have an error log that you can look at? If not, we can try something else. Quote Link to comment Share on other sites More sharing options...
romank Posted April 2, 2013 Author Share Posted April 2, 2013 Here is a tail (40) of a mysql error log. It goes back as 25.3. and we have had a faulty order since then, so if it was supposed to be in the log, it would be there. I can set it to a more paranoid log settings if its possible? but I dont think this is where the problem lays. root@expert [/var/lib/mysql]# tail -n 40 <my server>.err 130325 16:19:50 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.68-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 130326 0:19:26 [Note] /usr/sbin/mysqld: Normal shutdown 130326 0:19:26 [Note] Event Scheduler: Purging the queue. 0 events 130326 0:19:28 InnoDB: Starting shutdown... 130326 0:19:30 InnoDB: Shutdown completed; log sequence number 0 787240369 130326 0:19:30 [Note] /usr/sbin/mysqld: Shutdown complete 130326 00:19:30 mysqld_safe mysqld from pid file /var/lib/mysql/<my server>.pid ended 130326 00:19:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130326 0:19:41 [Warning] /usr/sbin/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 130326 0:19:41 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 130326 0:19:41 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead. 130326 0:19:41 [Note] Plugin 'FEDERATED' is disabled. 130326 0:19:41 InnoDB: Initializing buffer pool, size = 8.0M 130326 0:19:41 InnoDB: Completed initialization of buffer pool 130326 0:19:42 InnoDB: Started; log sequence number 0 787240369 130326 0:19:42 [Note] Event Scheduler: Loaded 0 events 130326 0:19:42 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.68-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 130326 0:19:43 [Note] /usr/sbin/mysqld: Normal shutdown 130326 0:19:43 [Note] Event Scheduler: Purging the queue. 0 events 130326 0:19:43 InnoDB: Starting shutdown... 130326 0:19:47 InnoDB: Shutdown completed; log sequence number 0 787240369 130326 0:19:47 [Note] /usr/sbin/mysqld: Shutdown complete 130326 00:19:47 mysqld_safe mysqld from pid file /var/lib/mysql/<my server>.pid ended 130326 00:19:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130326 0:19:48 [Warning] /usr/sbin/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 130326 0:19:48 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 130326 0:19:48 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead. 130326 0:19:48 [Note] Plugin 'FEDERATED' is disabled. 130326 0:19:48 InnoDB: Initializing buffer pool, size = 8.0M 130326 0:19:48 InnoDB: Completed initialization of buffer pool 130326 0:19:48 InnoDB: Started; log sequence number 0 787240369 130326 0:19:48 [Note] Event Scheduler: Loaded 0 events 130326 0:19:48 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.68-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) root@expert [/var/lib/mysql]# Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 2, 2013 Share Posted April 2, 2013 That wasn't the error log I was referring to. Let's take this to Private Message for the time being. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.