database error
 

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

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

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.

MySQL server has gone away

Have you read the link Lynne gave you?

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.

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.

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?

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 :(

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. :)