strange behaviour on adding content (existing page updates)

[insoft]

This is quite a serious problem on a live company website and I hopre somebody can give me a hint. When adding new content, everything seems to go OK (getting the ususal "content added" message), but the system actually updates an existing page with the content created.
The website is on an older CMSMS, 1.6.6 and I know it is no longer supported and we need to update, but this is impossible as I'm getting all sorts of erros when I'm trynig and we are still working on a test server.
In the meanwhile, the website needs some new pages, but we've allready updated a lot of existing pages when trying to add new content. And since there is no versioning, all content is gone.
Does anyone have any idea on where to look? I've never heard of such a behaviour. Thank you very much

[paulbaker]

we need to update, but this is impossible as I'm getting all sorts of erros when I'm trynig

You're right, you need to update. What sort of errors? How are you trying to upgrade?

You need to be following the instructions here:
http://docs.cmsmadesimple.org/upgrading
and particularly the "Steps for Upgrading from an Old Version" section.

If you post specific steps you have taken with error messages you'll probably get some more help here.

[insoft]

I got the update part loud and clear, but as I explained is not that simple. For now, I need to find out what's the cause of the strange behavior and correct it. Where to start looking?
An upgrade process will start mid January. Not any company has the resources needed to keep the CMSMS versions pace. In this case, it's a small hospital for seek children.

[Jos]

The only thing I can think of is that someone or something messed with your database.
You can check the database table "content_seq". There should be only one record, and its value should be the same as the highest content_id you can find in table "content".

[insoft]

Thank you very much. You might be on the right track:
MAX( content_id ) = 176
content_seq = 72
Should I change it to 176 and will correct the error?

[Jos]

yep, that schould do it

[insoft]

Dear Jos,
A bit late, but thank you very much for your help. It solved the problem.
Have a Merry Christmas and Happy New Year.