Win a flower (🌹) or copy of Real-World Software Development: A Project-Driven Guide to Fundamentals in Java (📚) this week in the Agile and Other Processes forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Bear Bibeault
  • Liutauras Vilda
  • Devaka Cooray
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

"Search" feature doesn't search Subjects

 
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:


[originally posted on jforum.net by cagin]
 
Migrated From Jforum.net
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:


[originally posted on jforum.net by cagin]
 
Migrated From Jforum.net
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
pioneer
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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]
 
joke time: What is brown and sticky? ... ... ... A stick! Use it to beat this tiny ad!
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!