General Error SQL ERROR [ mysqli ]

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
formosan
Registered User
Posts: 32
Joined: Thu Jul 20, 2017 3:20 pm

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Thu Oct 12, 2017 10:34 am

To be clear, phpBB did not shut down your site.

Why you're seeing the error message in phpBB is because phpBB is connecting to your database server, and the database server is returning the error message that the limit of connections is reached. So phpBB only displays the error that it gets from the database server as the database won't give it the data it expects.

So this error message is caused by the limit on the database server and not by phpBB which, as noted in the topic, is set quite low by your host.
I was wrong, it actually isn't that low..

And there was not a sudden surge two days ago that would have caused this..

I upgraded, so by the end of the day I should know if that will work..

It just seems so strange, a very small board would get this right out of the blue.

formosan
Registered User
Posts: 32
Joined: Thu Jul 20, 2017 3:20 pm

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Thu Oct 12, 2017 8:11 pm

It seems the maximum number of processes is 15 and I currently have 17..

How can i eliminate a couple of them?

formosan
Registered User
Posts: 32
Joined: Thu Jul 20, 2017 3:20 pm

Are all these processes necessary?

Post by formosan » Fri Oct 13, 2017 1:22 am

The number of processes running this is a coding issue..

The limit is 15 and you are at 17. I am including the active processes that are running.
*] Current processes running for theblvb2:

theblvb2 354980 0.0 0.0 335048 16540 ? D Oct10 0:00 /usr/php/56/bin/php-cgi /home8/theblvb2/public_html/index.php
theblvb2 413577 0.0 0.0 0 0 ? Z 04:32 0:00 [php-cgi] <defunct>
theblvb2 415884 0.0 0.0 0 0 ? Z 04:33 0:00 [php-cgi] <defunct>
theblvb2 431293 0.0 0.0 0 0 ? Z 04:37 0:00 [php-cgi] <defunct>
theblvb2 432625 0.0 0.0 0 0 ? Z 04:38 0:00 [php-cgi] <defunct>
theblvb2 438336 0.0 0.0 0 0 ? Z 04:40 0:00 [php-cgi] <defunct>
theblvb2 444987 0.0 0.0 188276 18564 ? S 04:43 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php
theblvb2 448868 0.0 0.0 188276 18176 ? S 04:44 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/app.php
theblvb2 453602 0.0 0.0 188276 18552 ? S 04:46 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php
theblvb2 457300 0.0 0.0 188280 18184 ? S 04:47 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/app.php
theblvb2 459261 0.0 0.0 188276 18180 ? S 04:48 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/app.php
theblvb2 460114 0.0 0.0 188276 18564 ? S 04:48 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php
theblvb2 466575 0.0 0.0 188276 18560 ? S 04:51 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php
theblvb2 470270 0.0 0.0 188276 18172 ? S 04:52 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/app.php
theblvb2 472918 0.0 0.0 188276 18568 ? S 04:53 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php
theblvb2 473972 0.0 0.0 188276 18172 ? S 04:53 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/app.php
theblvb2 478741 0.0 0.0 188276 18560 ? S 04:54 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php
theblvb2 480743 0.0 0.0 188276 18184 ? S 04:55 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/app.php
theblvb2 484517 0.0 0.0 188276 18568 ? S 04:56 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php
theblvb2 485931 0.0 0.0 188276 18564 ? S 04:57 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php
theblvb2 488291 0.1 0.0 188276 18180 ? S 04:58 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/app.php
theblvb2 492443 4.0 0.0 188276 18572 ? S 04:59 0:00 /opt/php70/bin/php-cgi /home8/theblvb2/public_html/viewtopic.php


[*] Current process count: 17

This is something that the host can not delete or change due to this being a custom set up..

Changing the wrong stuff can cause a bigger issue.

formosan
Registered User
Posts: 32
Joined: Thu Jul 20, 2017 3:20 pm

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Fri Oct 13, 2017 2:52 am

The problem is a coding issue..

I need someone with some web developing experience to help me eliminate some things, so I can get my site up and running again.

formosan
Registered User
Posts: 32
Joined: Thu Jul 20, 2017 3:20 pm

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Fri Oct 13, 2017 3:03 am

Can someone advise what I need to do to with my hosting panel to bring my site back up again?

janus_zonstraal
Registered User
Posts: 1740
Joined: Sat Aug 30, 2014 1:30 pm

Re: General Error SQL ERROR [ mysqli ]

Post by janus_zonstraal » Fri Oct 13, 2017 4:48 am

Copy everything to a other host and your site can be back in one hour.

https://www.phpbb.com/support/docs/en/3 ... or-domain/
Sorry! My English is bat ;) !!!

User avatar
david63
Jr. Extension Validator
Posts: 12974
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post by david63 » Fri Oct 13, 2017 6:02 am

formosan wrote:
Fri Oct 13, 2017 1:22 am
This is something that the host can not delete or change due to this being a custom set up..
Obviously this "custom" setup is not set up correctly otherwise everyone else would be having this same problem.
formosan wrote:
Fri Oct 13, 2017 1:22 am
The number of processes running this is a coding issue..
Not sure how in the code you can limit the number of people visiting your site.

I agree with janus - find a host that knows how to run a server correctly.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email or as they will be ignored

formosan
Registered User
Posts: 32
Joined: Thu Jul 20, 2017 3:20 pm

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Fri Oct 13, 2017 10:11 am

janus_zonstraal wrote:
Fri Oct 13, 2017 4:48 am
Copy everything to a other host and your site can be back in one hour.

https://www.phpbb.com/support/docs/en/3 ... or-domain/
How can I do that while my site is down?

User avatar
david63
Jr. Extension Validator
Posts: 12974
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post by david63 » Fri Oct 13, 2017 10:13 am

formosan wrote:
Fri Oct 13, 2017 10:11 am
How can I do that while my site is down?
You mean that you do not ftp/control panel/phpMyAdmin access?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email or as they will be ignored

formosan
Registered User
Posts: 32
Joined: Thu Jul 20, 2017 3:20 pm

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Fri Oct 13, 2017 10:17 am

david63 wrote:
Fri Oct 13, 2017 10:13 am
formosan wrote:
Fri Oct 13, 2017 10:11 am
How can I do that while my site is down?
You mean that you do not ftp/control panel/phpMyAdmin access?
I mean my site has been down for four days now..

I have access on the host's site.
Last edited by formosan on Fri Oct 13, 2017 10:19 am, edited 1 time in total.

User avatar
david63
Jr. Extension Validator
Posts: 12974
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post by david63 » Fri Oct 13, 2017 10:19 am

david63 wrote:
Fri Oct 13, 2017 10:13 am
You mean that you do not ftp/control panel/phpMyAdmin access?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email or as they will be ignored

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7046
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post by JimA » Fri Oct 13, 2017 10:45 am

formosan wrote:
Fri Oct 13, 2017 3:03 am
Can someone advise what I need to do to with my hosting panel to bring my site back up again?
While I see your urgency on getting the site back up, I would like to remind you of our six-hour bumping rule. With all of us here being volunteers, we can't be around all the time to answer questions within a few hours. So I'll ask you to be a bit more patient and wait at least six hours before bumping your topic. :)
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

formosan
Registered User
Posts: 32
Joined: Thu Jul 20, 2017 3:20 pm

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Fri Oct 13, 2017 10:52 am

JimA wrote:
Fri Oct 13, 2017 10:45 am
formosan wrote:
Fri Oct 13, 2017 3:03 am
Can someone advise what I need to do to with my hosting panel to bring my site back up again?
While I see your urgency on getting the site back up, I would like to remind you of our six-hour bumping rule. With all of us here being volunteers, we can't be around all the time to answer questions within a few hours. So I'll ask you to be a bit more patient and wait at least six hours before bumping your topic. :)
I was unaware of that and I apogize.

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Crizzo and 29 guests