OK I figured the rest except this one problem. during clean installation I get the following 2 errors. All other SQL executions are ok. I wonder if instead of ' I should use " Do you know, anybody else has this problem.
Thanks
| Info |
Executing 01.00.17.SqlDataProvider |
| StartJob |
Start Sql execution: 01.00.17.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 27: Incorrect syntax near '@tabid'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE igormtv_portal._Delisoft_TabLocalization_Replacements_List @PortalId int, @TabId nvarchar(20), @LocaleKey nvarchar(20), @Disabled bit AS select ReplacementId, PortalId, ReplacementName, LanguagesIncluded, TabsIncluded, SearchFor, ReplaceWith, ReplacementOrder, Disabled from _Delisoft_TabLocalization_Replacements where PortalId = @portalid and (@tabId is null or tabsincluded like '%' @tabid '%') and (@localekey is null or languagesincluded like '%' @localekey '%') and (@Disabled is null or disabled = @Disabled) order by ReplacementOrder |
| EndJob |
End Sql execution: 01.00.17.SqlDataProvider file |
Info Executing 01.00.20.SqlDataProvider
StartJob Start Sql execution: 01.00.20.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 27: Incorrect syntax near '@tabid'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE igormtv_portal._Delisoft_TabLocalization_Replacements_List @PortalId int, @TabId nvarchar(20), @LocaleKey nvarchar(20), @Disabled bit AS select ReplacementId, PortalId, ReplacementName, LanguagesIncluded, TabsIncluded, SearchFor, ReplaceWith, ReplacementOrder, Disabled from _Delisoft_TabLocalization_Replacements where PortalId = @portalid and (@tabId is null or tabsincluded like '%' @tabid '%' or tabsincluded is null) and (@localekey is null or languagesincluded like '%' @localekey '%' or languagesincluded is null) and (@Disabled is null or disabled = @Disabled or disabled is null) order by ReplacementOrder
EndJob End Sql execution: 01.00.20.SqlDataProvider file