Just tried to upgrade and got the following error:

XML Error: Empty document at Line 1

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
");

First the db error if you search, second phrase the Submit button on the search, please. Thanks Abe. :)

I didn't follow the install directions, my apologies. After I uploaded the php file it worked.

Search worked for me as well.

I think it still needs a TABLE_PREFIX instead of "vb_album.visible".. But I really don't know how to code PHP, so I can't help...

Next version.

Bug:

Error on Search :

Datenbankfehler in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(*) AS total
FROM vb3_album
WHERE state IN ('public', 'private', 'profile') AND (album.title LIKE '%redlabour%' OR album.description LIKE '%redlabour%');

MySQL-Fehler : Unknown column 'album.title' in 'where clause'
Fehler-Nr. : 1054
Fehler-Zeit : Friday, 24.10.2008 @ 23:11:59
Datum : Friday, 24.10.2008 @ 23:11:59
Skript : http://www.politikstube.de/forum/all...uery=redlabour
Referrer : http://www.politikstube.de/forum/all_albums.php
IP-Adresse : XXXX
Benutzername : XXX
Klassenname : vB_Database_MySQLi
MySQL-Version : 5.0.67

Same bug on search after upgrade:

Database error in vBulletin 3.7.3 PL1:

Invalid SQL:

SELECT COUNT(*) AS total
FROM vbalbum
WHERE state IN ('public', 'private', 'profile') AND (album.title LIKE '%remove%' OR album.description LIKE '%remove%');

MySQL Error : Unknown column 'album.title' in 'where clause'
Error Number : 1054
Request Date : Saturday, October 25th 2008 @ 12:20:01 AM
Error Date : Saturday, October 25th 2008 @ 12:20:01 AM
Script : http://www.eugenol.ro/forum/all_albu...1&query=remove
Referrer : http://www.eugenol.ro/forum/all_albums.php
IP Address : .............
Username : admin
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community


Any chance for a picture resizer in albums? If I click a thumbnail picture it shows full size pics much bigger than the forum.

Fixed in a version about to come out.