I get this error when I try to open threads which contains attachments..
I tried to repair/optmize tables and to rebuild attachments thumbnails several times. But I still get this error. Can you please help me?
Database error in vBulletin 4.0.3:
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 (31741,31886,31903,31915,31934,32005,32135,32137,32250,32273)
AND
a.contenttypeid = 1
ORDER BY a.contentid, a.displayorder;
MySQL Error : Unknown column 'at.contenttypes' in 'field list'
Error Number : 1054
Request Date : Thursday, May 6th 2010 @ 04:26:27 PM
Error Date : Thursday, May 6th 2010 @ 04:26:29 PM
Script : #/forum/showthread.php?6004-RANKING-A.L.G.-2010&p=32250
Referrer : #/forum/
IP Address : #
Username : Norman
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log
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 (31741,31886,31903,31915,31934,32005,32135,32137,32250,32273)
AND
a.contenttypeid = 1
ORDER BY a.contentid, a.displayorder;
MySQL Error : Unknown column 'at.contenttypes' in 'field list'
Error Number : 1054
Request Date : Thursday, May 6th 2010 @ 04:26:27 PM
Error Date : Thursday, May 6th 2010 @ 04:26:29 PM
Script : #/forum/showthread.php?6004-RANKING-A.L.G.-2010&p=32250
Referrer : #/forum/
IP Address : #
Username : Norman
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log
Comment