getting mysql connection errors....any ideas?

[risestar]

any ideas on what this error means and how to fix? thanks

-------------

Database error in vBulletin: Invalid SQL: UPDATE thread SET
views=views+1 WHERE threadid=23875
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Wednesday 13th of September 2000 09:06:56 PM
Script: /forum/showthread.php?threadid=23875
Referer: [url]http://www.dsschat.com/forum/forumdisplay.php?forumid=21[/url]

[George L]

yeah i got these today as well

[quote]
Database error in vBulletin: Invalid SQL: SELECT threadid FROM thread WHERE lastpost>969325104 AND forumid=3 AND visible=1 ORDER BY lastpost LIMIT 1
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Monday 18th of September 2000 07:59:50 PM
Script: /forums/showthread.php?threadid=2886
Referer: [url]http://www.animeboards.com/forums/forumdisplay.php?forumid=3[/url] [/quote]
and
[quote]
Database error in vBulletin: Invalid SQL: SELECT COUNT(thread.threadid) AS threads FROM thread WHERE thread.visible=1 AND thread.forumid=3 AND lastpost >= 946861188
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Monday 18th of September 2000 07:59:50 PM
Script: /forums/forumdisplay.php?forumid=3
Referer:
[/quote] ?

[JimF]

I think the answer is in your question:

[quote]mysql error: Lost connection to MySQL server during query[/quote]

I think the error is trying to tell you that it lost the connection to the mysql server during the query.

-jim

;)

[George L]

would this be related to the max connection time = 30 in the mysql variables ?

[Bone Head]

I have the same error.

Our board isnt that busy but for some reason it has just started throwing up this error and also getting errors on th page when you try to view a thread.

My host has increased the number of connections to the database but it hasnt helped any :(

[Bone Head]

Sorry ignore me its not the same error, here is mine, I also get an error in the browser which I havent copied yet :

Database error in vBulletin: Invalid SQL: SELECT sessionid FROM session WHERE ipaddress='205.160.50.72'
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Wednesday 27th of September 2000 10:01:12 AM
Script: /commscentre/index.php
Referer:

-----------------------

Any Ideas?

[risestar]

Dont know what caused it, but apparently the mysql client began shutting itself off.

I cleared out all the session and all the non-essential tables from the other mysql apps and re-installed the mysql and all seems ok.

Weird. Hope it does not happen again though :)

[Bone Head]

I wish I had access like that to the database on our site but its a shared machine so I guess I cant. However I do have access to our tables etc and I cant see anything wrong in there.