Multiple empty records created in the contents_props table - Delete ?

Talk about writing modules and plugins for CMS Made Simple, or about specific core functionality. This board is for PHP programmers that are contributing to CMSMS not for site developers
Post Reply
fxv_cms
Forum Members
Forum Members
Posts: 13
Joined: Wed Sep 03, 2008 7:47 am

Multiple empty records created in the contents_props table - Delete ?

Post by fxv_cms »

Hello

I noticed that for every content page created, 1 record is created in the cms_content table (as I expected) and 6 in the cms_content_props table :

- one with prop_name="content_en"
- one with prop_name="extra3"
- one with prop_name="extra2"
- one with prop_name="extra2"
- one with prop_name="pagedata"
- one with prop_name="target"

even when extra1, extra2, extra3, pagedata and target are not used.
These 5 records have then empty fields except the content_id, type (string) and prop_name.

Does anyone know
1) why these 5 "extra-records" are created instead of having the fields of the cms_content used instead ?
2) if it is possible to delete these empty records with no impact to the navigation for the end-user ?
 

The reason why I would like to delete these "empty records" is avoiding an inflation of records in the table, since I am converting an HTML site with several hundred pages into CMSMS and do this largely via mySql.

By the way, is there a cleaner way to load a batch of HTML pages into CMSMS, instead of modifying directly the tables in the database ?

Thanks

François
alby

Re: Multiple empty records created in the contents_props table - Delete ?

Post by alby »

fxv_cms wrote: 1) why these 5 "extra-records" are created instead of having the fields of the cms_content used instead ?
2) if it is possible to delete these empty records with no impact to the navigation for the end-user ?
 


Yes but they are create automaticaly if you edit that page, they are the params of a content page

Alby
Post Reply

Return to “Developers Discussion”