index" box
has cleared itself turn off "Disable Full Text Searching" (aka, turn it back on)
Good luck
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Curtis Gallant
Sent: Tuesday, May 28, 2013 2:23 PM
To: arslist@ARSLIST.ORG
Subjec
I just took a quick look again and the query needs a slight tweak, on the
DB it will store other possible values in the fullTextOptions if some of
the other FTS options are selected, like "Literal FTS Index". So instead
of = '1' you should use > 0.
select schemaId, fieldId from field_char where f
EXCELLENT, dude! That's exactly what I was looking for.
Rock on!
thanks again,
-Andy
On May 28, 2013, at 1:57 PM, Curtis Gallant wrote:
> **
> While you've gotten some direction with FT_Pending which is good, to answer
> your original question on a query for seeing what fields are currently
While you've gotten some direction with FT_Pending which is good, to answer
your original question on a query for seeing what fields are currently set
to be indexed (full list)... you simply look to see what fields have FTS
attribute set. FTS will work against character, diary and attachment
field
I've seen bad things happen with FTS when the server stays up so if your
arserver process hung up and restarted, that could def be a problem. In
order to start the indexing fresh again, you would need to stop AR, delete
the contents of the collection directory and delete the data from
FT_Pending.
settings
Also Restarting AR server will not cause FTS to start again.
Ravi
Date: Tue, 28 May 2013 13:18:47 -0500
From: and...@hicox.com
Subject: Re: how to identify FTS-indexed fields from the DB?
To: arslist@ARSLIST.ORG
**
aah yes, FT_PENDING ...
I had perhaps falsely presumed this was a cache
aah yes, FT_PENDING ...
I had perhaps falsely presumed this was a cache mechanism to queue fields for
the indexer while the indexer was busy doing things (for instance re-indexing,
as it is now, or for instance to queue records if the indexer is still working
on the last run at the next scan i
e.
David Durling
University of Georgia
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
> Sent: Tuesday, May 28, 2013 1:54 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: how to identify FTS
I may be fuzzy on this but there is a table called FT_Pending that
holds some data on what is being indexed and then dropped once it is
in the collection directory. If your indexing is running for more than
a month though, I'm pretty sure it's hung and not doing anything. The
size of FT_Pending sho
Hello everyone,
I currently find myself in the third circle of ARS hell ... debugging FTS on
ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but suffice it to
say, I have no immediate control of that situation).
We have had an FTS re-index procedure running for more than a month n
10 matches
Mail list logo
