To try to solve the problem about "too many connections" which happens often these days, I'll today move the database to another server (still at the same hosting provider), for that I will have to lock the site to prevent any changes until end of the process, that may take only few minutes to at most one hour, I hope.

This won't affect unprocessed contributions that are waiting for approval, will it?

No, that's why I lock the site for any change:
- lock
- save the database
- restore the database on the new server
- unlock
if there were changes done between save & restore, they would be lost. But all what was there before I locked it, is saved.

Done.
Those who were connected while the change was done will possibly have to logoff/logon again (in case you do not see contributor/admin links).

still getting the error message so I logged off and now it wont even let me log in. Getting this one now:

Too many connections in /homez.83/imcdb/www/config_connection.php on line 14

I just saw that too... and I wonder why that happens since that server is not supposed to have a limit on the number of connections

I'll upgrade to 256 MB or memory on the server instead of 128 currently, I hope that it will be enough.
Price is not much a problem, Google ads pays for that but if even when paying more it does not work better I do not know what to do except having a server dedicated to imcdb... which I can't administrate myself as I do not have enough knowledge and time.

Done, I do not know if it will work or not. If we still get these errors I should contact the technical support, as it is not normal. But I am afraid that they will say as usual "try to optimize your code", which they say even when it is a problem on their server...

Argh... it is down again. I do not know what to do in the meantime.

And:

http://ubuntuforums.org/showthread.php?t=398027

http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html

Yeah, im also getting the same thing as tonka (and probably various other members too) and unable to login.
Also get "Warning: Cannot modify header information - headers already sent by (output started at /homez.83/imcdb/www/config_connection.php:14) in /homez.83/imcdb/www/user.php on line 72" and the same one again but 73 at the end.

I have to say that the "too many connections error" I see since longer time, however it was never so irritating, like last time (site completly blocked at some hours) - since we have the new contributions system. If the site still won't work and other solutions won't help maybe it will be better to back to the old methods(?) unfortunately...

The server has a much higher limit than before, it does not even use all his memory. The code of the site is the same as it was in December before we started to have problems. I do not see why the server is filled with open connections. I should try to contact tech support I guess.

It is not due to new contributions system. I switched to another database server about at the same time I added the new contributions system, hence why it looks like the two are related

I can't switch to the old system for tong time as soon the database would be too big for it anyway.
So I have to find how to solve this.

The limit is set at 100 connections (on the old server it was 5 or 10...), at some time I was seeing the list of 100 query results staying in the queue for clients which asked these. Now the queue is empty despite the fact that there must be as many people on the site as few hours ago.
So I really think it is not a problem in imcdb but just on the server itself.
I made a small change to use persistent connections (mysql_pconnect instead of mysql_connect) just to see if it helps. But as currently it seems to work I can't know if that change will help in case it fails again

Now it seems to work, I do not know if the problem is solved on the server or if it is the change I made... if you notice that problem again do not hesitate to report it

Hmm still not solved, it fails again
I'll contact them on Monday morning.

Don’t get frustrated, you’ll find a solution, I have faith in you.
(Probably not much comfort coming from a person over a thousand miles across the ocean )

We should break into celebration once the pesky problem is solved.

I really hope You'll solve the problem soon. this site is so nice...!!!

It seems to be working now for me!