Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-19-2008, 09:40 AM
dasymington dasymington is online now
Registered User
 
Join Date: 06-15-2005
Posts: 287
Foreign Key Violation!

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.
Reply With Quote
  #2  
Old 01-19-2008, 10:00 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Re: Foreign Key Violation!

Quote:
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
Reply With Quote
  #3  
Old 01-20-2008, 04:08 AM
dasymington dasymington is online now
Registered User
 
Join Date: 06-15-2005
Posts: 287
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.
Attached Images
 
Reply With Quote
  #4  
Old 01-20-2008, 04:19 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
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
Reply With Quote
  #5  
Old 01-20-2008, 04:59 AM
dasymington dasymington is online now
Registered User
 
Join Date: 06-15-2005
Posts: 287
Yes, it works fine typing and pressing tab. I discovered this bug when experimenting with the problem in http://www.kinook.com/Forum/showthre...&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.
Reply With Quote
  #6  
Old 01-21-2008, 07:35 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
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.
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 07:31 PM.


Copyright © 1999-2023 Kinook Software, Inc.