Where is the page content actually stored?

[lvarney]

Hi,

My colleague installed CMS Made Simple recently and he has now left the company which leaves me to try to work out how it all works.

I need to know where the actual 'content' of the pages is actually stored. I am using the menu options Content --> Pages. In here we have a structured list of pages. When editing a page we are given the following fields which we can edit:-
Content Type
Title
Menu Text
Parent
Template
Content

The Content field for particular pages stores a mixture of HTML/PHP - I need to know which database table this information is stored in as editing it via the WYSIWYG editor corrupts the data and makes the pages break.

I have searched through the various tales within the database to find out where this is stored and all I can find is one row in a table called 'content' which contains the following fields:-
content_id
content_name
type
owner_id
parent_id
template_id
item_order
hierarchy
default_content
menu_text
content_alias
show_in_menu
collapsed
markup
active
cachable
id_hierarchy
hierarchy_path
prop_names
metadata
titleattribute
tabindex
accesskey
last_modified_by
create_date
modified_date

None of the above fields actually contain the page content (the mixture of HTML/PHP).

Can anyone help me?

Thanks,
Laura

[moonie]

Hello Laura,

I think the content should be stored in the table "cms_content_props" in the field "content".

Another solution you could try is to disable the WYSIWYG editor under My Preferences --> User Preferences --> Select WYSIWYG to use: none. This should present you with a simple textfield showing the page sourcecode instead of the visual view of your content.

[lvarney]

thank you!

i appreciate your quick response