New sql error

[m_m_123 0]

Hi to all members and moderators in forum,

in my site:

When there are too many online members..

i see this sql error in my site:

max_user_connection

please help me to fix this error

[Torquemada 0]

Sir, there's a problem with your hoster, who've set restrictions to the max_user_connection in sql ini file. Ask him to change the number of max user connections, so it'll be possible to establish more concurrent connections.

[m_m_123 0]

thanks, i will ask to my hosting

[m_m_123 0]

Hi, my hosting ask me your system on your site is made this problem

I went to cpanel, but I can`t find max_users_connection , please help me to find it

[sorry for bad English]

[Torquemada 0]

I dunno, how d'your hosting work, so i'll tell it in common. You or your hoster have mysql configuration file (by default it's called my.ini). Look in it for the string described above in way something like "The maximum amount of concurrent sessions the MySQL server will allow". I dunno was it named so in mysql 4.x, in my MySQL 5.0.41 this string looks like:

# The maximum amount of concurrent sessions the MySQL server will

# allow. One of these connections will be reserved for a user with

# SUPER privileges to allow the administrator to login even if the

# connection limit has been reached.

max_connections=100

So, strings following the "#" sign are the desctription of the max_connections option. You have to set this option to something like I have, e.g. 100.

[lifestar 18]

You have to set this option to something like I have, e.g. 100.

I think this option is not available for the client host.

[Torquemada 0]

If it's unavailable and hoster says that is not their problem, it'll be mostly unsolvable problem Well, let's start from here: m m 123, how many users visit your site each day?