|
| Upgrade error: Exceptions |
|
|
After upgrading from DNN 3.2.2 to DNN 4.3.3, I installed this module and get this red error. However, it says installation sucessful. Will this cause any problems?
-------------------------
StartJob Start Sql execution: 03.02.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'TimeZoneOffset'. Invalid column name 'SendReminder'. Invalid column name 'ReminderTime'. Invalid column name 'ReminderTimeMeasurement'. Invalid column name 'ReminderFrom'. 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.EventsAVCalendarImport ( @CalendarModuleID int, @EventModuleID int, @Version nvarchar(8), @TimeZone int, @PortalID int, @ImportCategory bit, @ImportLocation bit ) AS IF EXISTS(SELECT * FROM Calendar) if @Version = '03.02.00' BEGIN INSERT INTO Events (EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, Reminder, Notify, CreatedBy, CreatedDate, Approved, PortalID, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, TimeZoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted) SELECT EventID, @EventModuleID as ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, Reminder, Notify, CreatedBy, CreatedDate, Approved, PortalID, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, TimeZoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, 0 FROM Calendar WHERE ModuleID = @CalendarModuleID END ELSE BEGIN INSERT INTO Events (EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, Reminder, Notify, CreatedBy, CreatedDate, Approved, PortalID, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, TimeZoneOffset) SELECT EventID, @EventModuleID as ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, Reminder, Notify, CreatedBy, CreatedDate, Approved, PortalID, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, @TimeZone FROM Calendar WHERE ModuleID = @CalendarModuleID END SET IDENTITY_INSERT EventsCategory ON if @ImportCategory <> 0 INSERT INTO EventsCategory (PortalID, Category, CategoryName, Color) SELECT PortalID, Category, CategoryName, Color FROM CalendarCategory WHERE PortalID = @PortalID SET IDENTITY_INSERT EventsCategory OFF SET IDENTITY_INSERT EventsLocation ON if @ImportLocation <> 0 INSERT INTO EventsLocation (PortalID, Location, LocationName, MapURL) SELECT PortalID, Location, LocationName, MapURL FROM CalendarLocation WHERE PortalID = @PortalID SET IDENTITY_INSERT EventsLocation OFF
EndJob End Sql execution: 03.02.00.SqlDataProvider file
Jason Honingford - Web & Software Developer
www.PortVista.com |
|
|
|