修改模板时发现一个BUG

为文件频道显示图片，添加block出错。很明显的是拼凑SQL的错误，请尽快解决！

BLOCK




SupeSite info: MySQL Query Error

Time: 2007-2-9 2:48pm
Script: /index.php

SQL: SELECT i.*, ii.*, a.aid AS a_aid, a.type AS a_type, a.itemid AS a_itemid, a.uid AS a_uid, a.dateline AS a_dateline, a.filename AS a_filename, a.subject AS a_subject, a.attachtype AS a_attachtype, a.isimage AS a_isimage, a.size AS a_size, a.filepath AS a_filepath, a.thumbpath AS a_thumbpath, a.downloads AS a_downloads FROM supe_spaceitems i LEFT JOIN supe_spacefiles ii ON ii.itemid=i.itemidLEFT JOIN supe_attachments a ON a.hash=i.hash WHERE i.grade>-1 AND i.type='file' AND i.folder=1 ORDER BY i.dateline DESC LIMIT 0,12
Error: Unknown column 'i.itemidLEFT' in 'on clause'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

谢谢反馈，是个bug，我们修正一下