Bug Bug with thumbnails

[petandpet]

I had 2 categories with 2 albums inside... then, I delete them through the Admincp.
After that, I created 2 categories (1 and 2)...and since then, where the thumbnail should be (maybe with a "there is no image yet" thumbnail) I see a broken image.

If I make a right click on that image and select "see image", I´m redirected to this page:
Pet and Pet

And I see this error:
Warning: mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'gi.deleted' in 'where clause' in [path]/includes/class_core.php on line 1391

Database error in vBulletin 4.2.0:

Invalid SQL:

			SELECT 
				imageid, 
				dateline, 
				filetype 
			FROM dbtech_gallery_images 
			WHERE 
				catid 		= 5 && 
				gi.deleted	= 0 
			ORDER BY 
				dateline DESC 
			LIMIT 1;

MySQL Error   : Unknown column 'gi.deleted' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, September 6th 2012 @ 01:25:28 PM
Error Date    : Thursday, September 6th 2012 @ 01:25:28 PM
Script        : http://www.petandpet.com/dbtgallery.php?do=gallery_image&id=5&gal=gallery&type=category
Referrer      : http://www.petandpet.com/dbtgallery.php?gal=gallery
IP Address    : 190.193.96.239
Username      : cloferba
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.23-55

If I add a new image to both categories, I see the same broken image..

 

[Dylan]

I have it fixed in the next release, the manual fix for it is here

http://www.dragonbyte-tech.com/f178/database-error-after-upgrading-v1-2-1-1-1-3-a-8979/