Foreign Key Violation!

[dasymington]

Steps to reproduce this error message:

1. Insert a child item based on a template with a form.
2. Start typing (in lower case) into a form field for an auto-complete attribute (eg. "al").
3. When the field highlights a previous value in the list (eg. "Alloa"), click the undo button.

Error message is produced:

"Error loading item(s): Foreign Key Violation! ItemKeyword table references missing row in Item table."

Although there's an OK button, the error keeps popping up until you kill UR with task manager.

[armsys]

Originally posted by dasymington
Steps to reproduce this error message:
3. When the field highlights a previous value in the list (eg. "Alloa"), click the undo button.

Hi dasymington,
Your description is rather vague. Can you show us a screen shot?
Thanks.
Armstrong

[dasymington]

Armstrong,

I've attached a screenshot to try and make this clearer. In the location field I've only typed "al". As you can see, it's brought up a previous value of "Alloa" for auto-completion. If I now click the undo button the error reported above occurs.

[armsys]

dasymington,
Thanks for your enhanced clarity.
I'm sorry I fail to reproduce your UR coma state.
Have you simply typed Alloa (a burgh in Scotland) and press TAB? Any problem? Have you run "Compact and Compact...", the first step in UR emergency routine to resurrect your urd's health?
Armstrong

[dasymington]

Yes, it works fine typing and pressing tab. I discovered this bug when experimenting with the problem in http://www.kinook.com/Forum/showthread.php?s=&threadid=3424

It's not causing me a problem because I very rarely click undo iin the middle of entering a value in a field. But it's obviously something that UR shouldn't do and the developers might want to do something about it at some point.

[kinook]

I was able to reproduce this error and we'll add it to our list to fix. I was able to close the database and then exit UR normally after dismissing the error message.