Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 01-07-2013, 02:00 PM
Abronsyth's Avatar
Abronsyth Abronsyth is offline
A Headache Embodied
 
Join Date: Aug 2011
Location: NY
Posts: 1,011
Gender: Male
Credits: 114,139
Abronsyth is on a distinguished road
Default Can't get into site?

Quote:
Could not connect to database, the following error has occurred:
SQLSTATE[42000] [1203] User emkaldar_adopts already has more than 'max_user_connections' active connections
Got that error when trying to access my site. I'm not sure if it's not a problem with the host...I honestly just can't understand what it's telling me.
__________________
My Mods Site (1.3.4, 2020 Mods)
Reply With Quote
  #2  
Old 01-07-2013, 03:56 PM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 340,680
Hall of Famer is on a distinguished road
Default

I was wondering though, do you just happen to get this error today? How long does it persist? It appears that your site has too many concurrent mysql connections at the same time, usually this shouldnt be a problem as the connections are automatically closed after a while. Try again later and see if this problem still wont go away. In this case, you may have to define some mysql settings as specified here:
http://dev.mysql.com/doc/refman/5.0/...resources.html

Another way is to contact your host and kill all processes on your site so all those connections are gone. It will make your site work for now, but not sure if it will come back some time later. There's a chance that your server aint getting rid of old connections properly.
__________________


Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site.
Reply With Quote
  #3  
Old 01-08-2013, 07:08 AM
Abronsyth's Avatar
Abronsyth Abronsyth is offline
A Headache Embodied
 
Join Date: Aug 2011
Location: NY
Posts: 1,011
Gender: Male
Credits: 114,139
Abronsyth is on a distinguished road
Default

Well, it's working fine now...first time that's ever happened...I will be upgrading my site/hosting plan, so maybe that can help to make sure it doesn't happen again...
__________________
My Mods Site (1.3.4, 2020 Mods)
Reply With Quote
  #4  
Old 01-08-2013, 01:56 PM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 340,680
Hall of Famer is on a distinguished road
Default

Quote:
Originally Posted by Iris-spider View Post
Well, it's working fine now...first time that's ever happened...I will be upgrading my site/hosting plan, so maybe that can help to make sure it doesn't happen again...
I am not sure if this does have anything to do with hosting plan, more like server misconfiguration if you ask me. The server aint killing off unneeded database connection properly.
__________________


Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 03:54 PM.

Currently Active Users: 9640 (0 members and 9640 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636