Register | Login
Tuesday, May 22, 2012
  Search
 Discussion Forums at Locopon's Minimize
 
Forum / ForosForum / ForosModules/ModulosModules/ModulosDSLocalizatorDSLocalizatorThe INSERT statement conflicted with the FOREIGN KEY constraint "FK_Delisoft_TabLocalization_Tabs"..The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Delisoft_TabLocalization_Tabs"..
Previous Previous
 
Next Next
New Post
 8/14/2006 4:47 AM
 
Hello guys, Hello Locopon,

Since some time I did not change anything in my localisation settings, because I did not add any page for a while. Now that I try to hide a new page for German and show it for Frensh I get the following error when updating the TabLocalisation for the specific pages :

     Erreur: DSLocalizator - Tab Localization inconnue.
DotNetNuke.Services.Exceptions.ModuleLoadException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Delisoft_TabLocalization_Tabs". The conflict occurred in database "mydb", table "dbo.Tabs", column 'TabID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Delisoft_TabLocalization_Tabs". The conflict occurred in database "mydb", table "dbo.Tabs", column 'TabID'. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at Delisoft.DNN.Modules.DSLocalizator.Data.SqlDataProvider.UpdateTabLocalization(Int32 tabId, String localeKey, String tabName, String tabTitle, String tabDescription, String RedirectTo, Int32 requireSSL, Int32 isVisible, Int32 disableLink, String Keywords, String skinSrc, String containerSrc, String url, String iconFile, Int32 SqlViewState, Int32 useWhiteSpaceRemover, String adminSkinSrc, String adminContainerSrc, String logoFile) at Delisoft.DNN.Modules.DSLocalizator.Business.TabLocalizationController.Update(TabLocalizationInfo objTabLocalization) at Delisoft.DNN.Modules.DSLocalizator.DSTabLocalizatorTabs.c() --- End of inner exception stack trace ---

Any idea what I might do to get this fixed?

Thank you very much for any help!

Regards,
Fabian
New Post
 8/14/2006 5:21 AM
 
An additional information to this problem : it only occures with new pages, with old pages there is no conflict.

Regards,
Fabian
New Post
 8/14/2006 5:27 AM
 
Oh - and I forgot to say : DNN 4.3.1 and Delisoft.DSLocalizator.DNN3.01.00.20-PA

Regards,
Fabian
New Post
 8/14/2006 5:36 AM
 
Silly me,
I changed the connection string in the web.config but forgot to change the string in the appSettings...

Excuse me guys.

Regards,
Fabian
New Post
 8/14/2006 7:24 AM
 

B.T.W. I suggest you to upgrade to 4.3.4.

4.3.1 is beta and has a lot of bugs and not included all the migration scripts for your DNN.

Previous Previous
 
Next Next
Forum / ForosForum / ForosModules/ModulosModules/ModulosDSLocalizatorDSLocalizatorThe INSERT statement conflicted with the FOREIGN KEY constraint "FK_Delisoft_TabLocalization_Tabs"..The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Delisoft_TabLocalization_Tabs"..