Project

General

Profile

Forums » Help »

Problems with search results and paging with Redmine 2.3.2 on Bitnami stack and SQL Server DB

Added by Caleb Mumford over 10 years ago

We have been running redmine for years. We recently deployed to a Windows machine running on the Bitnami stack. We also ported the DB to SQL Server. Everything went smoothly and we have been running like this for a couple of months.

However, searching is strange. It is as if it jumps you to the second to the last search result page. For example, if we search for a common word like "test" and see 2603 results. We'll see the first page of 10 results with a next link at the bottom. You click the "next" link and it will only show you 3 more results. 10 + 3 is only 13 where it reported 2603 results. You then click the previous link and it takes you to the previous results page with 10 results. Then you can still click previous and continue paging through all the results 10 at a time.

Anybody have any ideas? We have not changed any of the code or customized anything with the site. It is pretty much a stock 2.3.2 Redmine release.

Thanks!


Replies (3)

RE: Problems with search results and paging with Redmine 2.3.2 on Bitnami stack and SQL Server DB - Added by Kuniharu AKAHANE over 10 years ago

Hi, Caleb.

Just for your information.
I'm not sure about bitnami and MicroSoft SQL Server, but I've experienced similar situation before.

Almost 2years ago, I was using Redmine 0.9.4 with ruby 1.8.7, MySQL 5.0, and 2 plugins(importer, redmine_draft).
The search results had 101 items and there were 21 pages.
When I click NEXT>> link on result page 3, I got a blank page and could not move to forward pages anymore.

  • Causality IMHO:
    Redmine has a data dependency between the issue-id and issue-created_on date-time. They all must be in ascending order.
    This dependency is very important for the useful crossover searching, within Issues, News, Documents, Changesets, Wiki-pages, Messages and Projects.
  • Happened when:
    1. There is a disorder on Issue-id and issue-created_on.
    2. The disordered issue came across just on the edge/border of the result pages.
  • Why disordered:
    1. I imported many issues with redmine_importer_plugin.
    2. My mistake was Modifying the Issues-created_on date-time. It should be stamped by Redmine.
  • Disorder Example
    Issue #1   created_on  1 Feb 2013
Issue #2   created_on  2 Feb 2013
Issue #3   created_on 20 Dec 2012  <- disorder. I modified it when I imported it from CSV files.
Issue #4   created_on 21 Dec 2012  <- disorder. I modified it when I imported it from CSV files.
Issue #5   created_on  3 Feb 2013

I can not explain the details in English correctly, but if you have such disorders on issue-created_on that I mentioned above,
This information could be a key to solution.

Hope this help.

RE: Problems with search results and paging with Redmine 2.3.2 on Bitnami stack and SQL Server DB - Added by Caleb Mumford over 10 years ago

Thanks for the tip. I did find several issues that where out of sequential order or that had the exact same created_on date. However, I have cleaned out all of the problem records and I am still experiencing the same issues. I checked Issues, News, Documents, CHnagesets, Wiki-pages, Messages, and Projects.

After altering the tables directly through SQL, do you know if there is anything I need to do to trigger the redmine search engine to re-index the content?

Thanks for your help!!!

RE: Problems with search results and paging with Redmine 2.3.2 on Bitnami stack and SQL Server DB - Added by Olivier Houdas almost 10 years ago

Check out #15017, I had an issue with search results and Microsoft SQL DB (http://www.redmine.org/issues/15017)

I solved it by fixing some code in the Ruby driver...

    (1-3/3)