Order status not updating consistently

[Lance Turner]

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.

[mc12345678]

Mention that using 1.5.8; however, that primary version had a sub version applied followed by additional updates that didn't make it into a sub version but instead just live on github and may have made it into version 2.0 (now at 2.0.1)

So, are you using 1.5.8 or a variation of 1.5.8a?

[Lance Turner]

Sorry, yes, 1.5.8a.

[Lance Turner]

It seems to be behaving itself at the moment, and the server load is lower, so I suspect the server was the issue.

[njcyx]

"Too many connections" error could mean, your server has a low "max_user_connections" value. So if there are many visits at one time, it may over this limit. If that is your case, you may contact your server to increase that limit. Or use the following "rotating db users' way.

https://www.zen-cart.com/showthread....er_connections

Or, it means they are some hackers tried to attack your site via DDoS. You can check the log files on your server side to figure it out.