Are you sure that the x.Id is an actual content node ID?

Can you check for a null on c - are you debugging? Stick a breakpoint after you GetById and see if you are actually getting a content object back.

Hi Steve,

Yes i am sure that x.Id is the content node:

IEnumerable<IPublishedContent> list = parentpage.Children.Where(t => t.DocumentTypeAlias == "newsPage");
string menutitle = "";
NewsPage np = null;
foreach (var x in list) {
    np = (NewsPage)x;
    menutitle = np.MenuTitle;
    if (menutitle.Length > 8) {
        if (menutitle.Substring(6, 1) == "-") {
            sb.AppendLine("Success! ID: " + x.Id + " menuTitle: " + menutitle);

this is giving this output into the StringBuilder:

Success! ID: 1476 menuTitle: 170731-XXXXX completes Private Placement of XXXXX Success! ID: 1478 menuTitle: 170710-XXXXX invests in XXXXX, the leading XXXXX services provider Success! ID: 1479 menuTitle: 170629-XXXXX generates successful partial realisation of XXXXX Success! ID: 1480 menuTitle: 170628-XXXXX completes acquisition of XXXXX Success! ID: 1481 menuTitle: 170619-XXXXX extends relationship with XXXXX until 2021 Success! ID: 1483 menuTitle: 170523-XXXXX continues expansion in Europe with the acquisition of XXXXX

Do you think is might have something to do with the transition to the id that has the int plus the guid format?

Marshall

 foreach (var x in list) {
                np = (NewsPage)x;
                menutitle = np.MenuTitle;
                if (menutitle.Length > 8) {
                    if (menutitle.Substring(6, 1) == "-") {

                        var c = Services.ContentService.GetById(x.Id);
                        sb.AppendLine("Success! ID: " + c.Id + " c.Name: " + c.Name);

                        c.SetValue("menuTitle", menutitle.Substring(7));
                        Services.ContentService.Save(c);

The stringbuilder still gives output - but the error is still there on the save:

Cannot insert the value NULL into column 'id', table 'UMBCinvenLocal.dbo.cmsContentVersion'; column does not allow nulls. INSERT fails. The statement has been terminated.

Googling that error seems to suggest others have seen this error when they've either scripted and recreated the DB on a server (and missed the unique identifer auto increment property off that table) or manually inserted data straight into the db and botched it.

I take it neither of those apply?

Are you running on SQL Express / SQL Server?

Hi Steve,

I did indeed recreate the database from azure down locally via a .bacpac file - and that is indeed the problem.

What was wrong with the old Sql Server .bak file format? Force-restore and off you go!

So i can assume that all the tables need identity switched on then?

Marshall

I will re-download load it using Create Scripts and set it to Schema and Data

Thanks very much

Marshall

is working on a reply...