The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Do a repair on the table in question that the duplicate key is coming from.
|
#5
|
|||
|
|||
snakes1100 : how to repair the duplicate key table ? thx
|
#6
|
|||
|
|||
AdminCP -> Maintenance -> Repair / Optimize Tables -> Fix Unique Indexes
|
#7
|
||||
|
||||
This is especially true in a lot of CPanel servers I had to work with recently.
|
#8
|
|||
|
|||
maybe i must try this to fixed my problem : Fix Unique Indexes
|
#9
|
||||
|
||||
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.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|