Connexion

 
 

Une question sur nos modules?

Notre équipe vous répond sous 24 heures

Accès aux modules, bugs, demandes d'évolutions... Toutes vos questions sont les bienvenues sur cet espace d'échange ouvert à tous nos inscrits! Nous essayons de traiter vos demandes dans les 24h.

Merci de votre confiance!

HomeHomeExpert ModulesExpert ModulesFriendlier URLFriendlier URLChanging titles: Cannot insert duplicate key in object Changing titles: Cannot insert duplicate key in object 'dbo.FupUrlMapping'.
Précédente
 
Suivante
Nouveau message
27/05/2011 14:20
 

Hi,

When changing titles via DNN Article the following errors happen:

Logging in on the websites was not possible.

Restart of SQL server made everythign working again.

This is a big issue.

InnerException: Following Query raised an exception: Query: INSERT INTO [dbo].[FupUrlMapping] ([FriendlyUrl], [RealUrl], [CreatedDate]) VALUES (@FriendlyUrl, @RealUrl, @CreatedDate) Parameter: @FriendlyUrl : String. Length: 255. Precision: 0. Scale: 0. Direction: Input. Value: "http://www.jongerengids.be/large/admin/artikel-admin/article-edit/dnnarticle/ItemID/124/rtab/176.aspx". Parameter: @RealUrl : String. Length: 255. Precision: 0. Scale: 0. Direction: Input. Value: "http://www.jongerengids.be/large/Default.aspx?tabid=181&ItemID=124&moduleid=481&rtab=176". Parameter: @CreatedDate : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 27/05/2011 13:49:06.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.ApplicationException: Following Query raised an exception: Query: INSERT INTO [dbo].[FupUrlMapping] ([FriendlyUrl], [RealUrl], [CreatedDate]) VALUES (@FriendlyUrl, @RealUrl, @CreatedDate) Parameter: @FriendlyUrl : String. Length: 255. Precision: 0. Scale: 0. Direction: Input. Value: "http://www.jongerengids.be/large/admin/artikel-admin/article-edit/dnnarticle/ItemID/124/rtab/176.aspx". Parameter: @RealUrl : String. Length: 255. Precision: 0. Scale: 0. Direction: Input. Value: "http://www.jongerengids.be/large/Default.aspx?tabid=181&ItemID=124&moduleid=481&rtab=176". Parameter: @CreatedDate : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 27/05/2011 13:49:06. ---> 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.Data.FupPersistenceJob.Commit(DataAccessAdapterBase objAdapter) at Aricie.DNN.Services.Url.FriendlyUrl.Data.DataProvider.CommitToDB() --- End of inner exception stack trace ---

InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlInternalConnectionTds.get_IsLockedForBulkCopy
StackTrace:
Message: System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.SqlClient.SqlInternalConnectionTds.get_IsLockedForBulkCopy() at System.Data.SqlClient.SqlInternalTransaction.Rollback() at System.Data.SqlClient.SqlTransaction.Rollback() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.Rollback() at SD.LLBLGen.Pro.ORMSupportClasses.UnitOfWork2.Commit(IDataAccessAdapter adapterToUse, Boolean autoCommit) at Aricie.DNN.Services.Url.FriendlyUrl.Data.FupPersistenceJob.Commit(DataAccessAdapterBase objAdapter) at Aricie.DNN.Services.Url.FriendlyUrl.Data.DataProvider.CommitToDB()

 

 

 

 
Nouveau message
27/05/2011 15:57
 

Hi,

We are looking about your issue. You'll get a feedback ASAP.

Best regards,


Célian GASPARD
Développeur
Société de conseil et de service en informatique et systèmes d'information
 
Nouveau message
06/06/2011 18:09
 

Hi,

We're working on a new version of Aricie.FriendlierUrlProvider. We should release it during this week.

Best regards,


Célian GASPARD
Développeur
Société de conseil et de service en informatique et systèmes d'information
 
Nouveau message
14/06/2011 09:50
 

Hi,

the new version of Aricie.FriendlierUrlProvider has been released on our website. You can find it in the download section.

Best Regards,


Célian GASPARD
Développeur
Société de conseil et de service en informatique et systèmes d'information
 
Précédente
 
Suivante
HomeHomeExpert ModulesExpert ModulesFriendlier URLFriendlier URLChanging titles: Cannot insert duplicate key in object Changing titles: Cannot insert duplicate key in object 'dbo.FupUrlMapping'.