Service Temporarily Unavailable

[icyman]

Randomly i take this message, everyday, everytime, in all section off the forum, why?

the host company says all ok from them, ipb 3.4.2 :mellow:

" alt="2du9zxj.jpg">

[icyman]

SQL Error Logs

sql_error_log_06_14_13.cgi

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 14 Jun 2013 06:43:00 +0000 Error: 1203 - User xxxxxx already has more than 'max_user_connections' active connections IP Address: xx.xx.xx.xx - / ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I see this message in Logs, what i can do? the problem is from this error log?

[tAPir]

Your host company is lying.

[Makoto]

Or they just aren't catching your forum when its actually offline.

The error means your hosts maximum allowed MySQL connections is being exceeded.

You should forward that information to your web host if you have not already.

[icyman]

i send them too many times tickets but nothing.

web host: hosting24.com

the last message from them:

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 to the database (or your website is very active, has many users online at the same time).

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 connections.

I will be pleased to answer any additional questions you may have.

:mellow:

[Dmacleo]

(or your website is very active, has many users online at the same time

there you go.

they cannot handle it.

move hosts, seriously with the price of a vps its worth just managing your own

[Makoto]

Hosting24 is one of the only shared hosts I've used, and that was several years ago. I don't know how much has changed since, but they were a good provider when I used them.

Their response to you was good and detailed, how many active users does your forum usually have during peak hours?

[icyman]

no i havent got active users, 20-30 active users, i think to change host, i can t find the problem in script . thanks for help

[MathewC]

no i havent got active users, 20-30 active users, i think to change host, i can t find the problem in script . thanks for help

If your host can't handle 20-30 active users you seriously need to leave them.

[icyman]

From hosting company:

This is not related to your visitor count. This is regarding the number of MySQL connections your MySQL user has.

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 connections.

Thank you for the inquiry and good luck.

?

now? :hmm:

[Makoto]

Can you ask them what the maximum number of MySQL connections they allow is?

Do you have any third party hooks/applications on your forum? What are they if so? Try disabling some of your hooks if you are and see if the issues go away.

Shoutbox hooks can really hammer your limitations on a shared host, for example.

[icyman]

Can you ask them what the maximum number of MySQL connections they allow is?

i m waiting answer from host

Do you have any third party hooks/applications on your forum? What are they if so? Try disabling some of your hooks if you are and see if the issues go away.

yes i have , i ll try with no hooks - yes i have and shutbox

thanks for answer Kirito :smile: