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

General Error SQL ERROR [ mysqli ]

Post by formosan » Wed Oct 11, 2017 12:02 am

I talked to the host and they told me the problem was on the phpbb side

User avatar
Elias
Registered User
Posts: 4514
Joined: Sat Feb 25, 2006 4:31 pm
Location: In the Water!
Name: Elias
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post by Elias » Wed Oct 11, 2017 12:11 am

I would suggest asking your host because either the database server or the connection to it has a problem, or if they have changed the connection info for the database.

Thanks
"Mystery creates wonder, and wonder is the basis of man's desire to understand." - Neil Armstrong
|Installing Extensions|Writing Extensions|Extension Validation Policy|

User avatar
3Di
Registered User
Posts: 11810
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post by 3Di » Wed Oct 11, 2017 12:23 am

Elias wrote:
Wed Oct 11, 2017 12:11 am
I would suggest asking your host because either the database server or the connection to it has a problem, or if they have changed the connection info for the database.

Thanks
formosan wrote:
Wed Oct 11, 2017 12:02 am
I talked to the host ...
Sometime Hosters aren't so good, uh? :)

@OP

What about the rest of the error message?
That's not enough to work with.
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades

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

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Wed Oct 11, 2017 12:52 am

Too many scripts or plug ins making open connections is what the host told me.

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

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Wed Oct 11, 2017 9:46 am

It's still down.

Code: Select all

General Error

SQL ERROR [ mysqli ]

User theblvb2_blue already has more than 'max_user_connections' active connections [1203]

BACKTRACE


FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 110
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/cache/container_dotslash.php
LINE: 1224
CALL: phpbb\db\driver\mysqli->sql_connect()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php
LINE: 331
CALL: phpbb_cache_container->getDbal_Conn_DriverService()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 465
CALL: Symfony\Component\DependencyInjection\Container->get()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 52
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\factory->get_driver()

FILE: [ROOT]/phpbb/config/db.php
LINE: 57
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/cache/container_dotslash.php
LINE: 578
CALL: phpbb\config\db->__construct()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php
LINE: 331
CALL: phpbb_cache_container->getConfigService()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 465
CALL: Symfony\Component\DependencyInjection\Container->get()

FILE: [ROOT]/cache/container_dotslash.php
LINE: 482
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php
LINE: 331
CALL: phpbb_cache_container->getCacheService()

FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 465
CALL: Symfony\Component\DependencyInjection\Container->get()

FILE: [ROOT]/includes/compatibility_globals.php
LINE: 22
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()

FILE: [ROOT]/common.php
LINE: 103
CALL: require('[ROOT]/includes/compatibility_globals.php')

FILE: [ROOT]/index.php
LINE: 23
CALL: include('[ROOT]/common.php')
Last edited by Mick on Wed Oct 11, 2017 11:11 am, edited 1 time in total.
Reason: Added code tags for readability

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7044
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 » Wed Oct 11, 2017 9:50 am

You can look at this from two ways. On the one hand, your host is telling you that phpBB is making too many connections to the database, while on the other hand the host is the one who sets the limit for the max amount of connections a script can make. ;)

So if you're consistently going over this limit (is your board very busy and very regularly visited?) you should ask the host to increase this limit or look for another host, I'm afraid.
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 » Wed Oct 11, 2017 10:05 am

JimA wrote:
Wed Oct 11, 2017 9:50 am
You can look at this from two ways. On the one hand, your host is telling you that phpBB is making too many connections to the database, while on the other hand the host is the one who sets the limit for the max amount of connections a script can make. ;)

So if you're consistently going over this limit (is your board very busy and very regularly visited?) you should ask the host to increase this limit or look for another host, I'm afraid.
It never happened until yesterday.

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

Re: General Error SQL ERROR [ mysqli ]

Post by janus_zonstraal » Wed Oct 11, 2017 10:09 am

Did you ask your host what the max_user_connections is?

Than we can compare.
Sorry! My English is bat ;) !!!

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

Re: General Error SQL ERROR [ mysqli ]

Post by david63 » Wed Oct 11, 2017 10:20 am

formosan wrote:
Wed Oct 11, 2017 10:05 am
It never happened until yesterday.
So what happened/changed yesterday to cause this to occur?
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 » Wed Oct 11, 2017 12:37 pm

janus_zonstraal wrote:
Wed Oct 11, 2017 10:09 am
Did you ask your host what the max_user_connections is?

Than we can compare.
I think they said fifteen.

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

Re: General Error SQL ERROR [ mysqli ]

Post by formosan » Wed Oct 11, 2017 2:31 pm

david63 wrote:
Wed Oct 11, 2017 10:20 am
formosan wrote:
Wed Oct 11, 2017 10:05 am
It never happened until yesterday.
So what happened/changed yesterday to cause this to occur?
It was fine yeaterday morning.

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

Re: General Error SQL ERROR [ mysqli ]

Post by janus_zonstraal » Wed Oct 11, 2017 2:51 pm

Or your host changes something or you have more visitors.

15 connections is very low, so ask your host to set it higher or find a other host.
Sorry! My English is bat ;) !!!

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 12:27 am

The error message itself says it's powered by phpbb, but nobody from phpbb will tell me what exactly the problem is..

What are the max user connections?

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 3:22 am

formosan wrote:
Wed Oct 11, 2017 12:37 pm
janus_zonstraal wrote:
Wed Oct 11, 2017 10:09 am
Did you ask your host what the max_user_connections is?

Than we can compare.
I think they said fifteen.
That number was wrong....there is no limit..

The error is from this side and after sending emails and posting, I still couldn't get an answer as to why this happened..

I have upgraded with my host so hopefully that does the trick.

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

Re: General Error SQL ERROR [ mysqli ]

Post by janus_zonstraal » Thu Oct 12, 2017 6:45 am

formosan wrote:
Thu Oct 12, 2017 12:27 am
The error message itself says it's powered by phpbb, but nobody from phpbb will tell me what exactly the problem is..

What are the max user connections?

A Google search on "phpbb user connection " gives phpbb max user connections
Al the answers are pointing to the host.

Unlimited users connections are very unusual.

Please forgive us that we can't give you a direct answer.
Sorry! My English is bat ;) !!!

Post Reply

Return to “[3.2.x] Support Forum”