PDA

View Full Version : database error


wolfyman
05-24-2005, 09:29 PM
I get a few erors a day from vbulletin, but I have no idea what they are from. Usually they say this:


Database error in vBulletin :

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

mysql error number: 0



But today I got a different one, what's this mean?


Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT filename, attachment.postid, attachment.userid, attachmentid,
attachment.dateline, SUBSTRING(filedata, 1, 2097152) AS filedata, filesize,
attachment.visible, mimetype, NOT ISNULL(deletionlog.primaryid) AS isdeleted,
thread.forumid, forum.password, thread.threadid
FROM attachment AS attachment
LEFT JOIN attachmenttype AS attachmenttype ON(attachmenttype.extension = SUBSTRING_INDEX(attachment.filename, '.', -1))
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
WHERE attachmentid = 410

mysql error: MySQL server has gone away

mysql error number: 2006



MYSQL server has gone away?!! Any ideas?

vBintense
05-24-2005, 09:47 PM
It means your mysql server is erroring out, if you own your own server you should config your mysql , if not contact your host.

Paul M
05-24-2005, 10:32 PM
Well I've never seen that one before - someone had a sense of humour when they wrote that error ......

N8
05-24-2005, 10:37 PM
That error is usually nothing to worry about.

I get that error all of the time when my host re-boots the server, and people are trying to access a page while the server is just starting up.

Your board is still working now, right?

wolfyman
05-25-2005, 12:26 AM
yeah, it's working.
I get a few a day though, so I figured I'd holler and see if anybody knew anything.

Marco van Herwaarden
05-25-2005, 04:29 AM
Your server can't handle the requests. I suggest you post at the Server Configuration forum at vbulletin.com