Search Not Working

[Migrated From Jforum.net]

2.1.4
mysql 4.1+

Search doesn't work when searching for users. It would be nice to be able to do a search on a user to see all posts by that user.

Second, when doing a random search for "michael", because someone posted a michael jackson case topic, the following error was produced on the screen:

An error has ocurred. For detailed stack trace, please see the page's source code.

Data truncation: Data truncated for column 'topic_title' at row 1

Brakker
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

What's the topic title?

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

[Migrated From Jforum.net]

I Have the same problem. An error "Data truncation: Data truncated for column 'topic_title' at row 1" has occured.

Tomas Turecek
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

I Have the same problem. An error "Data truncation: Data truncated for column 'topic_title' at row 1" has occured.
JForum 2.1.4
DB: MySQL (version unknown)

Tomas Turecek
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

This data truncation error is already fixed. The colum "topic_title" from the table "jforum_search_topics" is varchar(60), when it should be varchar(100)

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

[Migrated From Jforum.net]

That's great! Does that means that it will be fixed in next stable release? I don't have access to computer where the JForum is installed so I can't fix it by myself.

Another possible bug(?): if I'm searching some word it won't find it when it is followed with comma or dot. Is it bug and will it be fixed?

Thanks

Tomas Turecek
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Comas and dots interfering in the results? that's a bug for sure.

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