Page 2 of 2
Re: Unable to add/change content as admin
Posted: Mon Aug 02, 2010 4:39 pm
by snatrott
I can add News posts, so it is narrowed down to something regarding only the content.
Have you apache mod_security module enabled (look to "System Information" in step 2)?
I checked the System Information and didn't see anything referring to mod_security, but I checked from the Admin panel and didn't try to install the site again. I also checked the phpinfo and did not see any reference to mod_security.
Re: Unable to add/change content as admin
Posted: Mon Aug 02, 2010 7:53 pm
by snatrott
I just checked the PHP version and it is running 5.2.12 and found that the requirements state 5.2.4+, so I will be checking into upgrading the PHP and then report back to see if that fixes the problem or just narrows down possible causes.
Re: Unable to add/change content as admin
Posted: Tue Aug 03, 2010 9:07 am
by alby
snatrott wrote:
I just checked the PHP version and it is running 5.2.12 and found that the requirements state 5.2.4+, so I will be checking into upgrading the PHP and then report back to see if that fixes the problem or just narrows down possible causes.
5.2.12 is ok for CMSMS (but has a few security concern).
mod_security is a Apache module (nothing to do with php), installer check that in STEP 2 (in top area: system information)
If you have installed CMSMS, enable debug in config.php and look for errors [Error(0): IS NOT ERROR]
Alby
Re: Unable to add/change content as admin
Posted: Tue Aug 03, 2010 3:14 pm
by snatrott
Here are screen shots from Step 1 and Step 2 of the installation:
Step 1:
www.acacinci.org/images/step1.png
Step 2:
www.acacinci.org/images/step2.png
There was nothing about mod_security, and I uploaded the checksum files that it listed and nothing changed. Those files also show as being smaller in size but no amount of uploading is changing that.
Re: Unable to add/change content as admin
Posted: Tue Aug 03, 2010 5:27 pm
by snatrott
Sorry about the PHP version stuff...I read those versions backwards and we already comply with the requirement.
I was able to update both the News and Events (CGCalendar) with no problems at all.
Here is a screen shot after I "add" a page (which doesn't really add) with debug on:
www.acacinci.org/images/addpage.png (it is a large file)
Re: Unable to add/change content as admin
Posted: Tue Aug 03, 2010 6:22 pm
by NaN
snatrott wrote:
(it is a large file)
Can you please copy & paste and provide a txt file for download/view?
Searching for "Error" on a huge image only with your eyes is like searching for a needle in a haystack
But as i could see, something went wrong with the upgrade.
The error message " Unknown column 'secure' in 'field_list' " tells me that a column is missed in your db table that came with 1.8 (i guess).
For some (unknown) reason (to me) some providers don't let you add columns to your db after a table has been created. (honestly i've seen this in only very rare cases but it might be the reason for your problems)
This error causes the db not to write any changes to the content.
I did not see any further errors.
So you need to create that column named "secure" in the table "cms_content" by yourself using your db management tool (like e.g. phpMyAdmin or whatever you have).
Read here for some more details:
http://forum.cmsmadesimple.org/index.ph ... #msg213263
[SOLVED] Re: Unable to add/change content as admin
Posted: Wed Aug 04, 2010 2:39 am
by snatrott
Awesome!!! That missing field was the key. I added it and tested the page creation and all was good.
Nan, you are a lifesaver. All of you have been so gracious and helpful. I love this community.
Thanks guys!