|
Joined: 7/30/2007
Posts: 501
|
|
|
I had a similar error initially and also a warning message that .xsl files were not allowed.
After allowing .xsl files (in host settings) it then failed for a different reason:
|
| Error loading files from temporary folder - see below |
| StartJob |
Starting Installation |
| Info |
Starting Installation - DNN_UserDefinedTable |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Creating backup of previous version - providers\dataproviders\sqldataprovider\03.03.07.sqldataprovider |
| Info |
Created |
| Info |
Executing 03.03.07.sqldataprovider |
| Info |
Start Sql execution: 03.03.07.sqldataprovider file |
| Info |
End Sql execution: 03.03.07.sqldataprovider file |
| Info |
Creating backup of previous version - providers\dataproviders\sqldataprovider\03.04.00.sqldataprovider |
| Info |
Created |
| Info |
Executing 03.04.00.sqldataprovider |
| Info |
Start Sql execution: 03.04.00.sqldataprovider file |
| Info |
End Sql execution: 03.04.00.sqldataprovider file |
| Info |
Creating backup of previous version - providers\dataproviders\sqldataprovider\03.05.00.sqldataprovider |
| Info |
Created |
| Info |
Executing 03.05.00.sqldataprovider |
| Info |
Start Sql execution: 03.05.00.sqldataprovider file |
| Info |
End Sql execution: 03.05.00.sqldataprovider file |
| Info |
Creating backup of previous version - providers\dataproviders\sqldataprovider\04.05.00.sqldataprovider |
| Info |
Created |
| Info |
Executing 04.05.00.sqldataprovider |
| Info |
Start Sql execution: 04.05.00.sqldataprovider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'PrivateField' in table 'nepof.UserDefinedFields' is specified more than once. 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.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE nepof.[UserDefinedFields] ADD PrivateField BIT DEFAULT 0 Not Null /* replace stored procedures with updated versions: */ IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'nepof.[UserDefinedTable_AddField]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE nepof.[UserDefinedTable_AddField] System.Data.SqlClient.SqlException: There is already an object named 'UserDefinedTable_AddField' in the database. 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.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE nepof.[UserDefinedTable_AddField] @ModuleId INT, @FieldTitle NVARCHAR(50), @BeforePos INT, @HelpText NVARCHAR(512), @Required BIT, @FieldType VARCHAR(20), @Default NVARCHAR(2000), @Visible BIT, @ShowOnEdit BIT, @Searchable BIT, @Private BIT, @InputSettings NVARCHAR(2000), @OutputSettings NVARCHAR(2000), @NormalizeFlag BIT, @ValidationRule NVARCHAR(512), @ValidationMessage NVARCHAR(512) AS DECLARE @InsPos INT /* find insert position and adjust field order of subsequent fields: */ SET @InsPos = (SELECT MAX(FieldOrder) AS MaxPos FROM nepof.UserDefinedFields WHERE ModuleID = @ModuleID GROUP BY ModuleID) + 1 IF @InsPos IS Null SET @InsPos = 1 IF @BeforePos Is Null SET @BeforePos = @InsPos IF @InsPos > @BeforePos BEGIN UPDATE [UserDefinedFields] SET FieldOrder = FieldOrder + 1 WHERE ModuleID = @ModuleID AND FieldOrder >= @BeforePos SET @InsPos = @BeforePos END INSERT INTO nepof.[UserDefinedFields] ( ModuleId, FieldTitle, HelpText, Required, FieldType, FieldOrder, [Default], Visible, ShowOnEdit, Searchable, PrivateField, InputSettings, OutputSettings, NormalizeFlag, ValidationRule, ValidationMessage ) VALUES ( @ModuleId, @FieldTitle, @HelpText, @Required, @FieldType, @InsPos, @Default, @Visible, @ShowOnEdit, @Searchable, @Private, @InputSettings, @OutputSettings, @NormalizeFlag, @ValidationRule, @ValidationMessage ) SELECT SCOPE_IDENTITY() |
| Info |
End Sql execution: 04.05.00.sqldataprovider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Installation Failed - DNN_UserDefinedTable |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |
|
|
I checked the mentioned table (above) UserDefinedFields, thought the error was suggesting that there were 2 columns of the same name, but this was not the case.
|
| |
|
|