Error Number : 1054

[kkingg]

Database error in vBulletin 4.0.1:
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 (2689,4851,10698,10701,13006,13008,13013,13083,130 84,13101)
AND
a.contenttypeid = 1
ORDER BY a.contentid, a.displayorder;


MySQL Error : Unknown column 'a.displayorder' in 'field list'
Error Number : 1054
Request Date : Sunday, May 23rd 2010 @ 09:18:21 AM
Error Date : Sunday, May 23rd 2010 @ 09:18:21 AMScript : http://www.myforumtr.com/showthread.php?t=1691
Referrer : IP Address : 207.46.13.139
Username : Kayıtsız ?ye
Classname : vB_Database
MySQL Version :

[Videx]

You've done a good job of pasting an error, but you haven't told us much else. Like specifically, have you tried disabling all your mods? What else have you done to try to fix the problem? Have you searched for the error here and at vb.com? How often does the error happen and can you reproduce it?

[kkingg]

thanks