Developer forum

Forum » CMS - Standard features » editing pages, paragraphs in backend

editing pages, paragraphs in backend

Frederik Gadegaard
Reply

Hi, 

I am getting this error page whenever I click on any of my pages in backend, or right-click -> click properties:
This happens on every page across languages andwebsites, and also right-click-> properties on folders produces error.
Also it seems like I am able to create new pages and delete them only being the edit part that seems to fail. 
Editing websitesettings also works without any problems.
And the thing is that I see the pages in the frontend without any issues and I can navigate the content tree and see all the content.


F12 network expection:
(the Page with ID 39 I triple checked is in the database Page table).

 

This only started to happen when I was finished creating my content tree locally and then wanted to move to my clients test server. 
I deployed my custom code to a newly created IIS application and restored the sql database that I had been working on. I could browse to the /admin page, start a new trial license, browse the site(s) and also go the backend which also seemed to work except the above problem.

OBS: one thing to note is that locally my sql database version was 2019 and when I tried to back it up and restore it on the server, I found the server using a sql v. 2016 which I then couldnt restore the newer backup on -> therefore I needed to back it up using a generated script (including both sceme and data, and specifying version of sql server to the target version, 2016) which In my view is just a different way of restoring the data. And script ran fine and looking through the tables it all seems to be there.

Additional information:
DW version is 9.9.3
.NET framework 4.7.2
sql server 2016
using a trial license (shouldnt mean anything)
tried in edge, chrome (and chrome inkognito)
using https (but with an invalid certificate)


I would appreciate all help or even just a way to try to debug this "paragraphList.aspx" which seems to be the one that fails. Like how to you usually go about debugging that?

Kind regards

Frederik
 

PS. I have attached an example of a row of a page that fails to load/being edited as an excel document


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

>> I needed to back it up using a generated script (including both sceme and data, and specifying version of sql server to the target version, 2016) which In my view is just a different way of restoring the data. And script ran fine and looking through the tables it all seems to be there.
 

Most likely this is where your error is. Recreating the database is definitely not the same as restoring a backup.

I would use a tool like Red Gate's SQLCompare or SQL Data Compare to compare the two databases. It seems likely that you find missing data in the database that's hroken (nulls, where non-nulls are expecrted).

Cheers,

Imar

 
Frederik Gadegaard
Reply

Hello again, 

It doesnt seem to be differencies in database tables that is creating this issue. (used Red Gate SQLCompare to look for differences and didnt find anything worring me)

And also I found out that it is not only editing of pages. Also editing of a user (finding a user and clicking on the user to see details / edit details):