[Alfa1]

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT blog_text.blogid, blog_text.state, blog_text.blogtextid, 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, blog_text.title AS text_title
FROM vb6_blog_text
INNER JOIN (
SELECT max( blogtextid ) AS blogtextid
FROM vb6_blog_text AS blog_text
GROUP BY blogid
)blogtextids ON blog_text.blogtextid = blogtextids.blogtextid
INNER JOIN vb6_blog AS blogtitle ON blogtitle.blogid = blog_text.blogid
WHERE blog_text.dateline >=1228188924
AND blogtitle.state = 'visible'
ORDER BY blog_text.dateline DESC
LIMIT 15;

MySQL Error : Unknown column 'blog_text.blogid' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 9th 2008 @ 04:35:24 AM
Error Date : Tuesday, December 9th 2008 @ 04:35:24 AM
Script : http://www.mysite.com/forum/search.php?do=getnew