jQuery in Action, 2nd edition*
The moose likes JForum and the fly likes Search bug on JForum 2.1.5 (solved) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Search bug on JForum 2.1.5 (solved)" Watch "Search bug on JForum 2.1.5 (solved)" New topic
Author

Search bug on JForum 2.1.5 (solved)

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hello all!

We were getting a bug on some searches here. The problem was:



Going through the source code I found that the SQL statement defined in the file WEB-INF/config/database/generic/generic_queries.sql whose key is SearchModel.selectTopicData was inserting the result of a select from jforum_topics into the table jforum_search_topics.

The problem is that the field topic_title was defined as varchar(60) in jforum_search_topics while it was actually a varchar(100) in jforum_topics. Changing varchar(60) to varchar(100) in jforum_search_topics solves the problem.

Hope it helps. ;-)
[originally posted on jforum.net by jau]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hmm 2 years after I got the same error with jforum 2.1.7!

I did the DB fix manually but I don't understand why that fix wasn't integrated into the upgrade scripts. It's a very common use case! I guess it was a PostgreSQL only issue..
[originally posted on jforum.net by turman]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
turman wrote:I did the DB fix manually but I don't understand why that fix wasn't integrated into the upgrade scripts.

Apparently the jforum_search_topics table is not used anymore in 2.1.8, it could explain...
[originally posted on jforum.net by turman]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Search bug on JForum 2.1.5 (solved)
 
Similar Threads
Multiple email notifications for new messages in a forum topic
error when going to forum from forum list
onetoone unidirectional relationship problem
java.lang.ClassNotFoundException
PreparedStatement fails to execute