Margaret, This is the result of a collation problem, and won't manifest unless you add more then 26 terms to a node.

In DB Config check the Value under System>Pattern.Alphas.List. The value should be "ABCDEFGHIJKLMNOPQRSTUVWXYZ" instead of "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" (without the quotation marks).

Changing the Pattern.Alphas.List will prevent anymore errors from occurring, but you will need to go into the back end to fix the thesaurus entries which are throwing the error. Gallery Systems should be able to help with that, or you can contact me directly.

~Chad

On Fri, Jan 31, 2014 at 5:38 PM, Margaret Bullock <[log in to unmask]> wrote:

Recently our geography thesaurus crashed while someone was adding a new term and ever since then we get the following error message whenever we open it

Key is not unique in collection

[Error: -2147024809]

[FillNextLevel.frmMain]

and it also won't less us use at all the listings associated with the term it was on when it crashed. I've emailed TMS Tech Support but thought I would also check with the listserv to see if anyone had a similar problem.

Thanks

Margaret Bullock

Margaret Bullock | TACOMA ART MUSEUM

Curator of Collections and Special Exhibitions

253.272.4258 x 3019

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj

You will receive a confirmation that your subscription has been removed.