已经知道原因了,麻烦看下以下出错代码,看看有什么解决的方法:
SupeSite info: MySQL Query Error
Time: 2006-6-26 5:14pm
Script: /atg/index.php
SQL: SELECT a.aid AS a_aid, a.tid AS a_tid, a.pid AS a_pid, a.dateline AS a_dateline, a.readperm AS
a_readperm, a.filename AS a_filename, a.description AS a_description, a.filetype AS a_filetype,
a.filesize AS a_filesize, a.attachment AS a_attachment, a.downloads AS a_downloads, t.* FROM
cdb_attachments a LEFT JOIN cdb_threads t ON t.tid = a.tid WHERE a.filetype IN ('image/bmp', 'image/gif',
'image/jpeg', 'image/pjpeg', 'image/png') AND t.displayorder >= 0 ORDER BY dateline DESC LIMIT 0,5
Error: Column 'dateline' in order clause is ambiguous
Errno.: 1052
Similar error report has beed dispatched to administrator before. |