Bug Database Error after upgrading to v1.2.1 from 1.1.3

[bzcomputers]

Here is the error I'm getting:

=================================================
Database error in vBulletin 4.2.0:
Invalid SQL:

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

MySQL Error : Unknown column 'gi.deleted' in 'where clause'
Error Number : 1054
Request Date : Tuesday, September 4th 2012 @ 05:58:22 AM
Error Date : Tuesday, September 4th 2012 @ 05:58:25 AM
Script : CRUISIN
Referrer : CRUISIN
IP Address : XXXXXXXXXXXXXXXXX
Username : Greg
Classname : vB_Database
MySQL Version : 5.5.25-cll
==================================================



Also no longer seeing a category image (neither backgound image or sample photo), just showing missing image icon for all categories.

 

[Dylan]

Sorry about that, edit dbtech/gallery/includes/class_core.php

On line 2249 change

                gi.deleted    = 0

to

                deleted    = 0

That should fix the folder problem as well

 

[bzcomputers]

Thanks, that seems to have taken care of all the issues I was seeing.