Edit page content through database?

[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

[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.

[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

[paulbaker]

+1 on the upgrade advice.

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.

[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

[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.