need some help please

[destinydog]

cannot figure out how to fix this:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT filename, filesize, attachmentid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail
FROM attachment
WHERE posthash = '6d80fc5ea6bbf2e1856f963aaa855743'
AND userid = 2
ORDER BY dateline

mysql error: Unknown column 'thumbnail_filesize' in 'field list'

mysql error number: 1054

Date: Monday 04th of October 2004 01:36:42 PM
Script: http://www.customtruckforum.com/forum/newattachment.php?f=7&poststarttime=1096911394&posthash=6d80fc5ea6bbf2e1856f963aaa855743
Referer:
Username:
IP Address:

[Colin F]

Try changing it to IF(filesize > 0, 1, 0) ??

[Velocd]

The column `thumbnail_filesize` doesn't exist in the table `attachment`.

Use PhpMyAdmin to verify the column exists, or DESCRIBE attachment; in SSH.

If this is a custom hack, I would forward this question to that author's thread.