又出现 SupeSite info: MySQL Query Error

在SS的首页点击论坛, 进入后的页面的广告位的下面出现:

SupeSite info: MySQL Query Error

Time: 2006-8-30 5:04pm
Script: /site/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,10
Error: Column 'dateline' in order clause is ambiguous
Errno.: 1052

Similar error report has beed dispatched to administrator before.




请见:  http://www.blueswind.com/site/?action_bbs.html

[ 本帖最后由 blueswind 于 2006-8-30 17:08 编辑 ]

打开 templates/default/index.html.php
找到

1. 
   
2. <!--{block name="bbsattachment" parameter="filetype/image/order/dateline DESC
   

复制代码

修改为

1. 
   
2. <!--{block name="bbsattachment" parameter="filetype/image/order/a.dateline DESC
   

复制代码

早就按这个改过了, SS的首页这样改后好了, 可是论坛的页面还是出现这个问题

将bbs.index.html.php
找到

1. 
   
2. <!--{block name="bbsattachment" parameter="filetype/image/order/dateline DESC/limit/0,10/cachetime/2030/subjectlen/12/tpl/bbs_image_subject_list_td"}--><!--论坛贴中的附件图片-->
   

复制代码

修改为

1. 
   
2. <!--{block name="bbsattachment" parameter="filetype/image/order/a.dateline DESC/limit/0,10/cachetime/2030/subjectlen/12/tpl/bbs_image_subject_list_td"}--><!--论坛贴中的附件图片-->
   

复制代码

谢谢茄子小姐！！

更改bbs.index.html.php文件后，广告位下面的内容都显示出来了，但是此页面上面还是有个：undefined，不知是什么？

这个是调用的是论坛的公告
如果美哟公告的话，是会显示undefined

谢谢!!   明白!!!

SupeSite info: MySQL Query Error

Time: 2006-9-9 12:47am
Script: /space/spacecp.php

SQL: SELECT * FROM cdb_forums WHERE status=1 AND (type='group' || allowblog='1') ORDER BY fup, displayorder
Error: Unknown column 'allowblog' in 'where clause'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

原帖由 grouder 于 2006-9-9 00:46 发表
SupeSite info: MySQL Query Error

Time: 2006-9-9 12:47am
Script: /space/spacecp.php

SQL: SELECT * FROM cdb_forums WHERE status=1 AND (type='group' || allowblog='1') ORDER BY fup, displayorder ...

https://discuz.dismall.com/thread-343512-1-1.html