关于dede 5.7 调用discuz x2.5 贴子图片的问题

[qaz952727]

dede 5.7 调用discuz x2.5 贴子图片的问题

{dede:loop table="pre_forum_thread" fid="2″sort="tid" row="10"}
<a href="/bbs/forum.php?mod=viewthread&tid=[field:tid /]"><img src="/bbs/attachments/[field:attachments/]" alt="[field:subject/]" width="100" height="80" border="0" /></a>{/dede:loop}

这段成功代码调用了 指定版块ID2 的贴子，但贴子的封面图片没被调用成功，图片的alt调用成了（alt="[field:subject/]"） 。


<img src="/bbs/attachments/[field:attachments/]" 这里的代码是不是错了，改成什么才把图片调用出来呢 谢谢解答

[qaz952727]

自己顶顶自己顶顶

[qaz952727]

坐等高手

[观策互动]

[field:attachment/]自习对比下看那错了

[观策互动]

得进行关联查询 pre_forum_thread表中是没有图片路径的
{dede:sql sql="SELECT`cdb_attachments`.`aid`,`cdb_attachments`.`attachment`,`cdb_threads`.`tid`, `cdb_threads`.`fid`,`cdb_threads`.`subject` FROM `cdb_attachments` LEFT JOIN `cdb_threads`
ON`cdb_threads`.`tid`=`cdb_attachments`.`tid` WHERE `cdb_attachments`.`readperm`='0' AND`displayorder`>='0' AND `filetype`='image/pjpeg' GROUP BY tid LIMIT 0,1 "}
<a href="/bbs/viewthread.php?tid=[field:tid /]">
<img src="/bbs/attachments/[field:attachment/]" ALT="[field:subject/]" width="100" height="80" border="0" />
</A>
{/dede:sql} 你参考下

[qaz952727]

自己顶顶

[qaz952727]

{dede:sql sql="SELECT`pre_forum_attachment`.`aid`,`pre_forum_attachment`.`attachment`,`pre_forum_thread`.`tid`, `pre_forum_thread`.`fid`,`pre_forum_thread`.`subject` FROM `pre_forum_attachment` LEFT JOIN `pre_forum_thread`  
ON`pre_forum_thread`.`tid`=`pre_forum_attachment`.`tid` WHERE `pre_forum_attachment`.`readperm`='0' AND`displayorder`>='0' AND `filetype`='image/pjpeg' GROUP BY tid LIMIT 0,1 "} 

 <img src="/bbs/data/attachment/forum/[field:attachment/]" alt="[field:subject/]" width="100" height="80" border="0" />"
</a>{/dede:sql}

报错：
Error infos: Unknown column 'pre_forum_attachment.attachment' in 'field list'
Error sql: SELECT`pre_forum_attachment`.`aid`,`pre_forum_attachment`.`attachment`,`pre_forum_thread`.`tid`, `pre_forum_thread`.`fid`,`pre_forum_thread`.`subject` FROM `pre_forum_attachment` LEFT JOIN `pre_forum_thread` ON`pre_forum_thread`.`tid`=`pre_forum_attachment`.`tid` WHERE `pre_forum_attachment`.`readperm`='0' AND`displayorder`>='0' AND `filetype`='image/pjpeg' GROUP BY tid LIMIT 0,1

[qaz952727]

[Quote=引用 5 楼 的回复:]
得进行关联查询 pre_forum_thread表中是没有图片路径的
{dede:sql sql="SELECT`cdb_attachments`.`aid`,`cdb_attachments`.`attachment`,`cdb_threads`.`tid`, `cdb_threads`.`fid`,`cdb_threads`.`subject` FROM `cdb_attachments……
[/Quote]
谢谢你的回答 。
我改成了
{dede:sql sql="SELECT`pre_forum_attachments`.`aid`,`pre_forum_attachments`.`attachment`,`pre_forum_threads`.`tid`, `pre_forum_threads`.`fid`,`pre_forum_threads`.`subject` FROM `pre_forum_attachments` LEFT JOIN `pre_forum_threads`
ON`pre_forum_threads`.`tid`=`pre_forum_attachments`.`tid` WHERE `pre_forum_attachments`.`readperm`='0' AND`displayorder`>='0' AND `filetype`='image/pjpeg' GROUP BY tid LIMIT 0,1 "}

发现还是没能行