先看我创建一个模块。如图:
生成的调用代码:
- <!--{block name="bbsforum" parameter="type/group,forum,sub/order/displayorder DESC/limit/0,10/cachetime/900/bbsurltype/bbs/showdetail/1/descriptionlen/100/descriptiondot/1/cachename/forumlist/tpl/data"}--><!--论坛板块-->
复制代码 我在模板中的调用代码:-
- <!--{block name="bbsforum" parameter="type/group,forum,sub/order/displayorder DESC/limit/0,10/cachetime/900/bbsurltype/bbs/showdetail/1/descriptionlen/100/descriptiondot/1/cachename/forumlist/tpl/data"}--><!--论坛板块-->
- <div class="hotTopic3">
- <!--{loop $_SBLOCK['forumlist'] $value}-->
- <span>[动感社区]</span> <a href="$value[url]">$value[name]</a>
- <!--{/loop}-->
- </div>
复制代码 运行产生的错误信息:
SupeSite info: MySQL Query Error
User: guest
Time: 2008-11-25 11:05am
Script: /mzone/supesite/index.php
SQL: SELECT ff,*, f.* FROM `mzone`.`[Table]forums` f LEFT JOIN `mzone`.`[Table]forumfields` ff ON ff.fid = f.fid WHERE f.status>0 AND f.type IN ('group','forum','sub') ORDER BY displayorder DESC LIMIT 0,10
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*, f.* FROM `mzone`.`[Table]forums` f LEFT JOIN `mzone`.`[Table]forumfields` ff ON ff.' at line 1
Errno.: 1064
注意到SQL语句了吗?
“SELECT ff,*, f.* FROM `mzone`.`[Table]forums`......”是ff逗号星号,而不是ff点星号。
请尽快解决一下!
解决后麻烦通知我一声,我等着急用。
我的联系方式:
windflaw#126.com
MSN:wuqiang032#hotmail.com
请将#换成@。谢谢:) |