Login

 

Got a question for us?

Get help from our team within 24 hours

Problems to access downloads, install or configure a module? Remarks, bugs or suggestions? We treat your request within 24 hours.

Thanks for your feedback!

HomeHomeExpert ModulesExpert ModulesFriendlier URLFriendlier URLDuplicate key errorDuplicate key error
Previous
 
Next
New Post
1/12/2011 12:55 PM
 

Hi,

When I want the following urls point to the same url and put them in the FUP store I get an error (manually)

http://www.domain.be/Default.aspx?tabid=130 and http://www.domain.be/Path/Pagename.aspx (both the same url)
and I want to point them to http://www.domain.be/shorterpath/Otherpagename.aspx
I get an error (see below)

So when I change a page title 2 or more times the older urls won't exist anymore or the new won't be added to the database?

DotNetNuke.Services.Exceptions.ModuleLoadException: An exception was caught during the execution of an action query: Violation of PRIMARY KEY constraint 'PK_FUPURLMAPPING'. Cannot insert duplicate key in object 'dbo.FupUrlMapping'. The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. ---> SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of an action query: Violation of PRIMARY KEY constraint 'PK_FUPURLMAPPING'. Cannot insert duplicate key in object 'dbo.FupUrlMapping'. The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_FUPURLMAPPING'. Cannot insert duplicate key in object 'dbo.FupUrlMapping'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() --- End of inner exception stack trace --- at SD.LLBLGen.Pro.ORMSupportClasses.UnitOfWork2.Commit(IDataAccessAdapter adapterToUse, Boolean autoCommit) at Aricie.DNN.Services.Url.FriendlyUrl.FriendlierUrlProviderStoreEdit.dsStore_PerformWork(Object sender, PerformWorkEventArgs2 e) --- End of inner exception stack trace ---

 
New Post
4/4/2011 9:07 AM
 

Hi,

This thread is posted a while ago and I did not receive any answer.
Could anyone take a look at this issue?

Thanks.

 
New Post
4/5/2011 8:47 AM
 

 Hi,

Sorry for delay, you can't add twice the same FriendlyUrl because there's an unique identifier.

Best regards,


Célian GASPARD
Développeur
Société de conseil et de service en informatique et systèmes d'information
 
New Post
4/7/2011 5:56 PM
 

We have released Friendlier URL Provider 2.1.4 and we recommand you to upgrade with it.
Don't forget to install the latest version of Aricie.Shared too.

Best regards,




Stéphane TETARD
ARICIE - Board member of DotNetNuke France
 
New Post
4/12/2011 3:23 PM
 

I installed the new version.

This is not affecting my problem? It is still not possible to add duplicate urls.
Which whould be a good feature.

 
New Post
4/13/2011 12:31 PM
 

 Hi,

you can't add twice the same FriendlyUrl because the rewrite url must be unique. If you have 2 real urls for one rewrite url, FUP rewrite engine can't know which one he shall choose for DNN load the right page.

I don't understand why you want to do that, you want to rewrite the url for one page only with an other name that the page name ? Can you explain me your use case, I would be able to help you to make an specific rule for that.

best regards,


Célian GASPARD
Développeur
Société de conseil et de service en informatique et systèmes d'information
 
New Post
5/27/2011 2:20 PM
 

Error with duplicate keys on changing titles inside DNN Article.

http://www.aricie.com/en/resources/support/friendlier-url/664/posts.aspx

 
Previous
 
Next
HomeHomeExpert ModulesExpert ModulesFriendlier URLFriendlier URLDuplicate key errorDuplicate key error