|
|
|
Joined: 10/12/2004
Posts: 7
|
|
|
Hi, I'm using DNN 5.4.4 and cannot get past this error on upgrading my events module. I am stuck, got any ideas?
As it stands, none of my events are showing on the calendars; I am hoping I don't have to uninstall this module and reinstall it... would lose days worth of work and have to re-enter all those dates. Would love it if someone here knows why it's failing.
Error loading files from temporary folder - see below
StartJob |
Starting Installation |
Info |
Starting Installation - DNN_Events |
Info |
Starting Installation - Script |
Info |
Begin Sql execution |
Info |
Creating backup of previous version - Installation\05.01.00.SqlDataProvider |
Info |
Created - Installation\05.01.00.SqlDataProvider |
Info |
Executing 05.01.00.SqlDataProvider |
Info |
Start Sql execution: 05.01.00.SqlDataProvider file |
Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'CreatedByID'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) /**** EventsGet ****/ CREATE PROCEDURE dbo.[EventsGet] ( @EventID int, @ModuleID int ) AS SET DATEFORMAT mdy CREATE Table #RealModuleID (EventID Int, ModuleID Int) Insert into #RealModuleID (EventID, ModuleID) Select distinct e.EventID, e.ModuleID From dbo.[Events] e left outer join dbo.[EventsMaster] m ON e.ModuleID = m.SubEventID WHERE EventID = @EventID And (e.ModuleID = @ModuleID Or m.ModuleID = @ModuleID) SELECT E.PortalID, E.EventID, E.RecurMasterID, E.ModuleID, E.EventDateBegin, E.EventDateEnd, E.EventTimeBegin, E.Duration, E.EventName, E.EventDesc, E.Importance, E.CreatedDate, CreatedBy = u.DisplayName, E.CreatedByID, E.Every, E.Period, E.RepeatType, E.Notify, E.Approved, E.Signups, E.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.[EventsSignups] WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, (Select count(*) from dbo.[Events] as E2 WHERE E2.RecurMasterID = E.RecurMasterID and E2.Cancelled = 0 and E2.Approved = 1) as NoOfRecurrences, (Select max(EventDateBegin) from dbo.[Events] as E2 WHERE E2.RecurMasterID = E.RecurMasterID and E2.Cancelled = 0 and E2.Approved = 1) as LastRecurrence, E.EnrollRoleID, E.EnrollFee, E.EnrollType, E.PayPalAccount, E.Cancelled, E.DetailPage, E.DetailNewWin, E.DetailURL, E.ImageURL, E.ImageType, E.ImageWidth, E.ImageHeight, E.ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, E.Reminder, E.TimezoneOffset, E.SendReminder, E.ReminderTime, E.ReminderTimeMeasurement, E.ReminderFrom, E.SearchSubmitted, E.CustomField1, E.CustomField2, E.EnrollListView, E.DisplayEndDate, E.AllDayEvent, E.OwnerID, OwnerName = O.DisplayName, E.LastUpdatedAt, LastUpdatedBy = L.DisplayName, E.LastUpdatedID, r.RRULE, RMOwnerID = r.OwnerID, E.OriginalDateBegin, E.NewEventEmailSent FROM dbo.[Events] E inner join dbo.[EventsRecurMaster] AS r on E.RecurMasterID = r.RecurMasterID left outer join dbo.[Users] U on E.CreatedByID = U.UserID left outer join dbo.[Users] O on E.OwnerID = O.UserID left outer join dbo.[Users] L on E.LastUpdatedID = L.UserID left join dbo.[EventsCategory] b on E.Category = b.Category left join dbo.[EventsLocation] c on E.Location = c.Location WHERE EventID = @EventID And e.ModuleID = (Select ModuleID from #RealModuleID where EventID = @EventID) System.Data.SqlClient.SqlException: Invalid column name 'CreatedByID'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) /**** EventsGetByRange ****/ CREATE PROCEDURE dbo.[EventsGetByRange] ( @ModuleIDs nvarchar(1024), @BeginDate datetime, @EndDate datetime, @CategoryName nVarchar(50) ) AS SET DATEFORMAT mdy CREATE Table #EventIDs (EventID Int, NoOfRecurrences Int, LastRecurrence DateTime) INSERT INTO #EventIDs (EventID, NoOfRecurrences, LastRecurrence) SELECT DISTINCT e.EventID, Count(E2.EventID) as NoOfRecurrences, Max(E2.EventDateBegin) as LastRecurrence FROM dbo.[Events] E LEFT OUTER JOIN dbo.[EventsMaster] M ON E.ModuleID = M.SubEventID LEFT JOIN dbo.[Events] as E2 ON E.RecurMasterID = E2.RecurMasterID WHERE ((E.EventTimeBegin <= DATEADD(DAY,1,@EndDate) AND DATEADD(minute,E.Duration,E.EventTimeBegin) >= @BeginDate) OR (E.EventTimeBegin BETWEEN @BeginDate AND DATEADD(DAY,1, @EndDate))) AND E.Approved = 1 AND E.Cancelled = 0 AND (E.ModuleID in (SELECT * FROM dbo.[SplitIDs](@ModuleIDs))) GROUP By E.EventID SELECT E.PortalID, E.EventID, E.RecurMasterID, E.ModuleID, E.EventDateBegin, E.EventDateEnd, E.EventTimeBegin, E.Duration, E.EventName, E.EventDesc, E.Importance, E.CreatedDate, CreatedBy = U.DisplayName, E.CreatedByID, E.Every, E.Period, E.RepeatType, E.Notify, E.approved, E.Signups, E.MaxEnrollment, (Select Sum(NoEnrolees) from dbo.[EventsSignups] WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, ET.NoOfRecurrences, ET.LastRecurrence, E.EnrollRoleID, E.EnrollFee, E.EnrollType, E.PayPalAccount, E.Cancelled, E.DetailPage, E.DetailNewWin, E.DetailURL, E.ImageURL, E.ImageType, E.ImageWidth, E.ImageHeight, E.ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, E.Reminder, E.TimezoneOffset, E.SendReminder, E.ReminderTime, E.ReminderTimeMeasurement, E.ReminderFrom, E.SearchSubmitted, E.CustomField1, E.CustomField2, E.EnrollListView, E.DisplayEndDate, E.AllDayEvent, E.OwnerID, OwnerName = O.DisplayName, E.LastUpdatedAt, LastUpdatedBy = L.DisplayName, E.LastUpdatedID, RMOwnerID = r.OwnerID, r.RRULE, E.OriginalDateBegin, E.NewEventEmailSent FROM dbo.[Events] E inner join dbo.[EventsRecurMaster] AS r on E.RecurMasterID = r.RecurMasterID left outer join dbo.[Users] U on E.CreatedByID = U.UserID left outer join dbo.[Users] O on E.OwnerID = O.UserID left outer join dbo.[Users] L on E.LastUpdatedID = L.UserID left join dbo.[EventsCategory] b on E.Category = b.Category left join dbo.[EventsLocation] c on E.Location = c.Location left join #EventIDs ET on E.EventID = ET.EventID WHERE E.EventID in (Select EventID from #EventIDs) AND (b.CategoryName = @CategoryName or @CategoryName = N'') |
Info |
End Sql execution: 05.01.00.SqlDataProvider file |
Info |
Finished Sql execution |
Failure |
Installation Failed - Script |
Info |
Installation Failed - DNN_Events |
Info |
Deleted temporary install folder |
EndJob |
Installation Failed |
|
|
|
|
| |
|
|
Joined: 10/12/2004
Posts: 7
|
|
|
OK I fixed it. The SQL error message was stating that there was a missing column name, so I went to the events module under DeskTopModules, and went to the installation folder, and opened up the 5.00.03 SqlDataProvider file. I noticed that this is the script that creates those columns, so I manually ran it (used the Host-->SQL tool to run this script). It ran successfully, so I then re-ran the events module upgrade and this time it worked. Now the events are showing in the calendars. Dare I run another upgrade to get the latest events module running? maybe after a backup.
|
|
|
|
| |
|
|
|
www.thedivingclub.co.uk Joined: 9/23/2004
Posts: 3531
|
|
|
Well I've got to say that I'm suprise that your 5.0.3 install was working. I don't think it should have done. Or was that an intermediary step anyway?
Upgrade from from 5.1.4 to 5.1.5 is simple - no sql changes . But it does provide a number of bug fixes that are worth installing.
In anycase, I always recommend backing up before any upgrade....
Shout if you have a problem. Always happy to help.
Roger
|
|
|
|
| |