• 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
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Search Not Working

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What's the topic title?

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Comas and dots interfering in the results? that's a bug for sure.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!