Page 1 of 1
Edit page content through database?
Posted: Thu Nov 06, 2014 9:51 am
by doolak
Hi all,
I have a very old installation of CMSMS (1.6.6 "Bonde") - and I cannot edit the pages content through the administration.
Is it possible to edit a page content through the database?
I have checked it in phpmyadmin and the content which is displayed in cms_content_props seems not to be editable.
Any help would be appreciated!
Cheers, doolak
Re: Edit page content through database?
Posted: Thu Nov 06, 2014 12:00 pm
by velden
You are in control of your own database I suppose. However note that pages might be cached by cmsms and while editing database entries cmsms does not get triggered to clear the cache.
I would (of course) advice to upgrade you install.
Re: Edit page content through database?
Posted: Thu Nov 06, 2014 12:28 pm
by staartmees
updating your cmsms and keeping it up-to-date is the only solution. Old versions of cmsms have some serious security issues and make your website and server vulnerable.
http://docs.cmsmadesimple.org/upgrading/old-versions
Re: Edit page content through database?
Posted: Thu Nov 06, 2014 3:37 pm
by paulbaker
+1 on the upgrade advice.
doolak wrote:I cannot edit the pages content through the administration.
What happens when you try to edit pages? Would be better to focus on solving that problem than trying to edit pages direct in the database.
Re: Edit page content through database?
Posted: Wed Nov 26, 2014 10:05 am
by doolak
Thanks for your replies! Yes, I agree that we will need to update the system, but unfortunately we have used MLE in those times and we an update will be a very time-expensive thing which cannot be done at this moment.
We just have to change some texts in some pages right now very urgent - so my idea was that I could maybe change those parts in the database - just don't find the relevant tables and fields...
I have added a screenshot below, this is shown when I try to edit a page - it shows an empty page with just one form field - nothing else.
The source for this is just
Code: Select all
<form method=post><input type=text name=pw></form>
This just happens when trying to edit pages, everything else works fine.
Would really be great if somebody could help me!
Cheers, Christian
Re: Edit page content through database?
Posted: Wed Nov 26, 2014 11:01 am
by paulbaker
I've got no experience with MLE so can't help with the error.
PHPMyAdmin probably won't edit that table because it can't see a unique ID. Assuming each page has unique content you
might be able to do something like:
Code: Select all
UPDATE cms_content_props SET content = '<p>new content</p>' WHERE content = '<p>old stuff</p>'
but I'm just guessing really. Of course, there is plenty of potential to mess things up completely here so you need to take a backup.