ChiliProject is not maintained anymore. Please be advised that there will be no more updates.

We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.

Forums » Discuss »

Searches

Added by Patrick Naubert at 2012-09-14 10:19 pm

We a finding that searches done on large sets will return incorrect data. Even demo.chiliproject.org is prone to this. We know about bug #906 which has to do with incorrect pagination, but we have found that the problem goes even deaper than that by not showing some of the records retrieved while you paginate.

We have tested the exact same DB with Redmine 1.4 and 2.0-stable with absolutely no occurance of the problem.

Anyone noticing strage search results display ?


Replies (1)

RE: Searches - Added by Felix Schäfer at 2012-09-21 09:30 am

I'm not aware of any problems with the search, and if there are I'd suppose those to be more at the DB/SQL level than in the code itself as there is no filtering done other than the query.

Could you try to look for similarities in things you think are missing? Things like unusual characters, open or closed issues, open or archived projects (results from the later shouldn't show up…) and so on?

Furthermore: what DB do you use in production and which did you use for your tests? If possible, please include the version of the DB, the collation of the DB, which DB adapter you use (for example mysql or mysql2 for MySQL) and what ruby version it was, thanks.

(1-1/1)