https://www.machform.com/forums/ MachForm Community Forums Topic: SQL too many connections error when trying to load forms en Sun, 03 May 2026 20:38:22 +0000 https://www.machform.com/forums/topic/sql-too-many-connections-error-when-trying-to-load-forms#post-16106 Mon, 01 Oct 2012 18:20:15 +0000 yuniar 16106@https://www.machform.com/forums/ <p>Hi Sean,</p> <p>I'm afraid not much we can do from the script side if the error message is "SQLSTATE[HY000] [1040] Too many connections", since this is an issue with the MySQL server.</p> <p>As your hosting tech support said "you may be hitting the maximum concurrent connections due to traffic volume.", either by your site or another site which is located on the same server. You might want to ask your hosting tech support to migrate your database to another server or upgrading to their higher plan. </p> https://www.machform.com/forums/topic/sql-too-many-connections-error-when-trying-to-load-forms#post-16105 Mon, 01 Oct 2012 18:19:23 +0000 yuniar 16105@https://www.machform.com/forums/ <p>Hi Sean,</p> <p>I'm afraid not much we can do from the script side if the error message is "SQLSTATE[HY000] [1040] Too many connections", since this is an issue with the MySQL server.</p> <p>As your hosting tech support said "you may be hitting the maximum concurrent connections due to traffic volume.", either by your site or another site which is located on the same server. You might want to ask your hosting tech support to migrate your database to another server or upgrading to their higher plan. </p> https://www.machform.com/forums/topic/sql-too-many-connections-error-when-trying-to-load-forms#post-16101 Mon, 01 Oct 2012 03:18:36 +0000 seangritzman 16101@https://www.machform.com/forums/ <p>Also getting this error as well:</p> <p>500: Internal server error<br /> This error is generated when a script running on the server could not be implemented or permissions are incorrectly assigned for files or directories<br /> Troubleshooting suggestions:<br /> Temporarily disable any rewrite rules by renaming your .htaccess file if it exists.<br /> Ensure that any CGI or Perl scripts have at least .755. permissions.<br /> If trying to run PHP and you get this error, you may have an invalid php.ini in your /cgi-bin, or may be missing your php.dat file in this folder. </p> https://www.machform.com/forums/topic/sql-too-many-connections-error-when-trying-to-load-forms#post-16100 Mon, 01 Oct 2012 02:38:30 +0000 seangritzman 16100@https://www.machform.com/forums/ <p>yuniar... these are the messages we are getting when trying to use any of our registration forms:</p> <p>Error connecting to the database: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '(took out ip address)' (4)</p> <p>Error connecting to the database: SQLSTATE[HY000] [1040] Too many connections</p> <p>My hosting provider is Network Solutions and in the past we have never had a problem and unfortunately this is the critical time of the year for this to be working. We have been up and down for the past 6 days with no solution in sight.</p> <p>Do you by chance have any thoughts which might help? If not with your product then maybe something I can ask of my provider? </p> https://www.machform.com/forums/topic/sql-too-many-connections-error-when-trying-to-load-forms#post-16039 Wed, 26 Sep 2012 17:01:31 +0000 yuniar 16039@https://www.machform.com/forums/ <p>MachForm doesn't use any persistent connections, so there is no need to modify any code. Are you on a shared hosting or a dedicated server?</p> <p>If you are on a shared hosting, most likely you are having a spike of traffic, try to check into your website statistic. If you don't find any increased traffic, then most likely there are other users within the same server is using too many connections to the database, hence eating up the allocation on the server. </p> https://www.machform.com/forums/topic/sql-too-many-connections-error-when-trying-to-load-forms#post-16022 Tue, 25 Sep 2012 20:33:33 +0000 seangritzman 16022@https://www.machform.com/forums/ <p>We noticed over a two day time period an error stating "too many connections" when trying to load a form. I wish I would have captured the full message however I did not. I contacted my hosting provider and they responded with the below message. Is there something we need to do in order to prevent this from happening again? An example of one of our forms can be found here: <a href="http://www.topflightvbc.com/registration/regformtryouts.php" rel="nofollow">http://www.topflightvbc.com/registration/regformtryouts.php</a></p> <p>********************<br /> The error you are experiencing with your database is due to too many active connections to your MySQL database. If you are using mysql_pconnect(), this type of connection never closes. It is a persistent connection that stays open for later use. This can easily cause you to have too many active connections depending on how many people visit the website. I suggest you change it to mysql_connect() instead if you are using this. If you are using mysql_connect(), you may not be closing the database connection at the end of a query, please check that all connections are closed after use. Otherwise, you may be hitting the maximum concurrent connections due to traffic volume.<br /> ********************* </p>