發表留言
数据库出错:
MySQL Query ErrorMysql error description: Unknown column 'a.isSpam' in 'field list'
Mysql error number: 1054
Date: 2010-07-30 09:03
Script: http://www.jas9.com/f2blog/rewrite.php
SQL code: select distinct a.id, a.author, a.password, a.homepage, a.email, a.face, a.ip, a.content, a.postTime,IF(a.isSpam=1,1,a.isSecret) as isSecret, a.parent, a.HTTP_REFERER, a.isSpam ,b.id as member_id,b.nickname,b.isHiddenEmail,b.email as member_email,b.homePage as member_homepage from f2blog_guestbook as a left join f2blog_members as b on a.author=b.username where parent='0' order by postTime desc Limit 140,10