Sql Connection Error.

[Corriewf]

Ok I am not going to post the error message right now cause im at work and cant access my home email ( sad but true). The problem I seem to be getting is that the sql database is losing connection for vbchat. All the error message says is "connection failed".

I beleive what is happening is that my members "guilt here too" are joining the chat via whos online. When this occurs no pop up box is made and it opens the chat in the same window whos online was in.

This is not a huge problem, but any info anyone can provide would be appreciated.

[Corriewf]

Bump.

[Marco van Herwaarden]

You would really have to post the error message in order to get a reply i think.

[Corriewf]

Pretty generic error. :(

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Wednesday 04th of May 2005 11:47:07 AM
Script: http://www.saltcreep.com/forums/vBChat.php?&do=chatFrame
Referer: http://www.saltcreep.com/forums/vBChat.php?&do=main&nojoin=1
IP Address:

[Marco van Herwaarden]

If you only get this error occasionally it would mean that your server gets overloaded.

Could you try running the following query while you are getting this problem. (do it in SSH or phpMyAdmin.
SHOW FULL PROCESSLIST;

[Corriewf]

Wow! God I hope not as there are normally onyl 6 or so users on at a time :P

However in my efforts to replicate the error I beleive when I go to whos online and see someone in chat and click the link to join while in whos online, I get the error in my email...

Thank you for the query though as it will come in handy. :)

[Corriewf]

I really think this may a bug ZT.

[Marco van Herwaarden]

You already have output from that query?

[Corriewf]

No what im saying is that normally a user clicks o the navbar and it opens the chat in an seperate window, which script runs to show whos online ect, well when viewing whos online if some sees another person in chat and then clicks on the link there is opens chat in that same window. I beleive when that happens the proper script is not being ran so its causing sql errors.

[Corriewf]

Bumpy bump bump bumpy ZT

[Marco van Herwaarden]

I really suggest you try to run the query i suggested at a time that this is happening again, and post teh output here.

[Corriewf]

Yeah the problem is that it normally happens while im at work and I cant check my email until I get home... That will be hard to do.