Can't find the answer?
 

If you can't find the answer and don't have time...try out the Premium Support service.  Get personal attention and get the problem fixed by an expert.

 
Support Forums  
 
  iFinity Support Forum  DotNetNuke Modu...  Url Master  "Duplicate key found" Error
Previous Previous
 
Next Next
New Post 4/25/2008 11:27 AM
  AJ
34 posts
8th Level Poster


"Duplicate key found" Error 

I am getting this error in the Page Urls page:

Duplicate Key found. Key Name = SeqNum, Key Value = k9, Instance of iFinity.DNN.Modules.UrlMaster.Entities.TabRedirectInfo
And other things are starting to go wrong as a result.. I thought maybe that I had accidentally added the same URL twice, and deleted the last few entries I made.  Those entries do not show on the Page Urls page, but they are still in the ifty_TabRedirect table.

When I look at this table, I can see that there is one row that has a blank Url field.. ok I just found that page on Page Urls and it is showing a blank url there too.  I will delete the blank url and see if that helps. Page URLs should not let me enter a blank url .. u cant trust users :)

Alan

 
New Post 4/25/2008 11:31 AM
  AJ
34 posts
8th Level Poster


Re: "Duplicate key found" Error 
Modified By AJ  on 4/25/2008 11:31:27 AM)

I can add more redirects after deleting that blank url.  But there are still 5 redirects for tab 80 that are in the database, but not showing on Page Urls - how can I get those working?

Alan

 
New Post 4/25/2008 11:37 AM
  AJ
34 posts
8th Level Poster


Re: "Duplicate key found" Error 

Hmm, weird. Those 5 redirects that I deleted have now gone from the table, some time after I said delete. Oh well, back to entering my redirects.  I have about 300 - will that have performance implications?

Alan

 
New Post 4/25/2008 1:50 PM
  Bruce Chapman
365 posts
1st Level Poster


Re: "Duplicate key found" Error 

 AJ wrote

Hmm, weird. Those 5 redirects that I deleted have now gone from the table, some time after I said delete. Oh well, back to entering my redirects.  I have about 300 - will that have performance implications?

Alan

Alan

When you perform actions in the 'Page Urls' screen, you aren't actually saving to the database until you click 'Apply Changes'.  Up until then, the changes are held 'in session'.  This enables you to discard the changes if you wish.  You may have looked at the database table before you clicked on 'Apply Changes', which is why the deleted items would still have been there.

WIth regards to the 'blank' url - point noted, I will log that as a bug.

On performance - each redirect is held in a cached object while the system is running.  Each redirect entry holds approximately 20-25 bytes, so x 300, you are adding ~6kb to the cache size.  It's unlikely to affect performance much on a decent server.

Out of interest, why so many redirects? (I'm just trying to get a feel for how people use the software)

 
New Post 5/7/2008 9:12 PM
  AJ
34 posts
8th Level Poster


Re: "Duplicate key found" Error 

I have this error again - and I cant add more redirects.  I've checked the table for duplicates, there are none.  I've restarted the website, but still have this problem.. what to do?

 
Previous Previous
 
Next Next
  iFinity Support Forum  DotNetNuke Modu...  Url Master  "Duplicate key found" Error
   
Support Guidelines.. Please read before posting Maximize