Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted June 15, 201311 yr 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">
June 15, 201311 yr Author 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?
June 15, 201311 yr 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.
June 15, 201311 yr Author 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:
June 15, 201311 yr (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
June 15, 201311 yr 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?
June 15, 201311 yr Author 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
June 15, 201311 yr 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.
August 3, 201311 yr Author 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:
August 3, 201311 yr 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.
August 3, 201311 yr Author 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:
Archived
This topic is now archived and is closed to further replies.