Rolled it back. Did as you said regarding the Chat module and the XML and then when I upgraded received these errors:
(from the error log)
----
00:00:13.296 - Executing Application Upgrades: 05.00.00 Success
System.Data.SqlClient.SqlException: The multi-part identifier "dbo.mss_Portals.PortalID" could not be bound.
The multi-part identifier "dbo.mss_Portals.portalid" could not be bound.
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)
----
/* script to fix issue with errorneous administratorroleid values*/
DECLARE @PortalID int
DECLARE @AdministratorRoleId int
--Iterate through each portal
DECLARE Portals_Cursor CURSOR FOR
SELECT PortalID,AdministratorRoleId
FROM dbo.mss_Portals
OPEN Portals_Cursor
--get first
FETCH NEXT FROM Portals_Cursor
into @PortalID,@AdministratorRoleId
WHILE @@FETCH_STATUS = 0
BEGIN
if @AdministratorRoleId=-1 or @AdministratorRoleId not in (select roleid from dbo.mss_userroles as ur inner join dbo.mss_userportals as up on ur.userid=up.userid where up.portalid=@portalid)
update portals set AdministratorRoleId =
(select roleid from dbo.mss_Roles as r where
r.PortalID =dbo.mss_Portals.PortalID and RoleName = 'Administrators' and dbo.mss_Portals.portalid=@portalid) where portalid=@portalid
FETCH NEXT FROM Portals_Cursor
into @PortalID, @AdministratorRoleId
END
CLOSE Portals_Cursor
----
Still having problems getting into the site. (I have to run "
http://www.softich.com/install/instal..." almost everytime) to be able to log in. Also, the SMTP Mial test fails.
Please advise. Thanks.