Failure

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'IPAddr' in table 'dbo.ww2_SWIRLChatroom' is specified more than once. 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) /** ALTER Table to include IPAddr **/ if not exists (select 1 from INFORMATION_SCHEMA.Columns where table_name = 'SWIRLChatroom' and column_name='IPAddr') BEGIN ALTER TABLE dbo.[ww2_SWIRLChatroom] ADD IPAddr [char] (15) NULL END System.Data.SqlClient.SqlException: Invalid object name 'tabmodulesettings'. 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) /** FIX "old" logChat TabModuleSettings (no longer used) **/ DELETE from tabmodulesettings where settingname='logChat';