Using DNN3.1.1 on host (?)
I am having a strange error when attempting to upload a module on my host site. Everything else in the .zip/.dnn/install works fine except for some failures reported when handling the nn.nn.nn.SqlDataProvider ... I have tracked this problem to the fact that the sql procedure text displayed in the installer page has some (if not all) '+' symbols removed.
For example ...
Text in a 01.00.04.SQLDataProvider file (pre zipping) ...
/************************************************************/
/***** Create DNNUsers View *****/
/************************************************************/
CREATE VIEW {databaseOwner}npcom_DNNUsers
AS
SELECT UserID, (FirstName + ' ' + LastName) AS FullName, UserName
FROM {databaseOwner}{objectQualifier}Users
GO
Gives the following error string ....
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 6: Incorrect syntax near ' '. 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, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** Create DNNUsers View *****/ /************************************************************/ CREATE VIEW dbo.npcom_DNNUsers AS SELECT UserID, (FirstName ' ' LastName) AS FullName, UserName FROM dbo.Users