Nothing is appearing in the mysql error log. When I go into mysql the AttachmentsIndex is empty -- although the indexing appeared to succeed.
indexing index 'rt'... WARNING: Attribute count is 0: switching to none docinfo collected 110222 docs, 96.0 MB sorted 14.9 Mhits, 100.0% done total 110222 docs, 95954943 bytes total 48.936 sec, 1960788 bytes/sec, 2252.32 docs/sec total 12 reads, 0.046 sec, 3133.3 kb/call avg, 3.8 msec/call avg total 95 writes, 0.322 sec, 940.1 kb/call avg, 3.3 msec/call avg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Falcone Sent: Friday, March 23, 2012 1:37 PM To: [email protected] Subject: Re: [rt-users] RT 4.0.5 fulltext errors On Fri, Mar 23, 2012 at 12:51:35PM -0500, Poulter, Dale wrote: > We have just install 4.0.5 in a test environment and migrated our data > from 3.8.7. The system > was working with 4.0.4 with the same configuration before our dev server > crashed. The system > seems to be working well until we attempt to do a full text search. > Sphinx is enabled in > mysql and the indexer has ran successfully. I can do a basic simple > search without any > problems but when I do a fulltext search (fulltext: test) mysql restarts > and I get the error > below. Has anyone encountered this issue? What's in the mysql error log? RT is just reporting that there was an error, mysql will be able to tell you what's really going on. Also, what happens when you try to select from your AttachmentsIndex table manually? -kevin
