Morwyn
12-29-2004, 11:53 AM
I had the following error "only" for my CMPS part of the website (that is only on the portal):
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
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM vb3_thread AS thread
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb3_icon USING (iconid)
LEFT JOIN vb3_attachment AS attachment ON (post.postid = attachment.postid)
LEFT JOIN vb3_user AS user ON (user.userid = post.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON (post.userid = usertextfield.userid)
LEFT JOIN vb3_avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb3_customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN vb3_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
LEFT JOIN vb3_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN(30) 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 28 from table handler
mysql error number: 1030
Date: Wednesday 29th of December 2004 10:59:15 AM
Script: http://www.roleplay-fr.com/
As mentioned on this website:
Error code 28: No space left on device
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.
However why would this concern only the portal and not the forum ? Because of a "partitioning problem" ?
Also, I first ran the run & optimize command in the admin cp, it didn't do anything. However when I closed the forum and ran the command again, the error was not here anymore. So where would that come from ? Is that a simple SQL error but why ? How may I prevent that ?
I just want this not to happen when I'm in a galaxy far far away from the web.
Thanks for your time ;)
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
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM vb3_thread AS thread
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb3_icon USING (iconid)
LEFT JOIN vb3_attachment AS attachment ON (post.postid = attachment.postid)
LEFT JOIN vb3_user AS user ON (user.userid = post.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON (post.userid = usertextfield.userid)
LEFT JOIN vb3_avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb3_customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN vb3_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
LEFT JOIN vb3_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN(30) 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 28 from table handler
mysql error number: 1030
Date: Wednesday 29th of December 2004 10:59:15 AM
Script: http://www.roleplay-fr.com/
As mentioned on this website:
Error code 28: No space left on device
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.
However why would this concern only the portal and not the forum ? Because of a "partitioning problem" ?
Also, I first ran the run & optimize command in the admin cp, it didn't do anything. However when I closed the forum and ran the command again, the error was not here anymore. So where would that come from ? Is that a simple SQL error but why ? How may I prevent that ?
I just want this not to happen when I'm in a galaxy far far away from the web.
Thanks for your time ;)