Post by Vkms » Wed Dec 16, 2020 3:33 am

Hello i am running an oc 2.3.0.2 installattion with journal theme and i keep getting the following warnings and errors in my error_log file:

PHP Warning: mysqli::__construct(): (XXXXXXXX): User 'XXXXXXX' has exceeded the 'max_user_connections' resource (current value: 30) in /home/XXXXXXX/public_html/system/library/db/mysqli.php on line 7
PHP Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/XXXXXXX/public_html/system/library/db/mysqli.php on line 10
PHP Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/XXXXXXX/public_html/system/library/db/mysqli.php on line 10
PHP Fatal error: Uncaught Exception: Error: <br />Error No: in /home/XXXXXXX/public_html/system/library/db/mysqli.php:10
Stack trace:
#0 /home/XXXXXXX/public_html/system/storage/modification/system/library/db.php(13): DB\MySQLi->__construct('localhost', 'XXXXXXX', 'XXXXXXX', 'XXXXXXX', 'XXXXXXX')
#1 /home/XXXXXXX/public_html/system/framework.php(36): DB->__construct('mysqli', 'localhost', XXXXXXX', 'XXXXXXX', 'XXXXXXX', 'XXXXXXX')
#2 /home/XXXXXXX/public_html/system/startup.php(124): require_once('/home/XXXXXXX/...')
#3 /home/XXXXXXX/public_html/index.php(19): start('catalog')

Can you please spare a thought on what can i do to resolve this?
Last edited by Vkms on Wed Dec 16, 2020 3:56 am, edited 1 time in total.

Newbie

Posts

Joined
Wed Jul 10, 2019 3:15 pm

Post by EvolveWebHosting » Wed Dec 16, 2020 3:44 am

Start by contacting your hosting company to find out how many connections you're using and if they can increase it any. My first guess is that you have an extension that isn't properly closing out DB connections which is causing you to see this error. If you've recently installed something new, try disabling it and see if your website loads again.

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhosting.com


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA

Post by Vkms » Wed Dec 16, 2020 4:01 am

EvolveWebHosting wrote:
Wed Dec 16, 2020 3:44 am
Start by contacting your hosting company to find out how many connections you're using and if they can increase it any. My first guess is that you have an extension that isn't properly closing out DB connections which is causing you to see this error. If you've recently installed something new, try disabling it and see if your website loads again.
Thank you for the reply!
I've already sent a message to my hosting provider to increase, if possible, the number of connections. However i made a quick check for the modules i installed the past weeks. It turns out that the day after i installed a certain module, the messages appeared. I will send a mail to the programmer to check if this module is causing the issue.
Thanks again for your help!!!

Newbie

Posts

Joined
Wed Jul 10, 2019 3:15 pm

Post by EvolveWebHosting » Wed Dec 16, 2020 6:04 am

Vkms wrote:
Wed Dec 16, 2020 4:01 am
EvolveWebHosting wrote:
Wed Dec 16, 2020 3:44 am
Start by contacting your hosting company to find out how many connections you're using and if they can increase it any. My first guess is that you have an extension that isn't properly closing out DB connections which is causing you to see this error. If you've recently installed something new, try disabling it and see if your website loads again.
Thank you for the reply!
I've already sent a message to my hosting provider to increase, if possible, the number of connections. However i made a quick check for the modules i installed the past weeks. It turns out that the day after i installed a certain module, the messages appeared. I will send a mail to the programmer to check if this module is causing the issue.
Thanks again for your help!!!
You're welcome and glad you've been able to narrow down what is causing the issue. Good luck!

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhosting.com


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA
Who is online

Users browsing this forum: No registered users and 3 guests