Please help, I still can´t get this working.. :-(
I tried to Import from AVCalendar, but I got an errormessage saying there was no stored procedure for the import. So I guessed I have to reinstall the new Events module. I deleted the files and mdefinitions from Module definitions, and tried to install a new Events module that I found on the Events module download area here on Dotnetnuke.com
But something seems to get wrong. What should I do? Please, someone from the Events module team...?
| StartJob |
Begin Sql execution |
| Info |
Executing 03.01.00.SqlDataProvider |
| StartJob |
Start Sql execution: 03.01.00.SqlDataProvider file |
| EndJob |
End Sql execution: 03.01.00.SqlDataProvider file |
| |
| Info |
Executing 03.02.00.SqlDataProvider |
| 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.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 |
| |
| EndJob |
Finished Sql execution |
|
| |
|