Tables used for CMS

[patbishop]

Does anyone happen to know which tables are used to store all of the required CMS data?

The following have ben discovered, but after migration from one instance to another, it appears that I'm missing something:

• content_theme
• content_page
• content_site
• sys_ui_macro
• content_block_programmatic
• content_theme_css
• content_css
• sys_portal
• sys_portal_preferences

The layouts, CSS, pages all were carried over. When I click on a page, I can see the dropzones listed, but when I click on "Edit Page", the Content is empty. It's as if all the Dropzone content was not carried over.

Ideas?

[Raj Muppavarapu]

Check these....

cms_menu_tab_content_block

content_block_lists_summary

content_link

render_content_block_iframe

render_content_block_header

render_content_block_menu

[patbishop]

Out of those tables, I was only able to find "content_link" in the Berlin instance. Is there somewhere specific I need to look or are those tables only in newer versions of SN?

[shuynh]

This is an older post so I'm thinking you have already achieved relief of the issue on your Berlin instance?   I recall issues of blank pages after migration or upgrade due to missing Portal Preferences [sys_portal_preference] which is associated to a Portal Section [sys_portal] (aka Dropzone):

Beyond that, here's a list of CMS related tables from a Berlin instance:

[Manjul Katare]

Hi Pat,

In addition to Shirley's information, I would go to Content Management Module and try to get all the table. As you can see below module names under Content Management.

I would look at following tables:

-:Content Management:-

Sites <content_site>

  Pages <content_page>

Blocks:

  All <content_block>

  Headers <content_block_header>

  Navigation Menus <content_block_menu>

  Dynamic <content_block_programmatic>

  Lists <content_block_lists>

  Static HTML <content_block_static>

Specialty Content:

  Flash Movies <content_block_flash>

  Content Links <content_link>

  IFrames <content_block_iframe>

Design:

  Themes <content_theme>

  Style Sheets <content_css>

  Layouts <sys_ui_macro>

  Frames <sys_ui_macro>

  Images <db_image>

Configuration:

  Configuration Page <content_config>

  Page Detail Settings <content_block_detail>

  Content Types <content_type>

  List Definitions <sys_ui_macro>

  Login Rules <content_page_rule>

Hope this helps!

-Manjul