New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsAfter DNN upgrade I can´t add Events (using AVCalendar)After DNN upgrade I can´t add Events (using AVCalendar)
Previous
 
Next
New Post
10/13/2006 4:53 AM
 

Hi!

I had DNN 3.0.13 and using the AVCalendar from ww.avanced.net (version 3.0.10) 

After I have made an upgrade to DNN 3.03.04 I can´t add any new Events anymore. When clickin "Add Event" from the module menu i get this error: 

DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Modules.Calendar.CalendarEdit.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

I saw that AVCalendar now in some way is a part of the Core Events module. And I saw in the new Events module there is an option to Import from AVCalendar.. 

Is this a known problem when upgrading DNN? What could be the problem?
Must I add a new instance of Events module and Import from AV Calendar, or is there eny other way I can solve the problem? (On the actual site I have many instances of AVCalendar and one master calendar) 

Would be very thankful for any help!

Brgds Petri

 
New Post
10/17/2006 7:25 AM
 

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

 

 

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsAfter DNN upgrade I can´t add Events (using AVCalendar)After DNN upgrade I can´t add Events (using AVCalendar)


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.