Forum Album crashing the forum?

محروم.كوم · #1 03-17-2010, 11:50 AM

I just tried to load my test installation of VB4 (the suite), and when I try to go to the forum homepage it crashes and I get this in my e-mail:
Code:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT albumpicture.*, album.*, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb4_2_attachment AS albumpicture
LEFT JOIN vb4_2_album AS album ON(album.albumid = albumpicture.contentid)
LEFT JOIN vb4_2_user AS user ON(user.userid = album.userid)
WHERE album.state = 'public' and albumpicture.contenttypeid = 8
ORDER BY rand(NOW()) DESC LIMIT 0, 5;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Wednesday, March 17th 2010 @ 1244 AM
Error Date : Wednesday, March 17th 2010 @ 1244 AM
Script : http://test.mydomain.com/forum.php
Referrer : http://www.mydomain.com/
IP Address : 180.5.25.22
Username : Webbstre
Classname : vB_Database
MySQL Version : 5.1.39-log
I'm not sure what to do about this. I haven't done any changes in several days, and I know for a fact that it loaded just fine yesterday. The CMS page loads fine, as does my installation of DownloadsII and VaultWiki, but the Forum and Blogs pages crash. I notice in the top one it mostly appears to mention album stuff. Here is the error message for the blog:

Code:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT blog.blogid, user.username, blogtextid, blog.title, blog_text.dateline, blog_text.pagetext, user.*, blog_user.title AS blogtitle, blog_text.title AS commenttitle,
blog_text.state,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid, options_ignore, options_buddy, options_member, options_guest
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight

FROM vb4_2_blog_text AS blog_text
LEFT JOIN vb4_2_blog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN vb4_2_user AS user ON (user.userid = blog_text.userid)
LEFT JOIN vb4_2_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)

LEFT JOIN vb4_2_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb4_2_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE blog.state IN('visible', 'moderation')
AND blog.dateline = 1268205682
ORDER BY blog_text.dateline DESC
LIMIT 10;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Wednesday, March 17th 2010 @ 1222 AM
Error Date : Wednesday, March 17th 2010 @ 1224 AM
Script : http://test.mydomain.com/blog.php
Referrer : http://www.mydomain.com/
IP Address : 180.5.25.22
Username : Webbstre
Classname : vB_Database
MySQL Version : 5.1.39-log
Any help?

Update: It happens when I go to my profile too, but not the admin panel.
Code:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

FROM vb4_2_userlist AS userlist
INNER JOIN vb4_2_user AS user ON (user.userid = userlist.relationid)
LEFT JOIN vb4_2_avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb4_2_customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 1
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'

ORDER BY RAND()
LIMIT 0, 1;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Wednesday, March 17th 2010 @ 1203 AM
Error Date : Wednesday, March 17th 2010 @ 1204 AM
Script : http://test.mydomain.com/member.php/1-Webbstre
Referrer : http://test.mydomain.com/search.php?do=getnew&contenttype=vBForum_Post
IP Address : 180.5.25.22
Username : Webbstre
Classname : vB_Database
MySQL Version : 5.1.39-log __DEFINE_LIKE_SHARE__