too many connections?
 

Hey guys,

Getting the following error on my vbulletin

Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/ftp/xxxxxxx/html/common/db.php on line 28
Error connecting to server: Too many connections

This is the first time i've seen this error happen.

Forum is located at bcaquaria.com

any help would be apprecaited.

1st, post the entire db error message.

2nd, from what you posted, the max_connections limit is set to low in my.cnf, increase the limit and restart mysql/apache.

well got my site back up, now when i try to post a new thread i'm getting ...

Database error in vBulletin 3.6.2:

Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
(1, 1, 'Nicklfire', 831, 'Re: Server Outage This Morning', 'testttttt', 0, 1, 0, 10364, 1213315564, '24.66.56.132', 0);

MySQL Error : Duplicate entry '98644' for key 1
Error Number : 1062
Date : Thursday, June 12th 2008 @ 05:06:04 PM
Script : http://bcaquaria.com/forum/newreply....treply&t=10364
Referrer : http://bcaquaria.com/forum/showthread.php?t=10364
IP Address : 24.66.56.180
Username : Shawns
Classname : vb_database

Do a repair on the table in question that the duplicate key is coming from.

snakes1100 : how to repair the duplicate key table ? thx

AdminCP -> Maintenance -> Repair / Optimize Tables -> Fix Unique Indexes

This is especially true in a lot of CPanel servers I had to work with recently.

maybe i must try this to fixed my problem : Fix Unique Indexes

Just repairing the table will normally fix duplicate key issues, no need to use the other option as that rebuilds all indexes, a bit of overkill in most cases.