As I reported in my previous post, I'm encountering some problems when installing DSLocalizator.

In particular, when the installation starts processing the SqlDataProvider files, exceptions arises, even if the installation seems to end in a successfull way. However, if I insert the module on a page, install the hack, the General Options are not working. The following exception arises: Error: DSLocalizator - General Options is not available at this moment.

Can someone provide me with some hints to solve this problem?

When the installation starts processing the SqlDataProvider files, exceptions arise:

for example here is the exception for the first file

Inizio lavoro Inizio esecuzione SQL: 01.00.00.SqlDataProvider file Operazione fallita Nell'esecuzione SQL risultano le seguenti eccezioni: System.Data.SqlClient.SqlException: Invalid object name 'MSSqlxxxxx.sysobjects'. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

Here the info you are requesting:

• DNN version 
  The DotNetNuke application version you are running
  04.07.00
• DSLocalizator version 01.00.23
• SQL server 2005
• IIS 6

I cannot find any log directly from the module. Below you can read the entire error message I receive in DNN during installation for 01.00.00.SqlDataProvider file (sorry, it's very long). Note that the same happens for the following files: 01.00.01.SqlDataProvider, 01.00.03.SqlDataProvider,  01.00.06.SqlDataProvider,  01.00.07.SqlDataProvider,  01.00.08.SqlDataProvider,  01.00.09.SqlDataProvider,  01.00.10.SqlDataProvider, 01.00.11.SqlDataProvider, 01.00.12.SqlDataProvider, 01.00.13.SqlDataProvider, 01.00.15.SqlDataProvider, 01.00.16.SqlDataProvider, 01.00.17.SqlDataProvider, 01.00.20.SqlDataProvider.

The final message is that installation has been successful. However, if I insert the module on a page, install the hack, the General Options are not working and the exception reported below arises.

///////////////////////////// Error msg for 01.00.00.SqlDataProvider file

Inizio lavoro Inizio esecuzione SQL: 01.00.00.SqlDataProvider file Operazione fallita Nell'esecuzione SQL risultano le seguenti eccezioni: System.Data.SqlClient.SqlException: Invalid object name 'MSSqlxxxxx.sysobjects'. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SQLDataProvider *****/ /***** SqlDataProvider *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for MSSqlxxxxx. and *****/ /***** *****/ /************************************************************/ if exists (select * from MSSqlxxxxx.sysobjects where id = object_id(N'MSSqlxxxxx.Delisoft_TabLocalization') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table MSSqlxxxxx.Delisoft_TabLocalization System.Data.SqlClient.SqlException: Invalid object name 'MSSqlxxxxx.sysobjects'. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from MSSqlxxxxx.sysobjects where id = object_id(N'MSSqlxxxxx.Delisoft_TabLocalizationDelete') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure MSSqlxxxxx.Delisoft_TabLocalizationDelete System.Data.SqlClient.SqlException: Invalid object name 'MSSqlxxxxx.sysobjects'. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from MSSqlxxxxx.sysobjects where id = object_id(N'MSSqlxxxxx.Delisoft_TabLocalizationGet') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure MSSqlxxxxx.Delisoft_TabLocalizationGet System.Data.SqlClient.SqlException: Invalid object name 'MSSqlxxxxx.sysobjects'. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from MSSqlxxxxx.sysobjects where id = object_id(N'MSSqlxxxxx.Delisoft_TabLocalizationGetByTab') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure MSSqlxxxxx.Delisoft_TabLocalizationGetByTab System.Data.SqlClient.SqlException: Invalid object name 'MSSqlxxxxx.sysobjects'. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from MSSqlxxxxx.sysobjects where id = object_id(N'MSSqlxxxxx.Delisoft_TabLocalizationUpdate') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure MSSqlxxxxx.Delisoft_TabLocalizationUpdate Fine lavoro
Fine esecuzione SQL: 01.00.00.SqlDataProvider file

//////////////////// Exception after installation

Error: DSLocalizator - General Options is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at Delisoft.DNN.Modules.DSLocalizator.Data.SqlDataProvider.UpdateTabLocalization_Options(Int32 portalId, Int32 useSQLViewState, Boolean useTabLocalization, Boolean useModuleLocalization, Boolean enableSearch, String SqlViewStateIp, Boolean tabPreviewEnabled, Boolean UsePortalSettingsLocalization, Boolean SelectorNotUsingCookie, Boolean SelectorNotUsingParam, Boolean SelectorNotUsingBrowser, Boolean SelectorNotUsingGeoIP, String SelectorParamText, Boolean SQLViewStatePerPage, String SelectorCookieName, String LocaleDetectionOrder, Boolean UseWhiteSpaceRemover, Boolean useLocaleTranslation, String localeTranslationRules, Boolean selectorParamAutoreplaceURL, Boolean selectorParamAutoreplaceSOLPART, String portalAliasDefaults, String customNames, Boolean adjustSqlSession, Int32 antiSessionExpiration, Int32 antiSessionExpirationTime) at Delisoft.DNN.Modules.DSLocalizator.Business.TabLocalization_OptionsController.Update(TabLocalization_OptionsInfo objTabLocalization_Options) at Delisoft.DNN.Modules.DSLocalizator.DSLocalizatorOptions.b(Object A_0, EventArgs A_1) --- End of inner exception stack trace ---