New Zenner
- Join Date:
- Jul 2016
- Posts:
- 61
- Plugin Contributions:
- 0
Order status not updating consistently
Got a fairly vanilla version of 1.5.8 where for the last day or so, when I update orders in the actual order page I get the message "Warning: Nothing to change. The order was not updated." after changing from Pending to Processed and hitting update. There is also no message that the email has been sent.
After the order reloads, the status in the pulldown box (and also on the main orders list page) is showing as processed but the update hasn't been added to the comments list.
I noticed that if I just update the order from the main order list, it seems to update fine, with the correct messages produced, but I can't update from there as I need to add comments to orders (tracking numbers when shipped, etc).
Had a look here and didn't see anything specifically on this.
Also, the server my store is on has been having intermittent load issues, with updates taking quite a while sometimes, is that a likely cause? There have been some warning logs generated with "too many connection" errors in them, such as :
[15-Jul-2024 15:50:28 UTC] Request URI: /index.php?main_page=product_info&cPath=131_331&products_id=2984, IP address: 216.244.xxx.xxx, Language id
#1 mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:76]
#2 queryFactory->connect() called at [/includes/init_includes/init_database.php:22]
#3 require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:199]
#4 require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/1040): Too many connections in /includes/classes/db/mysql/query_factory.php on line 76.
