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

[Kevin Falcone]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140702/f1f938e7/attachment.sig>