too many connections?

[nicklfire]

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.

[snakes1100]

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.

[nicklfire]

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.php?do=postreply&t=10364
Referrer : http://bcaquaria.com/forum/showthread.php?t=10364
IP Address : 24.66.56.180
Username : Shawns
Classname : vb_database

[snakes1100]

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

[geevest.com]

snakes1100 : how to repair the duplicate key table ? thx

[Marco van Herwaarden]

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

[CarlitoBrigante]

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.

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

[geevest.com]

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

[Paul M]

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.