"Search" feature doesn't search Subjects

[Migrated From Jforum.net]

Hi,

As far as I see, search engine doesn't search the entered keywords in the subjects. How can I make it search subjects also?

Thanks.
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

OK I'm changing the question ops:

Posts of admin can not be found by search. But this is more acceptable
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

I haven't tested this myself, but what version are you using?

The "admin" user is just another user in the system. In fact, you can change the name of the admin user to something else, if you'd like.

Therefore, the only thing I know of that can cause posts to not return during searches is a permissions issue. In other words, if the user performing the search doesn't have access to a particular forum, nothing will return from within that forum.

I'd suggest checking your user/group permissions. Have you changed them from the defaults?
[originally posted on jforum.net by fcgreg]

[Migrated From Jforum.net]

No the problem is not with the permissions :roll: , the user that makes the search can read (even delete) the post which is not returned as a search result.

My jforum is 2.1.5 I guess. It says

Powered by JForum 2.1.5 � 2005 - Rafael Steil

at the bottom.

I thought the problem was with the posts of admin, but I got deeper in the problem and saw that an ordinary user makes a post but the same user cannot find his own post as a search result in some cases. I couldn't find the exact steps to reproduce the problem, and I'm quittinq, because I'm tired .

But to sum up the problem, subject of a post is not entered to jforum_search_wordmatch table. All of the words of the subject are inserted to jforum_search_words. Just the match is missing. When I insert a row to jforum_search_wordmatch manually, I can see that the post is listed in the search results.

There is another problem, and I'll open another topic for that...

I tried to download latest cvs, but couldn't succeed so far...
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

I think it is related with the bug listed in https://coderanch.com/t/575390
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

cagin wrote:No the problem is not with the permissions :roll: , the user that makes the search can read (even delete) the post which is not returned as a search result.

Don't roll your eyes. Just because permissions were working in one place doesn't mean that they weren't broken in another. Sheesh.

cagin wrote:My jforum is 2.1.5 I guess. It says

Powered by JForum 2.1.5 � 2005 - Rafael Steil

at the bottom.

Well this certainly helps. You're using an unstable testing version of JForum. In the future please advise which version you're using and it will help us to better direct our responses. Then you won't have to roll your eyes at those trying to help you.

cagin wrote:... But to sum up the problem, subject of a post is not entered to jforum_search_wordmatch table. All of the words of the subject are inserted to jforum_search_words. Just the match is missing. When I insert a row to jforum_search_wordmatch manually, I can see that the post is listed in the search results.

Now we're talking. Thanks for the details. It sounds like you've pretty much figured this out. I suggest you enter this into the bug tracker (*but you may want to search for it in there first -- I haven't checked it lately).

Thanks for the report.
[originally posted on jforum.net by fcgreg]

[Migrated From Jforum.net]

Thanks for your help

I see many ObjectClosedException errors in stderr. I guess while the user edits the message, db connections is dropped (Using SQL Server 2000 by the way). Therefore the posts cannot be inserted to the tables mentioned above, and the search func. doesn't work.

Any idea about this exception?

Below are some exception samples:

[13.10.2005 17:02:28:769 EEST]  c44c9fd SystemErr     R com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
[13.10.2005 17:02:28:889 EEST]  c44c9fd SystemErr     R 	at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:952)
[13.10.2005 17:02:28:889 EEST]  c44c9fd SystemErr     R 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setInt(WSJdbcPreparedStatement.java:987)
[13.10.2005 17:02:28:889 EEST]  c44c9fd SystemErr     R 	at net.jforum.dao.generic.GenericSearchIndexerDAO.associateWordToPost(GenericSearchIndexerDAO.java:169)
[13.10.2005 17:02:28:889 EEST]  c44c9fd SystemErr     R 	at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:133)
[13.10.2005 17:02:28:889 EEST]  c44c9fd SystemErr     R 	at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:164)
[13.10.2005 17:02:28:889 EEST]  c44c9fd SystemErr     R 	at net.jforum.util.search.simple.MessageIndexerTask.execute(MessageIndexerTask.java:79)
[13.10.2005 17:02:28:889 EEST]  c44c9fd SystemErr     R 	at net.jforum.util.concurrent.executor.AbstractWorker.run(AbstractWorker.java:74)
[13.10.2005 17:02:28:889 EEST]  c44c9fd SystemErr     R 	at java.lang.Thread.run(Thread.java:568)
[14.10.2005 11:34:29:929 EEST]  c44c9fd SystemErr     R com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
[14.10.2005 11:34:29:990 EEST]  c44c9fd SystemErr     R 	at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:952)
[14.10.2005 11:34:29:990 EEST]  c44c9fd SystemErr     R 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:445)
[14.10.2005 11:34:29:990 EEST]  c44c9fd SystemErr     R 	at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:129)
[14.10.2005 11:34:29:990 EEST]  c44c9fd SystemErr     R 	at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:130)
[14.10.2005 11:34:29:990 EEST]  c44c9fd SystemErr     R 	at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:164)
[14.10.2005 11:34:29:990 EEST]  c44c9fd SystemErr     R 	at net.jforum.util.search.simple.MessageIndexerTask.execute(MessageIndexerTask.java:79)
[14.10.2005 11:34:29:990 EEST]  c44c9fd SystemErr     R 	at net.jforum.util.concurrent.executor.AbstractWorker.run(AbstractWorker.java:74)
[14.10.2005 11:34:29:990 EEST]  c44c9fd SystemErr     R 	at java.lang.Thread.run(Thread.java:568)
                   

[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

Ah... I don't use MS SQL Server so I won't be able to offer you much help on this question. However, keep this in mind:

The MS SQL Server implementation is beta, and incomplete. I know there are folks using it out there (I found evidence by searching here in the forums). However, I don't know how actively it's been maintained.
[originally posted on jforum.net by fcgreg]

[Migrated From Jforum.net]

I downloaded latest CVS yesterday, the problem remains. So I'll dive into the code myself 8)

I get this error when I edit a post. The post is updated successfully, but new words are not entered to jforum_search_words.

Latest console output follows:

[19.10.2005 11:25:04:383 EEST] 4f9c4f9c WSRdbDataSour I DSRA8203I: Database product name : Microsoft SQL Server
[19.10.2005 11:25:04:414 EEST] 4f9c4f9c WSRdbDataSour I DSRA8204I: Database product version : Microsoft SQL Server  2000 - 8.00.194 (Intel X86) 
	Aug  6 2000 00:57:48 
	Copyright (c) 1988-2000 Microsoft Corporation
	Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 1)

[19.10.2005 11:25:04:414 EEST] 4f9c4f9c WSRdbDataSour I DSRA8205I: JDBC driver name  : SQLServer
[19.10.2005 11:25:04:461 EEST] 4f9c4f9c WSRdbDataSour I DSRA8206I: JDBC driver version  : 3.3.33 (008842.005010.006327)
[19.10.2005 11:25:11:993 EEST] 7d447d44 WebGroup      I SRVE0180I: [POSForum] [/POSForum] [Servlet.LOG]: /templates/ping_session.jsp: init
[19.10.2005 11:33:02:289 EEST] 2c942c94 SystemOut     O SELECT TOP 15 p.post_id, topic_id, forum_id, p.user_id, post_time, poster_ip, enable_bbcode, p.need_moderate, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, status, user_karma, pt.post_subject, pt.post_text, username, attach FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id AND p.need_moderate = 0 AND p.post_id not in (   SELECT TOP 0 p.post_id FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id ) ORDER BY post_time ASC	
[19.10.2005 11:33:24:134 EEST] 7d447d44 SystemOut     O SELECT TOP 15 p.post_id, topic_id, forum_id, p.user_id, post_time, poster_ip, enable_bbcode, p.need_moderate, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, status, user_karma, pt.post_subject, pt.post_text, username, attach FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id AND p.need_moderate = 0 AND p.post_id not in (   SELECT TOP 0 p.post_id FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id ) ORDER BY post_time ASC	
[19.10.2005 11:33:33:588 EEST] 2c942c94 Logger        I uk.ltd.getahead.dwr.util.Logger  Logging using commons-logging.
[19.10.2005 11:33:33:619 EEST] 2c942c94 WebGroup      I SRVE0180I: [POSForum] [/POSForum] [Servlet.LOG]: dwr-invoker: init
[19.10.2005 11:33:33:869 EEST] 2c942c94 Configuration W uk.ltd.getahead.dwr.Configuration  Missing class for creator 'spring'. Failed to load uk.ltd.getahead.dwr.create.SpringCreator. Cause: org.springframework.beans.factory.BeanFactory
[19.10.2005 11:33:34:088 EEST] 2c942c94 LogErrorHandl E uk.ltd.getahead.dwr.util.LogErrorHandler  Line=2 Belge k̦k ̦��esi "dwr", DOCTYPE k̦k�? "null" ile e��le��melidir.
[19.10.2005 11:33:34:088 EEST] 2c942c94 LogErrorHandl E uk.ltd.getahead.dwr.util.LogErrorHandler  Line=2 Belge ge̤ersiz: dilbilgisi saptanmad��.
[19.10.2005 11:33:34:697 EEST] 4f9c4f9c SystemOut     O SELECT TOP 15 p.post_id, topic_id, forum_id, p.user_id, post_time, poster_ip, enable_bbcode, p.need_moderate, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, status, user_karma, pt.post_subject, pt.post_text, username, attach FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id AND p.need_moderate = 0 AND p.post_id not in (   SELECT TOP 0 p.post_id FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id ) ORDER BY post_time ASC	
[19.10.2005 11:33:47:745 EEST] 4f9c4f9c SharedPool    I J2CA0086W: Shareable connection MCWrapper id 16151615  Managed connection com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@6eb76eb7  State:STATE_TRAN_WRAPPER_INUSE
 from resource jdbc/posForumDS was used within a local transaction containment boundary.
[19.10.2005 11:33:47:979 EEST] 7d447d44 SystemOut     O SELECT TOP 15 p.post_id, topic_id, forum_id, p.user_id, post_time, poster_ip, enable_bbcode, p.need_moderate, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, status, user_karma, pt.post_subject, pt.post_text, username, attach FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id AND p.need_moderate = 0 AND p.post_id not in (   SELECT TOP 0 p.post_id FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id ) ORDER BY post_time ASC	
[19.10.2005 11:33:48:323 EEST] 774c774c SystemErr     R com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at java.lang.Throwable.<init>(Throwable.java)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at java.lang.Throwable.<init>(Throwable.java)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at java.sql.SQLException.<init>(SQLException.java:93)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at com.ibm.websphere.ce.cm.PortableSQLException.<init>(PortableSQLException.java:50)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:952)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setString(WSJdbcPreparedStatement.java:1191)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:141)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:162)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at net.jforum.util.search.simple.MessageIndexerTask.execute(MessageIndexerTask.java:79)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at net.jforum.util.concurrent.executor.AbstractWorker.run(AbstractWorker.java:74)
[19.10.2005 11:33:48:339 EEST] 774c774c SystemErr     R 	at java.lang.Thread.run(Thread.java:806)
[19.10.2005 11:34:04:746 EEST] 31b131b1 SystemOut     O SELECT TOP 15 p.post_id, topic_id, forum_id, p.user_id, post_time, poster_ip, enable_bbcode, p.need_moderate, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, status, user_karma, pt.post_subject, pt.post_text, username, attach FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id AND p.need_moderate = 0 AND p.post_id not in (   SELECT TOP 0 p.post_id FROM jforum_posts p, jforum_posts_text pt, jforum_users u WHERE p.post_id = pt.post_id AND topic_id = ? AND p.user_id = u.user_id ) ORDER BY post_time ASC	

[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

I'll take a look.

Just keep in mind that the cvs code for sql server is partially done (not complete), so if don't fixed it, much probably it won't work 100%

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

OK, I solved the problem somehow. I guess the problem was trying to use a database imported from one SQL Server to another. (I did this because I didn't want to lose the existing data, and I did this by exporting first to an excel file, then importing that excel to the destination server).

When I created the database and tables at the destination server from scratch, the problem disappeared :lol:
[originally posted on jforum.net by cagin]