Transfer content tables from one cmsms to another

The place to talk about things that are related to CMS Made simple, but don't fit anywhere else.
Post Reply
Ertenal
Forum Members
Forum Members
Posts: 19
Joined: Fri Sep 30, 2011 2:28 pm

Transfer content tables from one cmsms to another

Post by Ertenal »

Im creating a new version of a website that is made with cmsms 1.6. I'd like to use the new cmsms version (1.11.1) for the new site, but also want to have a fresh and clean installation (so no update).

When this is done, i want to transfer the content of the current website to the new website. So i tried to copy the content tables (cms_content, cms_content_props, cms_content_props_seq and cms_content_seq) to the new cmsms database.

I also made some changes to the records, like changing the owner id and template_id so that every field is set correct.

The only problem is that i cannot see the content pages in the new site admin. I can visit the pages in the front-end (not by menu, but manually typing the url in the addressbar). What did i forgot to copy so that the pages are also visible in the admins page overview?
Jos
Support Guru
Support Guru
Posts: 4019
Joined: Wed Sep 05, 2007 8:03 pm
Location: The Netherlands

Re: Transfer content tables from one cmsms to another

Post by Jos »

Maybe it helps if you go to Site Admin » System Maintenance » tab Cache and content and click the Update button underneath "Update page hierarchy positions"
Ertenal
Forum Members
Forum Members
Posts: 19
Joined: Fri Sep 30, 2011 2:28 pm

Re: Transfer content tables from one cmsms to another

Post by Ertenal »

That was the trick. Thank you
Post Reply

Return to “The Lounge”