|
| Event Installation Error (United States) |
|
|
Just found it this is a version that fixes this error for 5.2.3 www.frankandlola.com/LinkClick.aspx
|
This is a Error installation in DNN 5.2.3. The My Events Section is not showing up in the module defininitions. So you can not see or edit the events due to the error. For some reason it will not load in DNN 5.2.3
|
| |
| StartJob |
Starting Installation |
| Info |
Starting Installation - Smart-Thinker - Events |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Folder Created - d:\hosting\salvig67\salsclubdb\DesktopModules\Smart-Thinker - Events\ |
| Info |
Created - 01.00.00.SqlDataProvider |
| Info |
Executing 01.00.00.SqlDataProvider |
| Info |
Start Sql execution: 01.00.00.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUser_C @PortalID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [EventDurationID], [InformalLocation], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND SE.[PortalID] = @PortalID ORDER BY [DateStart] DESC |
| Info |
End Sql execution: 01.00.00.SqlDataProvider file |
| Info |
Created - 01.00.01.SqlDataProvider |
| Info |
Executing 01.00.01.SqlDataProvider |
| Info |
Start Sql execution: 01.00.01.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUser_C @PortalID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [EventDurationID], [InformalLocation], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName, [PrivateGuestList], [EventInviteTypeID] FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND SE.[PortalID] = @PortalID ORDER BY [DateStart] DESC |
| Info |
End Sql execution: 01.00.01.SqlDataProvider file |
| Info |
Created - 04.03.01.SqlDataProvider |
| Info |
Executing 04.03.01.SqlDataProvider |
| Info |
Start Sql execution: 04.03.01.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUserAndModuleID_C @ModuleID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [EventDurationID], [InformalLocation], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName, [PrivateGuestList], [EventInviteTypeID] FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND [ModuleID] = @ModuleID ORDER BY [DateStart] DESC |
| Info |
End Sql execution: 04.03.01.SqlDataProvider file |
| Info |
Created - 04.03.02.SqlDataProvider |
| Info |
Executing 04.03.02.SqlDataProvider |
| Info |
Start Sql execution: 04.03.02.SqlDataProvider file |
| Info |
End Sql execution: 04.03.02.SqlDataProvider file |
| Info |
Created - 04.03.03.SqlDataProvider |
| Info |
Executing 04.03.03.SqlDataProvider |
| Info |
Start Sql execution: 04.03.03.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUserAndModuleID_C @ModuleID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [InformalLocation], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName, [PrivateGuestList], [EventInviteTypeID], RSVP0Text, RSVP1Text, RSVP2Text, RSVP3Text, RSVP4Text, RSVPNotInvitedText, RSVPNotLoggedInText FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND [ModuleID] = @ModuleID ORDER BY [DateStart] DESC System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUser_C @PortalID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [InformalLocation], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName, [PrivateGuestList], [EventInviteTypeID], RSVP0Text, RSVP1Text, RSVP2Text, RSVP3Text, RSVP4Text, RSVPNotInvitedText, RSVPNotLoggedInText FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND SE.[PortalID] = @PortalID ORDER BY [DateStart] DESC |
| Info |
End Sql execution: 04.03.03.SqlDataProvider file |
| Info |
Created - 04.03.04.SqlDataProvider |
| Info |
Executing 04.03.04.SqlDataProvider |
| Info |
Start Sql execution: 04.03.04.SqlDataProvider file |
| Info |
End Sql execution: 04.03.04.SqlDataProvider file |
| Info |
Created - 04.03.05.SqlDataProvider |
| Info |
Executing 04.03.05.SqlDataProvider |
| Info |
Start Sql execution: 04.03.05.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUserAndModuleID_C @ModuleID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [InformalLocation], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName, [PrivateGuestList], [EventInviteTypeID], RSVP0Text, RSVP1Text, RSVP2Text, RSVP3Text, RSVP4Text, RSVPNotInvitedText, RSVPNotLoggedInText FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND [ModuleID] = @ModuleID ORDER BY [DateStart] DESC System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUser_C @PortalID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [InformalLocation], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName, [PrivateGuestList], [EventInviteTypeID], RSVP0Text, RSVP1Text, RSVP2Text, RSVP3Text, RSVP4Text, RSVPNotInvitedText, RSVPNotLoggedInText FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND SE.[PortalID] = @PortalID ORDER BY [DateStart] DESC |
| Info |
End Sql execution: 04.03.05.SqlDataProvider file |
| Info |
Created - 04.03.06.SqlDataProvider |
| Info |
Executing 04.03.06.SqlDataProvider |
| Info |
Start Sql execution: 04.03.06.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUserAndModuleID_C @ModuleID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [LocationFlag], [LocationName], [LocationURL], [Street], [City], [Country], [Region], [PostCode], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName, [PrivateGuestList], [EventInviteTypeID], RSVP0Text, RSVP1Text, RSVP2Text, RSVP3Text, RSVP4Text, RSVPNotInvitedText, RSVPNotLoggedInText FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND [ModuleID] = @ModuleID ORDER BY [DateStart] DESC System.Data.SqlClient.SqlException: Ambiguous column name 'CreatedByUserID'. 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 dbo.SmartThinker_EventGetByCreatedUser_C @PortalID int, @UserID int /* Author: Rodney Joyce Date created: 17/4/05 Purpose: Gets all events an all associated data created by this user Notes: If -2 is passed in then it assumes you are admin and returns ALL events (-1 is not logged in) Updates: Only get the evetnts for the passed in Portal Copyright: Smart-Thinker 2005 */ AS SELECT SE.[EventID], SE.[PortalID], [EventName], [EventDescription], [EventCategoryID], [EventTypeID], [DateStart], [DateEnd], [StartTime], [ArrivalTime], [EndTime], [TimeComments], [LocationFlag], [LocationName], [LocationURL], [Street], [City], [Country], [Region], [PostCode], [Location], [ClosestLandmark], [LocationDirections], [EventStatusID], [DressCodeID], [Website], [MapLink], [TotalCost], [CostCovers], [LastShownDate], [ViewCounter], [FinalComments], [ApprovalStatusID], [ApprovedByUserID], [CreatedByUserID], [ChangedByUserID], [ApprovedDate], SE.[ChangedDate], SE.[CreatedDate], L.Text AS EventCategory, L1.Text AS EventStatus, L2.Text AS ApprovalStatusName, [PrivateGuestList], [EventInviteTypeID], RSVP0Text, RSVP1Text, RSVP2Text, RSVP3Text, RSVP4Text, RSVPNotInvitedText, RSVPNotLoggedInText FROM SmartThinker_Event SE LEFT JOIN Lists L ON L.Value = SE.EventCategoryID AND L.ListName = 'SmartThinker_EventCategory' LEFT JOIN Lists L1 ON L1.Value = SE.EventStatusID AND L1.ListName = 'SmartThinker_EventStatus' LEFT JOIN Lists L2 ON L2.Value = SE.ApprovalStatusID AND L2.ListName = 'SmartThinker_ApprovalStatus' WHERE (SE.CreatedByUserID = @UserID OR @UserID = -2) AND SE.[PortalID] = @PortalID ORDER BY [DateStart] DESC |
| Info |
End Sql execution: 04.03.06.SqlDataProvider file |
| Info |
Created - 04.03.07.SqlDataProvider |
| Info |
Executing 04.03.07.SqlDataProvider |
| Info |
Start Sql execution: 04.03.07.SqlDataProvider file |
| Info |
End Sql execution: 04.03.07.SqlDataProvider file |
| Info |
Created - Uninstall.SqlDataProvider |
| Info |
Finished Sql execution |
| Info |
Component installed successfully - Script |
| Info |
Starting Installation - Module |
| Info |
Module registered successfully - Smart-Thinker - Events |
| Info |
Component installed successfully - Module |
| Info |
Starting Installation - Assembly |
| Info |
Assembly registered - bin\SmartThinker.DNN.Modules.Events.dll |
| Info |
Created - bin\SmartThinker.DNN.Modules.Events.dll |
| Info |
Assembly registered - bin\SmartThinker.DNN.Modules.Events.SqlDataProvider.dll |
| Info |
Created - bin\SmartThinker.DNN.Modules.Events.SqlDataProvider.dll |
| Info |
Assembly already registered - bin\SmartThinker.DNN.Modules.ModuleSecurity.dll |
| Info |
Component installed successfully - Assembly |
| Info |
Starting Installation - File |
| Info |
Folder Created - d:\hosting\salvig67\salsclubdb\DesktopModules\Smart-Thinker - Events\Controls |
| Info |
Created - Controls\UserSearch.ascx |
| Info |
Created - Controls\UserSearchSettings.ascx |
| Info |
Folder Created - d:\hosting\salvig67\salsclubdb\DesktopModules\Smart-Thinker - Events\Documentation |
| Info |
Created - Documentation\Smart_Thinker_Events.chm |
| Info |
Created - Documentation\License.txt |
| Info |
Created - Documentation\Module Config Guide.doc |
| Info |
Created - Documentation\Version History.txt |
| Info |
Folder Created - d:\hosting\salvig67\salsclubdb\DesktopModules\Smart-Thinker - Events\Licenses\04.03.07 |
| Info |
Created - Licenses\04.03.07\SmartThinker.DNN.Modules.Events.LIC |
| Info |
Created - module.css |
| Info |
Folder Created - d:\hosting\salvig67\salsclubdb\DesktopModules\Smart-Thinker - Events\Images |
| Info |
Created - Images\Filter.gif |
| Info |
Created - Images\NoPhoto.gif |
| Info |
Created - Images\Offline.gif |
| Info |
Created - Images\Online.gif |
| Info |
Created - Images\icon_pm_message.gif |
| Info |
Created - Images\Delete.gif |
| Info |
Created - Images\InvitesUsers.gif |
| Info |
Created - Images\RSVP.gif |
| Info |
Created - Images\NewEvent.gif |
| Info |
Created - Images\UpdateEvent.gif |
| Info |
Created - Images\Step14.gif |
| Info |
Created - Images\Step24.gif |
| Info |
Created - Images\Step34.gif |
| Info |
Created - Images\Step44.gif |
| Info |
Created - Images\ical.gif |
| Info |
Created - Images\AddToGroup.gif |
| Info |
Created - Images\AddToEvent.gif |
| Info |
Created - Images\NoPhotoS.gif |
| Info |
Created - Images\LocOnline.png |
| Info |
Created - Images\LocHome.png |
| Info |
Created - EventAddGroup.ascx |
| Info |
Created - EventAddExternal.ascx |
| Info |
Created - EventAddRole.ascx |
| Info |
Created - EventAddUser.ascx |
| Info |
Created - EventEdit.ascx |
| Info |
Created - EventInvitesEdit.ascx |
| Info |
Created - EventRSVPEdit.ascx |
| Info |
Created - EventsView.ascx |
| Info |
Created - MyEventsView.ascx |
| Info |
Created - SettingsEventsView.ascx |
| Info |
Created - SettingsMyEventsView.ascx |
| Info |
Created - EventRSS.aspx |
| Info |
Folder Created - d:\hosting\salvig67\salsclubdb\DesktopModules\Smart-Thinker - Events\App_LocalResources |
| Info |
Created - App_LocalResources\SharedResources.resx |
| Info |
Created - App_LocalResources\EventAddGroup.ascx.resx |
| Info |
Created - App_LocalResources\EventAddExternal.ascx.resx |
| Info |
Created - App_LocalResources\EventAddRole.ascx.resx |
| Info |
Created - App_LocalResources\EventAddUser.ascx.resx |
| Info |
Created - App_LocalResources\EventEdit.ascx.resx |
| Info |
Created - App_LocalResources\EventInvitesEdit.ascx.resx |
| Info |
Created - App_LocalResources\EventRSVPEdit.ascx.resx |
| Info |
Created - App_LocalResources\EventsView.ascx.resx |
| Info |
Created - App_LocalResources\MyEventsView.ascx.resx |
| Info |
Created - App_LocalResources\SettingsEventsView.ascx.resx |
| Info |
Created - App_LocalResources\SettingsMyEventsView.ascx.resx |
| Info |
Component installed successfully - File |
| Info |
Installation committed |
| Info |
Installation successful. - Smart-Thinker - Events |
| Info |
Starting Installation - Smart-Thinker - Event Detail |
| Info |
Starting Installation - Module |
| Info |
Module registered successfully - Smart-Thinker - Event Detail |
| Info |
Component installed successfully - Module |
| Info |
Starting Installation - File |
| Info |
Created - SettingsEventDetail.ascx |
| Info |
Created - EventDetail.ascx |
| Info |
Created - EventCalExport.aspx |
| Info |
Created - App_LocalResources\EventDetail.ascx.resx |
| Info |
Created - App_LocalResources\SettingsEventDetail.ascx.resx |
| Info |
Component installed successfully - File |
| Info |
Installation committed |
| Info |
Installation successful. - Smart-Thinker - Event Detail |
| Info |
Starting Installation - Smart-Thinker - Events AddToEvent |
| Info |
Starting Installation - Module |
| Info |
Module registered successfully - Smart-Thinker - Events AddToEvent |
| Info |
Component installed successfully - Module |
| Info |
Starting Installation - File |
| Info |
Created - AddToEvent.ascx |
| Info |
Created - AddToEventSettings.ascx |
| Info |
Created - App_LocalResources\AddToEvent.ascx.resx |
| Info |
Created - App_LocalResources\AddToEventSettings.ascx.resx |
| Info |
Component installed successfully - File |
| Info |
Installation committed |
| Info |
Installation successful. - Smart-Thinker - Events AddToEvent |
| Info |
Deleted temporary install folder |
| EndJob |
Installation successful. |
|
|
|
|
|