Database error in vBulletin 4.0.0 Beta 3:

Invalid SQL:
SELECT SUM(filesize) AS size FROM attachment;

MySQL Error : Unknown column 'filesize' in 'field list'
Error Number : 1054
Request Date : Sunday, August 8th 2010 @ 10:47:49 PM
Error Date : Sunday, August 8th 2010 @ 10:47:49 PM
Script : http://www. xxxxxxx .com/frm/admincp/index.php?do=home
Referrer : http://www. xxxxxxx .com/frm/admincp/index.php?do=nav

Database error in vBulletin 4.0.0 Beta 3:

Invalid SQL:

SELECT user.username, post.username AS postusername, attachment.filename, attachment.postid, thread.forumid, thread.threadid, attachment.thumbnail_dateline,
attachment.attachmentid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize, attachment.filesize, attachment.dateline
FROM attachment AS attachment
LEFT JOIN post AS post ON (attachment.postid = post.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN user AS user ON (attachment.userid = user.userid)
WHERE thread.forumid IN(562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 615, 616, 617, 618, 619, 620, 630, 621, 622, 623, 624, 625, 626, 627, 628, 629) AND attachment.visible = 0 AND attachment.postid <> 0;

MySQL Error : Unknown column 'thumbnail_filesize' in 'field list'
Error Number : 1054
Request Date : Sunday, August 8th 2010 @ 10:53:20 PM
Error Date : Sunday, August 8th 2010 @ 10:53:20 PM
Script : http://www. xxxx .com/frm/modcp/moderate.php?do=attachments
Referrer : http://www. xxx .com/frm/admincp/index.php?do=nav

Database error in vBulletin 4.0.0 Beta 3:

Invalid SQL:

SELECT * FROM search AS search
WHERE searchhash = '0cfb82747cf1fdb3ace7d1a761d2648f'
AND userid = 4
AND completed = 1;

MySQL Error : Table 'benimdatabase.search' doesn't exist
Error Number : 1146
Request Date : Sunday, August 8th 2010 @ 11:00:33 PM
Error Date : Sunday, August 8th 2010 @ 11:00:33 PM
Script : http://www. xxx .com/frm/search.php?do=process
Referrer : http://www. xxxx.com/frm/group.php

Database error in vBulletin 4.0.0 Beta 3:

Invalid SQL:

SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height

FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)

WHERE album.userid = 3
AND album.state IN ('public', 'private', 'profile')
AND (album.visible > 0 OR album.moderation > 0)

ORDER BY album.lastpicturedate DESC
LIMIT 2;

MySQL Error : Table 'benimdatabse.picture' doesn't exist
Error Number : 1146
Request Date : Sunday, August 8th 2010 @ 11:03:32 PM
Error Date : Sunday, August 8th 2010 @ 11:03:32 PM
Script : http://www. xxx .com/frm/member.php?u=3
Referrer : http://www. xxx .com/frm/index.php