Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
4 registered (Dj Aero, capnbob, Morgan, id242), 46 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/12/04
Posts: 154
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#181782 - 03/30/07 07:07 PM Why This Message?
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
I am receiving this MySql error message when some of my users are trying to access UBBT:

 Quote:

Script: - Line: Unable to connect to the database! - User maritime@localhost has already more than 'max_user_connections' active connections

Does anybody know why I am sometimes receiving this type of an error message?
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#181783 - 03/30/07 07:57 PM Re: Why This Message? [Re: Daryl Fawcett]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Simply put, more users are connecting to the MySQL server than what the MySQL server allows; the option to increase it is "max_user_connections", however if you're on a shared host you'll have to have your webhost increase it (if they're willing to anyway).

When the limit is hit, it will kill all connections until the timeframe of the limit has passed.

You can find more information on max_user_connections here.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#181785 - 03/30/07 08:46 PM Re: Why This Message? [Re: Gizmo]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
Then, shouldn't it also do it to me as well?
Top
#181789 - 03/30/07 09:17 PM Re: Why This Message? [Re: Daryl Fawcett]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
The limit can be a per minute limit, whereby if you're on after that minute expires, you'll not recieve it... Theres a few error types involved in that mysql module i believe.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#181852 - 03/31/07 09:19 PM Re: Why This Message? [Re: Gizmo]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
I will keep an eye on the MySQL error log in the CP to see how often it happens and who it happens to.
Top
#181853 - 03/31/07 09:36 PM Re: Why This Message? [Re: Daryl Fawcett]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
This message also seems to be showing up with the other message:

 Quote:

Script: /home/virtual/site5/fst/var/www/html/forums/libs/ubbthreads.inc.php - Line: 2067
select
t1.USER_DISPLAY_NAME,t1.USER_PASSWORD,t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t2.USER_TOTAL_PM, t1.USER_ID, t1.USER_IS_BANNED,t1.USER_IS_UNDERAGE, t2.USER_STYLE,t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN
from ubbt_USERS AS t1,
ubbt_USER_PROFILE as t2
where t1.USER_ID = ''
and t1.USER_ID = t2.USER_ID
-

Are these two messages somehow connected?
Top
#181855 - 03/31/07 09:55 PM Re: Why This Message? [Re: Daryl Fawcett]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
I doubt it, the one simply says there was an error with the query, whereas the other was an error with the mysql server going over its limits.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image