http://www.trydone.com/forums/show/16.page JForum - http://www.jforum.net An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

java.sql.SQLException: 出现不支持的 SQL92 标记: 8: execute

jforum-custom.conf中做了修改：
forum.link=http\://192.168.0.94\:8080/forum/
homepage.link=http\://192.168.0.94\:8080

这个ＩＰ地址是我的局域网内的地址，不知怎么解决？
请各位前辈不吝赐教！先行谢过！]]> http://www.trydone.com/posts/preList/1234/3818.page http://www.trydone.com/posts/preList/1234/3818.page GMT http://www.trydone.com/posts/preList/1233/3817.page http://www.trydone.com/posts/preList/1233/3817.page GMT http://www.trydone.com/posts/preList/1231/3814.page http://www.trydone.com/posts/preList/1231/3814.page GMT System.out.println(this.ramWriter.numDocs()+"aaa");
writer = new IndexWriter(this.settings.directory(), this.settings.analyzer(),IndexWriter.MaxFieldLength.UNLIMITED);
writer.addIndexesNoOptimize(new Directory[] { this.ramDirectory});
writer.optimize();

System.out.println(writer.numDocs());
this.createRAMWriter();
}
catch (IOException e) {
throw new SearchException(e);
}
finally {
if (writer != null) {
try {
writer.close();
this.notifyNewDocumentAdded();
}
catch (Exception e) {}
}
}


[b] 打印结果如下[/b]
1aaa
0
]]> http://www.trydone.com/posts/preList/1229/3809.page http://www.trydone.com/posts/preList/1229/3809.page GMT http://www.trydone.com/posts/preList/1228/3806.page http://www.trydone.com/posts/preList/1228/3806.page GMT hegemon wrote:还有，重建索引之后搜不到东西了，只能搜到之后发布的。。。。怎么解决



这个问题怎么解决？？？]]> http://www.trydone.com/posts/preList/1227/3801.page http://www.trydone.com/posts/preList/1227/3801.page GMT http://www.trydone.com/posts/preList/1221/3790.page http://www.trydone.com/posts/preList/1221/3790.page GMT
这是什么原因？

请指点啊。]]> http://www.trydone.com/posts/preList/1218/3784.page http://www.trydone.com/posts/preList/1218/3784.page GMT 希望有人能帮下忙，给我一些基础指导。非常感谢。

我下的源码包：jforum-2.1.8-src.zip
解压后有WEB-INF等文件。
根据网上说把目录放到tomcat的webapp下，打开*****/jforum/install.jsp 没有用。

谢谢帮忙。]]> http://www.trydone.com/posts/preList/1214/3779.page http://www.trydone.com/posts/preList/1214/3779.page GMT 还有，不能在指定的‘版块’进行搜索。]]> http://www.trydone.com/posts/preList/1213/3775.page http://www.trydone.com/posts/preList/1213/3775.page GMT http://www.trydone.com/posts/preList/1212/3774.page http://www.trydone.com/posts/preList/1212/3774.page GMT 我现在做的项目用到了jforum2.1.8，根据用户的要求，搜索功能要添加
按照作者名称搜索，我看了一下代码，在SearchAction里有个buildSearchArgs方法
这个方法里有个SearchArgs对象，这是个javabean，里面有author的属性。
于是我在buildSearchArgs加了如下代码：
//是否要按照帖子作者搜索
if (this.request.getParameter("search_author") != null && !"".equals(this.request.getParameter("search_author"))) {
// //把用户名变为用户id
User user = DataAccessDriver.getInstance().newUserDAO().selectByName(this.request.getParameter("search_author"));

if(user!=null){
args.setAuthor(user.getId());
}
}
测试的时候发现，jforum的搜索都是按照关键字来搜索的，如果我输入的作者的名称，但是没有输入关键字还是查不到记录。

请问一下，我怎么才能不输入关键字而只按照作者查询？需要该什么地方呢？

先谢谢大家了。
]]> http://www.trydone.com/posts/preList/1210/3772.page http://www.trydone.com/posts/preList/1210/3772.page GMT http://www.trydone.com/posts/preList/1209/3771.page http://www.trydone.com/posts/preList/1209/3771.page GMT 这个问题大家遇到过没有？怎么解决？

它原来只获取最后日期
在oracle.sql中的SearchModel增加：
SearchModel.firstPostIdByDate = SELECT * FROM (\
SELECT post_id, ROW_NUMBER() OVER(ORDER BY post_id ASC) -1 LINENUM \
FROM jforum_posts WHERE post_time > ? ORDER BY post_id ASC) \
WHERE LINENUM = 0
即可解决问题]]> http://www.trydone.com/posts/preList/1208/3765.page http://www.trydone.com/posts/preList/1208/3765.page GMT 怎么解决，望高手帮忙解决一下。]]> http://www.trydone.com/posts/preList/1207/3762.page http://www.trydone.com/posts/preList/1207/3762.page GMT