Aricie
Intégrateur de vos solutions d'avenir
DNN Community Forums

Duplicate key error

Sort:
You are not authorized to post a reply.
Page 1 of 212 > >>
Author
Messages


rsiera











New Member



Posts:




New Member



    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/shor...h/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 ---



    rsiera











    New Member



    Posts:




    New Member



      Hi,

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

      Thanks.



      Deleted User











      New Member



      Posts:




      New Member



         Hi,

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

        Best regards,



        Stéphane TETARD











        New Member



        Posts:




        New Member



          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,



          rsiera











          New Member



          Posts:




          New Member



            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.

            You are not authorized to post a reply.
            Page 1 of 212 > >>