wierd issue doing a new install

Mar 24, 2013 at 11:42 AM
StartJob Starting Installation
Info Starting Installation - Active Forums
Info Starting Installation - Module
Info Module registered successfully - Active Forums
Info Component installed successfully - Module
Info Starting Installation - Assembly
Info Assembly registered - bin\DotNetNuke.Modules.ActiveForums.dll
Info Creating backup of previous version - bin\DotNetNuke.Modules.ActiveForums.dll
Info Created - bin\DotNetNuke.Modules.ActiveForums.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - License.txt
Info Created - License.txt
Info Creating backup of previous version - ReleaseNotes.txt
Info Created - ReleaseNotes.txt
Info Component installed successfully - File
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - 04.00.00.SqlDataProvider
Info Created - 04.00.00.SqlDataProvider
Info Executing 04.00.00.SqlDataProvider
Info Start Sql execution: 04.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Ambiguous column name 'PortalId'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) in C:\wwwLP\Community\Library\Data\SqlDataProvider.cs:line 138 ClientConnectionId:f5acffb0-61dc-43df-979d-36da2059176c CREATE PROCEDURE dbo.[activeforums_UserProfiles_Stats] @PortalId int, @Interval int AS DECLARE @Guests int SET @Guests = (SELECT Count() FROM dbo.AnonymousUsers WHERE PortalId = @PortalId and (DATEDIFF(mi, LastActiveDate, GETDATE()) < @Interval)) DECLARE @Members int SET @Members = (SELECT Count() FROM dbo.activeforums_UserProfiles WHERE PortalId = @PortalId AND DATEDIFF(mi, DateLastActivity, GETDATE()) < @Interval) DECLARE @MembersTotal int SET @MembersTotal = (SELECT COUNT(*) FROM dbo.Users AS U INNER JOIN dbo.UserPortals AS P ON U.UserID = P.UserId WHERE PortalId = @PortalId AND Authorised = 1) SELECT IsNull(@Guests,0) as Guests, IsNull(@Members,0) as Members, IsNull(@MembersTotal, 0) as MembersTotal
Info End Sql execution: 04.00.00.SqlDataProvider file
Mar 24, 2013 at 5:03 PM
That's an issue I've never run into. Which version are you trying to install?
Mar 24, 2013 at 5:04 PM
And what version of DNN?