Running on 2.02b15 and I'm getting

---------------------------
Debugger Exception Notification
---------------------------
Project TfR.exe raised exception class EEDBException with message 'ElevateDB Error #601 The table EMails is corrupt (The unique index fti_Message contains duplicate keys)'.
---------------------------
Break   Continue   Help  
---------------------------

fti_Message is a full text index. I've tried repairing the table (yawn) twice but still get this. Its almost certainly something to do with the data since there are only a couple of emails that it happens on but I can't see how it can happen.

Roy Lambert

Roy,

<< fti_Message is a full text index. I've tried repairing the table (yawn)
twice but still get this. Its almost certainly something to do with the data
since there are only a couple of emails that it happens on but I can't see
how it can happen. >>

Is this during an insert or update ?

Are you using a custom text filter and/or word generator ?  A repair should
definitely fix the problem, unless the word generator and/or text filter is
returning different results for inserts vs. updates.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< fti_Message is a full text index. I've tried repairing the table (yawn)
>twice but still get this. Its almost certainly something to do with the data
>since there are only a couple of emails that it happens on but I can't see
>how it can happen. >>
>
>Is this during an insert or update ?

Update

>Are you using a custom text filter and/or word generator ?

Yes - the ones in extensions ng

>A repair should
>definitely fix the problem, unless the word generator and/or text filter is
>returning different results for inserts vs. updates.

How could they return different results? Also since things work properly apart from a couple of records I'm inclined to suspect the data, but I'm puzzled as to how it can happen.

Roy Lambert

Tim


I have an idea but have no idea how to check it out.

The problem table is emails. On downloading I set the type to HTML or ANSI which is also used to determine the textfilter/wordgenerator. I changed the mechanism for this recently, changed it back again because it wasn't working. On receipt the two problem emails would have been set to HTML. Viewing it it wouldn't have been formatted correctly so I hit the re-decode button which would have set the type to ANSI.

DO you think that could have caused it?

Roy Lambert

Roy,

<< How could they return different results? Also since things work properly
apart from a couple of records I'm inclined to suspect the data, but I'm
puzzled as to how it can happen. >>

I don't know since I haven't looked at your extensions in any detail.
It may very well be the data, in which case I'll need a copy of it to see
what the issue is.   The other option is to alter the indexes to remove the
custom filter and/or word generator and see what the result is.  If things
work okay, then the problem is in the extensions.  If not, then the problem
is in ElevateDB or the data.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< I have an idea but have no idea how to check it out.

The problem table is emails. On downloading I set the type to HTML or ANSI
which is also used to determine the textfilter/wordgenerator. I changed the
mechanism for this recently, changed it back again because it wasn't
working. On receipt the two problem emails would have been set to HTML.
Viewing it it wouldn't have been formatted correctly so I hit the re-decode
button which would have set the type to ANSI.

DO you think that could have caused it? >>

It's possible, although I'm having a hard time picturing the scenario that
would cause it.  How does the type determine the word generator that is used
?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


The type is used for the filter type column.

I switched the wordgenerator to Default and I don't get the error so it looks like I need to poke around in my code. Before I start two questions:

1. do you think the error message is "genuine" or could it be that my code is just throwing an AV and this is the only error message ElevateDB can come up with

2. if it is genuine any guidance as to what to look for. Since a word generator just spits out words and there are pretty mush guaranteed to be duplicates I'm not sure what I should be looking for.

Roy Lambert

Tim


I tested out my word generator as best I could and it seems fine so I tried dropping the index and adding back. That worked. So it looks to me now as though somehow the index had become corrupted and the repair didn't sort it out.

Roy Lambert

Roy,

<< The type is used for the filter type column.

I switched the wordgenerator to Default and I don't get the error so it
looks like I need to poke around in my code. Before I start two questions:

1. do you think the error message is "genuine" or could it be that my code
is just throwing an AV and this is the only error message ElevateDB can come
up with >>

No, the error is genuine.  It is most likely caused by switching the way the
filter and/or word generator works without repairing the table to update the
indexes accordingly.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< I tested out my word generator as best I could and it seems fine so I
tried dropping the index and adding back. That worked. So it looks to me now
as though somehow the index had become corrupted and the repair didn't sort
it out. >>

The repair completely rebuilds the indexes (and the table, for that matter)
from scratch, so I can't see how it could "miss" anything.

--
Tim Young
Elevate Software
www.elevatesoft.com