database error

[hunter22375]

Can anyone tell me what these means or how to fix them?

Invalid SQL:

SELECT text, languageid, special
FROM vb_phrase AS phrase
LEFT JOIN vb_phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
AND varname = 'registeremail' AND languageid IN (-1, 0, 1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 16th 2008 @ 10:15:38 PM
Error Date : Friday, May 16th 2008 @ 10:15:49 PM
Script : http://thesourcecheck.com/forum/regi...p?do=addmember
Referrer : http://thesourcecheck.com/forum/regi...p?do=addmember
IP Address : XX.XX.XX.XX
Username : XXXXXXX
Classname : vB_Database
MySQL Version :

Database error in vBulletin 3.7.0:

Invalid SQL: UPDATE vb_datastore SET data = data - 1, data = IF(data < 0, 0, data) WHERE title = 'mailqueue';MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 16th 2008 @ 10:31:21 PM
Error Date : Friday, May 16th 2008 @ 10:31:36 PMScript : http://www.thesourcecheck.com/forum/index.php
Referrer : http://www.thesourcecheck.com/forum/private.php
IP Address : XX.XX.XXX
Username : XXXXXX
Classname : vB_Database
MySQL Version :

Thanks in advance.

Your MySQL server is timing out.

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[Lynne]

This is a server issue. See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway

[hunter22375]

OK...timing out isn't necessarily a bad thing then? In other words, if you log back in or post something....the timer starts again? Also, will anything be harmed if I don't adjust the time out?

--------------- Added [DATE]1211234469[/DATE] at [TIME]1211234469[/TIME] ---------------

Also, note, everything on my board seems to be working just fine.

[Jase2]

MySQL server has gone away

Have you read the link Lynne gave you?

[Lynne]

Originally Posted by hunter22375

OK...timing out isn't necessarily a bad thing then? In other words, if you log back in or post something....the timer starts again? Also, will anything be harmed if I don't adjust the time out?

Well, I guess it could be considered 'not a bad thing' if you don't mind your users getting errors. Most users though, I would think, would find it frustrating to be on a site and keep getting database errors. And, it has nothing to do with you being logged in or anything. It's a mysql thing.

Originally Posted by hunter22375

OK...timing out isn't necessarily a bad thing then? In other words, if you log back in or post something....the timer starts again? Also, will anything be harmed if I don't adjust the time out?

That's not how it works unfortunately. A timeout means, in this case, that the request sent to your database server didn't get a response in an amount of time specified by your server, so it dropped the query.

In laymans terms, it's like knocking on a door, waiting for someone to answer, and after awhile nobody comes, and then you leave.

[hunter22375]

OK...I understand....I read the link and it said the default time is 8 hrs....how much more should I set the time for then? Also, I have only received 2 of these errors....is it possible the server was just doen during those requests?

[falconKing]

Originally Posted by hunter22375

I have only received 2 of these errors

Lucky you, I receive 40+ different errors (see below e.g.) a day, althu, I have spoken to my host who increased the time period. But the problem remained

PHP Code:

Database error in vBulletin 3.7.0:
Invalid SQL:
                                       UPDATE vb_session
                                       SET lastactivity = 1211229636, location = '/vb/attachment.php?attachmentid=95', inthread = 1955, incalendar = 0, badlocation = 0
                                       WHERE sessionhash = '4043033dca101c8026e4b53fd01c9227';
MySQL Error   : MySQL server has gone away
Error Number  : 2006

Request Date  : Monday, May 19th 2008 @ 09:40:36 PM
Error Date    : Monday, May 19th 2008 @ 09:41:54 PM
Script        : http://xxxxxxxx.com/vb/attachment.php?attachmentid=95
Referrer      :
IP Address    : 66.249.65.244

- Hide quoted text -
Username      : admin
Classname     : vB_Database_MySQLi
MySQL Version : 


It's more likely a resource issue. How busy is your site when you get this error? You're probably just running out of CPU/Memory.

--------------- Added [DATE]1211282339[/DATE] at [TIME]1211282339[/TIME] ---------------

Also, edit the username and IP out of your first post - for security reasons.