SQL ERROR [ mysqli ]
That's probably easier than the "back button and retry" method for most operations. One exception may be when submitting a long post. If I refresh the page then, the browser says it can't do it unless it re-sends the data, which makes me think it might eat the post. Probably PTSD from the "Cloudflare ate my post" days, haven't experimented further. Always wise to copy post to clipboard before sending, though it's a couple more extra steps.
Alex has responded to my report - it seems the problem may be caused by a tweak to a timeout setting at the hosting provider, a tweak they'd made.
But as yet, no actual fix.
_________________
Giraffe: a ruminant with a view.
I would suggest copying and pasting one's post into a separate text file, as a backup, before clicking "Submit."
_________________
- Autistic in NYC - Resources and new ideas for the autistic adult community in the New York City metro area.
- Autistic peer-led groups (via text-based chat, currently) led or facilitated by members of the Autistic Peer Leadership Group.
- My Twitter / "X" (new as of 2021)
Yep - I always do, for the more lengthy ones, and not just on WP.
Edit: actually, selecting all the text and copying it to the clipboard is sufficient in most cases and is easily done with Ctrl-A then Ctrl-C
In the event of the text vanishing it can be restored with Ctrl-V to paste into the post.
_________________
Giraffe: a ruminant with a view.
nick007
Veteran
Joined: 4 May 2010
Age: 41
Gender: Male
Posts: 27,297
Location: was Louisiana but now Vermont in the police state called USA
That's probably easier than the "back button and retry" method for most operations. One exception may be when submitting a long post. If I refresh the page then, the browser says it can't do it unless it re-sends the data, which makes me think it might eat the post. Probably PTSD from the "Cloudflare ate my post" days, haven't experimented further. Always wise to copy post to clipboard before sending, though it's a couple more extra steps.
Alex has responded to my report - it seems the problem may be caused by a tweak to a timeout setting at the hosting provider, a tweak they'd made.
But as yet, no actual fix.
Glad to have an idea of what's going on. The hosting provider should prioritize a fix if other sites start reporting problems.
_________________
"I don't have an anger problem, I have an idiot problem!"
"Hear all, trust nothing"
https://memory-alpha.fandom.com/wiki/Ru ... cquisition
I would suggest copying and pasting one's post into a separate text file, as a backup, before clicking "Submit."
That should be fairly bulletproof. I'm too lazy / RSI averse to actually save it to the HD, but my browser has hardly ever crashed and (so far) this current problem isn't a browser-crashing thing.
I really thought WP was down when I arrived today. Must have refreshed at least 6 times and nothing. Even the front page wouldn't open. Different error message there. But in the end I got here. Moral: don't worry.
That's probably easier than the "back button and retry" method for most operations. One exception may be when submitting a long post. If I refresh the page then, the browser says it can't do it unless it re-sends the data, which makes me think it might eat the post. Probably PTSD from the "Cloudflare ate my post" days, haven't experimented further. Always wise to copy post to clipboard before sending, though it's a couple more extra steps.
I just tried hitting that "re-send data" button and it didn't eat my post. But I wouldn't do it without copying post first, just in case.
SQL ERROR [ mysqli ]
Too many connections [1040]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
I'm sure it is being worked on.
I found this. Just trying to help. Although, I understand it could be something more exotic. Perhaps a change was made and SQL connections are running rampant? Or something new is causing more connections than normal?
How to fix: mysql_connect(): Too many connections
I hit the refresh button as well, until the page loads.
My buddy ChatGPT says:
The error message "SQL ERROR [ mysqli ] Too many connections [1040]" indicates that the MySQL server has reached its maximum number of allowed connections. This issue can occur when too many clients are trying to connect to the MySQL server simultaneously, exceeding the limit set in the server's configuration.
Here are the steps to troubleshoot and fix this issue:
1. Check the Current Connection Limit:
- Connect to your MySQL server and run the following command to check the maximum allowed connections:
SHOW VARIABLES LIKE 'max_connections';
- This will display the current limit on the number of connections.
2. Increase the Maximum Connections Limit:
- If the current limit is too low, you can increase it. Edit the MySQL configuration file (`my.cnf` or `my.ini`, depending on your operating system). Find the `max_connections` setting and increase its value. For example:
[mysqld]
max_connections = 200
- After making the change, restart the MySQL server to apply the new configuration.
3. Identify Long-Running Queries:
- Long-running queries can hold connections open for extended periods, contributing to the issue. Use the following command to identify any problematic queries:
SHOW PROCESSLIST;
- This will list all active connections and their states. Investigate and optimize any queries that are running for an unusually long time.
4. Optimize Connection Usage in Your Application:
- Ensure your application is properly closing database connections when they are no longer needed. Using a connection pool can help manage connections more efficiently.
- Review the code in your phpBB forum software or any other applications connecting to the MySQL server to ensure connections are being properly managed and closed.
5. Monitor Connection Usage:
- Set up monitoring to track the number of connections over time. Tools like MySQL Enterprise Monitor, phpMyAdmin, or third-party monitoring solutions can help you identify patterns and potential issues with connection usage.
6. Consider Hardware and Configuration Upgrades:
- If your server consistently reaches the connection limit despite optimization, it might be necessary to upgrade the server hardware or consider a more scalable database architecture, such as a database cluster.
By following these steps, you can address the "Too many connections [1040]" error and improve the reliability and performance of your MySQL server.
_________________
ADHD-I(diagnosed) ASD-HF(diagnosed)
RDOS scores - Aspie score 131/200 - neurotypical score 69/200 - very likely Aspie
ASPartOfMe
Veteran
Joined: 25 Aug 2013
Age: 66
Gender: Male
Posts: 34,672
Location: Long Island, New York
I am taking a break from WP for a while until this is cleared up.
_________________
Professionally Identified and joined WP August 26, 2013
DSM 5: Autism Spectrum Disorder, DSM IV: Aspergers Moderate Severity
“My autism is not a superpower. It also isn’t some kind of god-forsaken, endless fountain of suffering inflicted on my family. It’s just part of who I am as a person”. - Sara Luterman
Well, them SQuirreLs is still nutting around with my connection, even skipping characters when I type too fast.
By the way, I knew it was them SQuirreLs all along. First the servers, then the power lines (or is it the other way around?).
Read the Complete and Unedited Article HERE .
_________________
^ WP remains online 24/7 - just with some irritating extra hoops to jump through.
It is possible, with care, to handle them - see earlier: viewtopic.php?f=13&t=420742&p=9507052#p9506663
_________________
Giraffe: a ruminant with a view.
cecilfienkelstien
Veteran
Joined: 10 May 2006
Age: 40
Gender: Male
Posts: 21,314
Location: Ontario Canada
ElmersTrueLove
Velociraptor
Joined: 8 Feb 2024
Age: 21
Gender: Female
Posts: 453
Location: Elmer Fudd's Cupid form