[rt-users] Only some searches in RT fail (Sphinx)

[Daniel Eiteneuer]

Thanks a lot for pointing me to this commit:
https://github.com/bestpractical/rt/commit/378c7e352916494000db735fae550f22eae2b5e7

This solved my problem. Now the searches run without errors. But I have another problem related to the sphinx search.
If I search for tickets within the RT with these conditions:

Subject LIKE 'something'
OR Content LIKE 'something'

I get 11 search results. Then I narrow the search condition to 

Content LIKE 'something'

and I get 242 results.
I think this is not possible, is it? For the search term I've used, 242 matching tickets seems reasonable.

Regards
Daniel

-----Ursprüngliche Nachricht-----
Von: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von Kevin Falcone
Gesendet: Mittwoch, 2. Juli 2014 20:46
An: rt-users at lists.bestpractical.com
Betreff: Re: [rt-users] Only some searches in RT fail (Sphinx)

On Wed, Jul 02, 2014 at 02:19:40PM +0000, Daniel Eiteneuer wrote:
> But the main problem occurs, if I just search for "something" in the tickets'
> content (not the subjects). The webinterface tells me, there are 0 
> results. The apache error log states:
> 
>  
> 
> [4387] [Wed Jul  2 14:11:19 2014] [warning]: DBD::mysql::st execute failed:
> There was a problem processing the query on the foreign data source. 
> Data source error: INTERNAL ERROR: 1st column must be bigint to accept 
> 64-bit DOCID at 
> /usr/local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm line 589. 
> (/usr/
> local/share/perl/5.18.2/DBIx/SearchBuilder/Handle.pm:589)
>  
> 
> Does anyone knows, how to solve this problem?

Replace the id column of the AttachmentsIndex table with a BIGINT column.  Fix included in the upcoming 4.2.6rc1

https://github.com/bestpractical/rt/commit/378c7e352916494000db735fae550f22eae2b5e7

-kevin