2006-12-11 08:12:11,875 - get feed of latestAdvicesOfGoal:feedType=rss_2.0 entriesNum=10 channelID=2747, channelName is:注册用户公告信息发布区; User: unknown IP: 65.55.212.140 USER-AGENT: msnbot-media/1.0 (+http://search.msn.com/msnbot.htm) REFERER: null
2006-12-11 08:12:12,953 - User: userID:-1,userName:guest; IP: 65.55.212.140 USER-AGENT: msnbot-media/1.0 (+http://search.msn.com/msnbot.htm) REFERER: null
2006-12-11 08:12:15,593 - An error happend in setEntries() of RSSGenerator.javaYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY writeDate DESC' at line 1
2006-12-11 08:12:15,609 - get feed of latestAdvicesOfMyDiaries:feedType=rss_2.0 entriesNum=10 userName=guest; User: unknown IP: 65.55.212.140 USER-AGENT: msnbot-media/1.0 (+http://search.msn.com/msnbot.htm) REFERER: null
|
|
RSS订阅在thunderbird中有时会出现丢失条目的情况，但是在新浪点点通和其它RSS阅读器中又没有发现问题。
而且，我时不时在网站日志中发现上面的错误信息“An error happend in setEntries() of RSSGenerator.java”。
现在把它记在这里，好好查一查，说不定能找出在thunderbird中RSS订阅有问题的情况。
通过相关的日记，问题找到了，日志见下：
2006-12-22 09:38:36,171 - get feed of latestDiariesOfMyProcessGoal:feedType=rss_2.0 entriesNum=10 userName=guest; User: unknown IP: 222.214.227.13 USER-AGENT: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) REFERER: http://java.learndiary.com/dispatchPageAction.do?act=rss
2006-12-22 09:38:51,390 - An error happend in setEntries() of RSSGenerator.java: 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 ') AND visibility=0 ORDER BY writeDate DESC' at line 1
2006-12-22 09:38:51,390 - And entriesNum=10, condition is: WHERE typeID=2 AND userName='guest' AND () AND visibility=0 , orderType is: 1, direction is: 2, htmlFlag is: 1
问题主要出在当相关的记录数为0时，条件检测语句会出现AND userName='guest' AND () AND visibility=0，就出错了。