More in this section

Forums / Developing with Sitefinity / Edit events in admin area.

Edit events in admin area.

2 posts, 0 answered
  1. Stanimira
    Stanimira avatar
    12 posts
    Registered:
    30 Jan 2009
    06 Feb 2009
    Link to this post

    I have a question regarding Sitefinity Events.

    Where can I find in the Sitefinity DB  Event Publication/Expiration Date?

    I have imported events archive, where there was no publication/expiration date. Now, when I try to edit past event I got the following error:

     

    Server Error in '/' Application.

    Object reference not set to an instance of an object.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [NullReferenceException: Object reference not set to an instance of an object.]
       Telerik.Events.WebControls.Admin.ControlPanel.CreateEventsContentView() +293
       Telerik.Events.WebControls.Admin.ControlPanel.CreateChildControls() +242
       System.Web.UI.Control.EnsureChildControls() +87
       System.Web.UI.WebControls.CompositeControl.RecreateChildControls() +24
       Telerik.Cms.Engine.WebControls.Admin.ControlPanel.set_Mode(Modes value) +777
       Telerik.Cms.Engine.WebControls.Admin.ControlPanel.button_Command(Object sender, CommandEventArgs e) +276
       Telerik.Events.WebControls.Admin.ControlPanel.button_Command(Object sender, CommandEventArgs e) +961
       System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +108
       System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135
       System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
    

     


    Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
     


    What can be done? Can I update these dates in the DB?

    Best Regards,

    Mira

  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    06 Feb 2009
    Link to this post
    Hi Stanimira,

    How did you import the archive? Here is an script that will return Publication_Date and Expiration_Date for all event items.

    SELECT TOP 1000 [ContentID] 
          ,[LangID] 
          ,[KeyValue] 
          ,[Application] 
          ,[ValueType] 
          ,[ShortText] 
          ,[LongText] 
          ,[DateTimeValue] 
          ,[IntegerValue] 
          ,[FloatValue] 
          ,[GuidValue] 
          ,[Boolean] 
          ,[Binary
          ,[Status] 
          ,[CntPrntID] 
      FROM [sitefinity351747].[dbo].[sf_GCMetaData]  
      where Application ='/Events' 
      and (KeyValue = 'Expiration_Date' or KeyValue = 'Publication_Date'

    I hope this helps.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
2 posts, 0 answered