Can not find page item record in database when create an page?

Ryan Nguyen asked on January 16, 2019 12:48

I create a new page. Every think in CMS look good, but I can found it from database. I checked in CMS_Tree, CMS_Document,View_CMS_Tree_Joined and my custom page type table. I can't debug, please give me any way to solve this

See my image for more info: CMS: http://prntscr.com/m7wlqz and my queries: http://prntscr.com/m7wqs2 Thanks.

Correct Answer

David te Kloese answered on January 16, 2019 13:38

First thing would be to verify you're using the correct database. In Kentico check the System module and check the Servername and Database name

Image Text

0 votesVote for this answer Unmark Correct answer

Recent Answers

Juraj Ondrus answered on January 16, 2019 13:32

Hi,
Are you using workflows? If yes, then the data are filled into those tables and views only if the page was published (or has published version). Until then, the data are stored in the CMS_VersionHistory table.

0 votesVote for this answer Mark as a Correct answer

Ryan Nguyen answered on January 16, 2019 13:41

I sure my db and server is correct. I tried this in staging and local. Both them is same this problem

0 votesVote for this answer Mark as a Correct answer

David te Kloese answered on January 16, 2019 13:48

And as Juraj's suggested is the page using workflow?

Image Text

0 votesVote for this answer Mark as a Correct answer

Ryan Nguyen answered on January 16, 2019 17:20

I published and disabled workflow, but not it still not found

0 votesVote for this answer Mark as a Correct answer

Tomáš Loun answered on January 16, 2019 17:54

You have NodeID = 6176

What do you recieve when you call: SELECT * FROM CMS_Document where DocumentNodeID=6176 ?

0 votesVote for this answer Mark as a Correct answer

Rui Wang answered on January 16, 2019 18:02

Can you find any other pages in DB? The root? The parent page of this page?

0 votesVote for this answer Mark as a Correct answer

Ryan Nguyen answered on January 17, 2019 00:52

Yes. I can found other pages in cms-document or cms-tree

0 votesVote for this answer Mark as a Correct answer

Ryan Nguyen answered on January 17, 2019 00:54

@tomas loun: no record returned

0 votesVote for this answer Mark as a Correct answer

Ryan Nguyen answered on January 17, 2019 01:45

Another problem, i have choose its categories but i also can't find it in CMS_DocumentCategory

0 votesVote for this answer Mark as a Correct answer

Rui Wang answered on January 17, 2019 01:47

If you can't find it in anyway, contact Kentico support and send them a backup of the database. There is no way to help you like this.

1 votesVote for this answer Mark as a Correct answer

Ryan Nguyen answered on January 17, 2019 01:53

I found my problem, someone was used another connection Thanks everyone.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.