[BigDog56]

Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT blog_text.state, blog_text.blogid, blog_text.username,blog_text.userid, date(FROM_UNIXTIME(blog_text.dateline)) as date, time(FROM_UNIXTIME(blog_text.dateline)) as time, blogtitle.userid as authorid, blogtitle.username as author, blogtitle.views as views ,pagetext,blogtitle.title as title FROM xxxxx_blog_text INNER JOIN xxxxxxx_blog as blogtitle on blogtitle.blogid = blog_text.blogid WHERE blog_text.dateline >=1213149267 AND blog_text.state = 'visible' ORDER by blog_text.dateline DESC LIMIT 5;

MySQL Error : Unknown column 'blog_text.state' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 17th 2008 @ 07:54:27 PM
Error Date : Tuesday, June 17th 2008 @ 07:54:27 PM
Script : http://ravensforums.com/forums/search.php?do=getnew
Referrer :
IP Address : 76.11.133.237
Username : Jeff
Classname : vb_database
MySQL Version : 5.0.45-community-log