DarknessDivine
11-30-2004, 09:40 AM
I had 4 db errors overnight and I don't know what they mean, thought I'd post one for ya to look at.
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN(10,25) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
GROUP BY post.postid
ORDER BY postdateline DESC
LIMIT 7
mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Tuesday 30th of November 2004 04:27:12 AM
Script: http://epettalk.com/
Referer: http://www.istarthere.com
Username: Unregistered
IP Address: 24.138.46.134
Also have an error-28 in my other db error emails..another one of the errors from referer came from theadminzone and then the other 2 had no referers..
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN(10,25) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
GROUP BY post.postid
ORDER BY postdateline DESC
LIMIT 7
mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Tuesday 30th of November 2004 04:27:12 AM
Script: http://epettalk.com/
Referer: http://www.istarthere.com
Username: Unregistered
IP Address: 24.138.46.134
Also have an error-28 in my other db error emails..another one of the errors from referer came from theadminzone and then the other 2 had no referers..