Multiple empty records created in the contents_props table - Delete ?
Posted: Fri Sep 05, 2008 7:04 pm
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
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