I just installed your DSLocalizator module on a production server, and the installation failed.

I am running a DNN installation in a restricted mode (The SQL user I use to connect to the db is NOT dbowner).

Fir DNN to work you stilI need to specify this user as dbo in the settings of the web.config file.

The problem is that the SQL script of your module references tables like {databaseowner}.sysobjects. This causes exceptions because my user is not the owner of this table. The owner of this table in my DNN installation is dbo. And the owner of other tables is my restricted user.

I suppose that this would work if I change the references of {databaseowner} to dbo in your SQL scripts, but I would appreciate it if you could confirm this.

Any help would be appreciated.

regards

I know very well the standard way to create those scripts are using these placeholders. And I'm not saying not to use them. I think the problem is the same as the one gvilas mentions in this post.

The issue is that when calling system tables like sysobject I need to be using something like dbo.sysobjects and when calling or creating other tables I do it with restricteduser.whatevertable.

Does this module require changes to the sysobjects table? Because if it does I will probably run into problems installing it.

Can I simply change the {databaseowner} tags in those places where system tables are called? Will this work?

Regards

I managed to install the module by changing in the sql scripts all references of {databaseowner}sysobjects to dbo.sysobjects.

I have also been able to activate the Install Helper options.

But when I try to change the "General Options" I get the following error:

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) 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) --- Fin del seguimiento de la pila de la excepción interna ---

What can this be?

Regards