Error when using ItemRelation field on Page ItemType

E-mail notifications

Adrian Ursu

Posted on 10/01/2018 12:27:37

Hi Guys,

I have this solution running 8.9.2.15 (latest version).

I have set a field of type ItemRelation on the PageItemtype for storing some relations with other pages.

Thisng look very good for pages where I add this property. For some reason, for older pages that were not saved after adding this property, I get a nasty error when trying to load or check GetLoop("Item.Page.Related_Pages.Value"). No matter if the tag is commented or inside a verification. I cannot check if the tag returns a null or empty value because no matter what I try, I get the yellow error.

I have attached the error and you can find it online as well: https://development-dynamicweb.biolegend.com/en-us/products/all-groups-immunology-5321-human-immunology-1597

If I save the page, the error is gone.

Looks like a bug to me.

Thank you,

Adrian

Replies

Nicolai Pedersen

Posted on 10/01/2018 13:07:56

Hi Adrian

That is bug TFS#38527 fixed in 9.3.2.0. There are no fix available for 8 solutions.

BR Nicolai

Imar Spaanjaars

Posted on 10/01/2018 14:18:05

Is there a work around? Maybe save all pages once using the API?

Nicolai Pedersen

Posted on 10/01/2018 14:51:50

How many pages do you have using this?

Imar Spaanjaars

Posted on 10/01/2018 16:35:45

A few hundred, maybe up to 1,500 or so. Too many to manually click Save on..... Oh, and times 3 environments.....

Imar Spaanjaars

Posted on 18/01/2018 09:16:40

We just wrote this code to update all pages using the API. Do you see any potential problems with running this code once?

@{
  var ids = new List<int>();
  const string sql = "Select PageID FROM Page";
  using (var connection = Dynamicweb.Database.CreateConnection())
  {
    using (var reader = Dynamicweb.Database.CreateDataReader(sql, connection))
    {
      while (reader.Read())
      {
        ids.Add(Convert.ToInt32(reader[0]));
      }
    }
  }
  foreach (var id in ids)
  {
    var page = Dynamicweb.Content.Page.GetPageById(id);
    page.Save(true);
  }
}

Nicolai Pedersen

Posted on 18/01/2018 09:27:54

Hm... No, not in particular.... Would not test it in production anyhow!

Imar Spaanjaars

Posted on 18/01/2018 09:38:40

Haha, no we won't. We have separate dev and test environments so I think we can safely try it out....

You must be logged in to post in the forum

Developer forum

Error when using ItemRelation field on Page ItemType

Replies