Database error in vBulletin 4.0.6:
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.posthash = '281a2dc432a04fa5af4314842fddb6e6'
AND
a.userid IN (2)
AND
a.contenttypeid = 1
ORDER BY a.contentid, a.displayorder;
MySQL Error : Unknown column 'a.displayorder' in 'field list'
Error Number : 1054
Request Date : Friday, September 17th 2010 @ 02:17:33 PM
Error Date : Friday, September 17th 2010 @ 02:17:35 PM
Script :
http://nom_de_mon_site.fr/newthread....=newthread&f=2
Referrer :
http://nom_de_mon_site.fr/forumdispl...-News-du-Forum
IP Address : **.**.**.**
Username : VanillaNeko
Classname : vB_Database
MySQL Version : 5.0.90-log