[ProtoPC]

I get this error on a search:

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(*) AS total
FROM vb_album
WHERE state IN ('public', 'private', 'profile') AND vb_album.visible > 0 AND (album.title LIKE '%test%' OR album.description LIKE '%test%');

MySQL Error : Unknown column 'album.title' in 'where clause'
Error Number : 1054
Request Date : Friday, October 24th 2008 @ 02:37:58 PM
Error Date : Friday, October 24th 2008 @ 02:37:58 PM
Script : http://www.cywire.com/community/all_...e=1&query=test
Referrer : http://www.cywire.com/community/all_albums.php
Classname : vB_Database
MySQL Version : 5.0.67-community



Code modified:


$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album
WHERE state IN ('" . implode("', '", $state) . "') AND vb_album.visible > 0 $searchwhere
");



And:

// fetch data and prepare data
$albums = $db->query_read("
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
user.*
FROM " . TABLE_PREFIX . "album AS album
LEFT JOIN " . TABLE_PREFIX . "picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (album.userid = user.userid)
WHERE album.state IN ('" . implode("', '", $state) . "')
AND album.visible > 0 $searchwhere
ORDER BY $sortname $sortorder
LIMIT $start, $perpage
");