MyBB 1.6 Officially Released!
Latest Releases: [For 1.6] Custom Pages - Valid Referrals - Bonus
Thread Rating:
- 0 Votes - 0 Average
- 1
- 2
- 3
- 4
- 5
|
[SOLVED] SQL max users
|
| Author |
Message |
Dead Soulâ„¢
Member
Posts: 105
Joined: Mar 2010
Reputation: 0
MyBux: 162
|
[SOLVED] SQL max users
How do I edit max users for my MyBB forum..
I often get a SQL error with Max users..
|
|
| 05-20-2010 04:17 AM |
|
ByteHunter
Community builder
Posts: 1,362
Joined: Dec 2008
Reputation: 17
MyBux: 1874
|
RE: SQL max users
How many users do you have?
|
|
| 05-20-2010 04:33 AM |
|
Dead Soulâ„¢
Member
Posts: 105
Joined: Mar 2010
Reputation: 0
MyBux: 162
|
RE: SQL max users
I have 500 members... And about 8-10 online when it happens..
|
|
| 05-20-2010 04:37 AM |
|
coder
Member
Posts: 77
Joined: Apr 2010
Reputation: 0
MyBux: 4
|
RE: SQL max users
Contact your host.
|
|
| 05-20-2010 07:35 AM |
|
Dead Soulâ„¢
Member
Posts: 105
Joined: Mar 2010
Reputation: 0
MyBux: 162
|
RE: SQL max users
So it is the host that are chosing this or what?
|
|
| 05-20-2010 02:43 PM |
|
Andraž Rihtar
Support Team
Posts: 1,906
Joined: Aug 2009
Reputation: 8
MyBux: 1265
|
RE: SQL max users
(05-20-2010 02:43 PM)Dead Soulâ„¢ Wrote: So it is the host that are chosing this or what?
Yes. Specially when you're at a free host
Svizy - MyBBSource Support Team
|
|
| 05-20-2010 04:56 PM |
|
Dead Soulâ„¢
Member
Posts: 105
Joined: Mar 2010
Reputation: 0
MyBux: 162
|
RE: SQL max users
I got a paid host from hosting24.com.
This is what is saying..
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1203 - User user785_mybb already has more than 'max_user_connections' active connections
Query:
[READ] Unable to connect to MySQL server
(This post was last modified: 05-20-2010 09:23 PM by Dead Soulâ„¢.)
|
|
| 05-20-2010 09:18 PM |
|
Dead Soulâ„¢
Member
Posts: 105
Joined: Mar 2010
Reputation: 0
MyBux: 162
|
RE: SQL max users
I have contacted the supporters..
They said this:
Quote:If you get 'User XXX already has more than max_user_connections active connections' or similar error message, it means your script is not optimized and makes too many connections.
You may want to run mysql_reconnect command before each query in this case. Also add command mysql_close()at the end of your script to close all open connection.
|
|
| 05-20-2010 10:23 PM |
|
Andraž Rihtar
Support Team
Posts: 1,906
Joined: Aug 2009
Reputation: 8
MyBux: 1265
|
RE: SQL max users
I believe that you have a bad host, because I've never had this issue on any paid OR free host for that matter. I suggest you to find a better host or "suffer" the conciquences
Note that I might be wrong
Svizy - MyBBSource Support Team
|
|
| 05-20-2010 10:45 PM |
|
Dead Soulâ„¢
Member
Posts: 105
Joined: Mar 2010
Reputation: 0
MyBux: 162
|
RE: SQL max users
Okay.
So it is good that I have 2 reseller host at 2 difference hosting sites..
|
|
| 05-20-2010 11:42 PM |
|