Page 1 of 2

[SOLVED] Unable to add/change content as admin

Posted: Fri Jul 23, 2010 5:07 pm
by snatrott
I just upgraded to version 1.8.1 and tried to change the template that a page was using and the page refreshes as if I did nothing. So I tried to add a new page and it says that the page was added successfully but nothing shows up in the page list.

http://forum.cmsmadesimple.org/index.ph ... 734.0.html
This was a post several years ago with what looks like the same issue, but I am not sure what his final solution entailed. Has anyone else came across this issue and/or found a solution?

Thanks.

Re: Unable to add/change content as admin

Posted: Fri Jul 23, 2010 9:27 pm
by reneh
Corrupt db? - tried a repair?
Write permission to db for the db user?

Re: Unable to add/change content as admin

Posted: Sun Jul 25, 2010 11:45 am
by NaN
How did you upgrade.
And from what version?

Re: Unable to add/change content as admin

Posted: Sun Jul 25, 2010 12:37 pm
by snatrott
I used the Base diff from 1.8.

The db user has write access, and everything else works fine.

Re: Unable to add/change content as admin

Posted: Thu Jul 29, 2010 3:03 pm
by snatrott
I can take screen shots of the database settings and tables if that will help at all. I looked around in the tables but I am not really sure what I am looking for.

I really need to be able to add and edit pages very soon, so any suggestions would be awesome. :)

Re: Unable to add/change content as admin

Posted: Thu Jul 29, 2010 3:50 pm
by tyman00
Try running the validation checksum (Site Admin --> System Verification) just to make sure there wasn't a file corrupted during upgrade.

Re: Unable to add/change content as admin

Posted: Thu Jul 29, 2010 4:49 pm
by snatrott
I ran "cmsmadesimple-1.8.1-base-checksum.dat" and got this: http://acacinci.org/images/aca-checksum.png. I re-uploaded several of the files/folders and nothing changed when I ran it again.

Re: Unable to add/change content as admin

Posted: Thu Jul 29, 2010 5:15 pm
by tyman00
I'd download the full 1.8.1-base and upload the entire package. Then run domain.com/install/upgrade.php

Then download a new 1.8.1-base-checksum.dat and verify the files during the upgrade. I am not wondering if your issues are related to some of the files failing the md5 checksum.

Re: Unable to add/change content as admin

Posted: Thu Jul 29, 2010 6:27 pm
by snatrott
I installed the base files and ran the upgrade and then downloaded the checksum and ran it and got:

Notice: Undefined offset: 1 in /usr/home/acacin/www/htdocs/admin/checksum.php on line 101

All checksums match those in the uploaded file

I tried to add a page in the admin and it said it was added successfully but nothing happened. The page wasn't created in the database.

Re: Unable to add/change content as admin

Posted: Thu Jul 29, 2010 10:01 pm
by tyman00
Try putting the site into debug mode in config.php (Don't do this on a live site) and see if it throws any errors.

Re: Unable to add/change content as admin

Posted: Thu Jul 29, 2010 10:02 pm
by snatrott
I only have access to the live site, and I don't have a testing environment that will mimic the settings on it.

Re: Unable to add/change content as admin

Posted: Fri Jul 30, 2010 5:23 pm
by snatrott
tyman00,

I am wondering if I could pm you details to log in and take a look at the admin section. Our secondary option is to install a clean version into a subdirectory and then copy content over and then swap the subdirectory with the root directory. I would really prefer not to do that, but it will be our only other viable option at this point.

Re: Unable to add/change content as admin

Posted: Fri Jul 30, 2010 7:01 pm
by snatrott
The database is obviously being read by CMSMS but I am not able to write to the database. Are there any files that I should check the permissions on to make sure that the database and the site have the proper privileges? I already checked the permissions for the database user.

Re: Unable to add/change content as admin

Posted: Sun Aug 01, 2010 2:29 pm
by NaN
Can you create News articles?
Or save settings?
Just to be sure that it is the write permission.
If you can save something in the database.
There might be an issue with saving pages.
But without any info of the debug ouput it is hard to solve that.

Re: Unable to add/change content as admin

Posted: Sun Aug 01, 2010 7:52 pm
by alby
snatrott wrote: I installed the base files and ran the upgrade and then downloaded the checksum and ran it and got:

Notice: Undefined offset: 1 in /usr/home/acacin/www/htdocs/admin/checksum.php on line 101

All checksums match those in the uploaded file
Next time you can do the checksum test during upgrade (or install) "process" in step 1....
Have you apache mod_security module enabled (look to "System Information" in step 2)?

Alby