[y2ksw]

Originally Posted by Dr.osamA

Thank you for update

but i have Database error

PHP Code:

Invalid SQL:

                SELECT
                    fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
                    a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
                    at.contenttypes
                FROM attachment AS a
                INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
                LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
                WHERE
                    a.contentid IN (81195,81203,81286,81287,81289,81290,82837)
                        AND
                    a.contenttypeid = 1
            
ORDER BY a.contentid, a.displayorder;

MySQL Error   : Unknown column 'fd.thumbnail_filesize' in 'field list'
Error Number  : 1054
Request Date  : Friday, April 1st 2011 @ 04:55:45 PM
Error Date    : Friday, April 1st 2011 @ 04:55:45 PM
Script        : http://www.alra7ba.info/vb/showthread.php?t=12925&p=81287&viewfull=1&langid=1
Referrer      : 


any help plzzz

Sorry, but this error does not come from my plugin. I don't use vbulletin attachments, but a completely different table (iei_img) for filename storage.