[solved] Adding content doesn't actually add content

[GsJosh]

I recently upgraded from 1.6 to 1.6.6 and I now find myself in a weird position. The upgrade I did seemed to go perfecly fine and it's all been up and running for a few days already. But now, I just wanted to add new content, which I did by just clicking "Add new content" at the top of the pages administration page.

So I filled in the content in there, clicked "Submit" and saw the obvious message of: "Success The content was successfully added to the database."

But when I then try to look for the content I just added, it's not there. Not in the pages list, not on the frontend, not even in the database itself! It only shows a change in the admin-log but it's not even added to the contents table.

I've not found anything like this on this forum nor Google. The only topic that looked like my problem was this. This is not my case (I don't get a 404 error when viewing the index) and also the fix is too drastic for me, I'm really not sure that a change of columnnames in the database will fix the problem.

I also tried to install the 'base' version instead of the 'full' version, but without any success.

I'm running out of options here, since I don't even have an error to search with. Does somebody recognise this behaviour? Does somebody know a solution to this?

Just to be clear, I upgraded by deleting ALL my files (1.6) and uploading the new (1.6.6) files freshly, I'm pretty sure there's nothing wrong with the files themselves.

[jmcgin51]

can you post your system information?

[GsJosh]

Off course! I'm very sorry that I didn't do that in the first place, that's something that should have been there all along.

- I'm (after the upgrade from 1.6) running 1.6.6
- With extra modules installed:
  - CGExtensions 1.17.6
  - FormBuilder 0.5.11
- PHP  5.2.11-1+bytelenny2
- PHP Effective Memory Limit of 120 MB
- Maximum Execution Time of 99
- PHP Safe Mode is OFF
- MySQL version 5.0.87
- Apache + Linux

All paths are set correctly and everything else seems to work fine!
Even the Admin Log tells me that "content was added", but it's not seen in the "Pages" page, nor the frontend itself, not even in the database.

[GsJosh]

Funnily enough, I have a similar problem on another CMSMS website of mine. It runs on 1.6.3 and whenever I try to add content, it says it's added, but it doesn't show up in the 'pages' list nor the frontend. This time, it is actually injected in the database when I do a search. I see it's added to cms_content_props but not to cms_content.

Is this maybe a clue somebody could help me with?

I must confess that on both databases, I did manual SQL queries to change a string. That couldn't have harmed anything, since it was just stuff like this:

Code: Select all

update cms_content_props set content =  replace (content, '16,50', '17,50');

[GsJosh]

I have found the problem.

The most important part of the problem was that I had manually added rows into the database with SQL Queries, I do this because it's a fast way to manage several websites. What I didn't know was that CMS Made Simple doesn't use auto-increment for it's content database. Instead, the value of the last used ID is stored in a table called CMS_content_seq.

The fix was to change the value in the CMS_content_seq to the last known value of ID in CMS_content.

It turns out that the CMS Made Simple backend (admin panel) doesn't show any sign of warning or error if the content is not actually added. I strongly recommend that the script should somehow check if the content was succesfully injected, because I didn't have any kind of error to work with. Of course it's my own fault, but yah. MySQL must have given off an error, like "ID already in use" or something.

My knowledge and knowhow of php/mysql is really few, but I like learning every day and I hope that any person in the future with the same problem is helped by this solution!

And let's not forget how awesome CMS Made Simple is!