Page 1 of 1

Adding new pages adds to db but doesn't show in admin

Posted: Tue May 10, 2011 12:27 pm
by tobzzz
Under: content > pages
I click: Add New Content
I only have 1 template style I'm using, that's selected by default. I add all the fields and click submit, the page says:
'Content was successfully added to the database'
but under the notification box there is still only 1 entry called 'Home'. I've tried 3 or 4 times adding new pages. I got into phpMyAdmin, look under cms_content table and all the entries are there. Field called Collasped are set as NULL whereas home entry is set as 1, other difference is field called accesskey is set as 1 for home and blank for new entries. Could these be the issue? I set debug=true in config.php but saw no errors at all. I'm completely stumped. Please help!

Other info is:
- Win Vista Ultimate OS
- WAMP v2 installed (phpMyAdmin 3.1.1, mySQL 5.1.30, php 5.2.8)
- No errors in installation
- No errors / issues updating templates, home page, css sheets etc
- CMSMS v1.9.4.1 "Faanui"
- No extensions / modules / plugins installed, just normal kit

Thanks so much!

/ Tobz

Re: Adding new pages adds to db but doesn't show in admin

Posted: Wed May 11, 2011 2:22 am
by frankmanl
Hi Tobzzz, I experienced this a couple of weeks ago with a new installation.
I tried several things to solve it and I'm quite sure ('though not 100%) that it was due to not making step 4 of the installation process:
4. Fix the permissions on the cache and template compilation directories so the web
server has access to them.
- chmod -R 777 tmp
- chmod -R 777 uploads
optionally, if you would like to be able to install modules via the admin panel:
- chmod -R 777 modules
After setting these permissions it worked.

Frank

Re: Adding new pages adds to db but doesn't show in admin

Posted: Wed May 11, 2011 6:01 am
by RonnyK
set your TimeZone in the config.php. It might be caching. Check first if ClearCache in GlobalSettings makes the pages appear, if so, then caching is causing this.

Ronny

Re: Adding new pages adds to db but doesn't show in admin

Posted: Wed May 11, 2011 8:20 am
by tobzzz
Hi guys,

Many thanks for your replies. I'd like to fill you in on further developments that may shed more lights:

I decided to put the site online, backed up the db, updated the config.php file, zipped the site, uploaded, extracted and ran it. When I went into admin area and looked under pages I also only saw 'home', just like offline. However, when I 'Added new content', the new page appeared AND all the other test ones suddenly appeared! Offline, I still have the same problem.

Does this help in ideas? Is there a way i can reset/flush the site offline?

Thanks!

Re: Adding new pages adds to db but doesn't show in admin

Posted: Wed May 11, 2011 8:25 am
by tobzzz
Ronnie, you are a life saver, I just clicked 'clear cache' under the 'advanced setup' tab in global settings (admin area) and now they appear! The tick box 'allow browser to cache was unchecked' so assumed nothing would cache. I assumed dead wrong.

Thank you so much for that - SOLVED :-)

/ Tobzzz

Re: Adding new pages adds to db but doesn't show in admin

Posted: Wed May 11, 2011 9:47 am
by RonnyK
The tick is just for manual cache-clearing.

I think that you should set the TimeZone in config.php correctly, to make sure that the cache is cleared automatically

Ronny

Re: Adding new pages adds to db but doesn't show in admin

Posted: Tue May 17, 2011 5:04 pm
by essexboyracer
WHat happens if you do set the timezone correctly in config, but it still does this? Is there perhaps a difference between my servers time and the timezone? Does it work with DST?

Re: Adding new pages adds to db but doesn't show in admin

Posted: Tue May 24, 2011 11:38 pm
by eferrini
Ronny,

I'm having the same issue.

I confirmed that my timezone is correctly set to 'MST' and I'm still having the problem. Clearing the CMS cache works, but it doesn't seem reasonable to have to clear the CMS cache every time a new page is added.

Any other suggestions on how to prevent the CMS backend caching?

Thanks,
Tony

Re: Adding new pages adds to db but doesn't show in admin

Posted: Wed May 25, 2011 3:37 am
by pixelita
This is of interest to me as well since I've been working on an ecommerce site also using cataloger so there are many levels and sublevels of pages. Also, my server is on CEST and I am actually in the U.S. so there's a +7 hour time diff. And the issue has just been happening since I changed web hosts. I'd just like to set this up so that it works correctly. :)

Re: Adding new pages adds to db but doesn't show in admin

Posted: Wed May 25, 2011 4:17 pm
by eferrini
Hi all,

Update: I found a solution that works for me. It is indeed related to the timezone setting. It looks like there is a bug in the web-based installation when you set the timezone. I selected to correct timezone in that process, and it put 'MST' in my config.php file.

However, I played with different timezone settings until it worked. I went here: http://www.php.net/manual/en/timezones.america.php

America/Phoenix did not work for me. America/Denver did.

Re: Adding new pages adds to db but doesn't show in admin

Posted: Thu Jul 07, 2011 3:37 pm
by beherenow_uk
Hello all,

I've been having this problem too with the latest cmsms 1.9.4.2.

I'm in London UK, but my Server is in Berlin Germany. So i changed the time zone in config.php to the time zone of where my server is located, and not where i am and now it all works fine again.

Very annoying, but glad i found this thread!

Thanks Ronny.

Re: Adding new pages adds to db but doesn't show in admin

Posted: Thu Jul 07, 2011 5:08 pm
by calguy1000
In most hosts, when using PHP 5.2 the timezone stuff won't be a problem, an empty value in the config.php will work fine. It'll just use the timezone of the server automatically.

However, if you are using PHP 5.3 or you are having problems with warnings, or the times aren't set properly, then you will have to set the timezone to that of the server (wherever your server is located).

The list if timezones shown here: http://www.php.net/manual/en/timezones.america.php are valid, and will work... with one caveat: If your server is in a timezone that changes it's time twice a year for daylight savings... then choosing a setting like MST will only be valid for part of a year (and probably is currently wrong but will be correct during the winter). That is because MDT is the proper value when daylight savings is in effect.

If you use the proper timezone that is location based... like 'America/Denver' etc. And the server is properly configured (most are these days) the timezone setting should always be correct (until your server or website moves).

Re: Adding new pages adds to db but doesn't show in admin

Posted: Thu Jul 28, 2011 8:47 am
by NikNak
Hi there

I have just discovered the same issue, with my server based in Holland and me in London.

Yes I can get everything to work if I set the timezone to Amsterdam, but then all my entries in calendar and news have the wrong time. How do I correct this? Strangely, when I have ported over sites from a UK server, and kept the timezone set to London, it all works fine.

I think I need a little help :-(

Nik

Re: Adding new pages adds to db but doesn't show in admin

Posted: Sun Jul 31, 2011 6:52 pm
by EoinDubh
I am having the same issue. I have no idea where the server that my site is running on is at the moment and my ISP is not telling me for "security reasons". I found that commenting out the timezone entry in my config.php file fixed the issue. At least the pages show up as soon as they are created.

Re: Adding new pages adds to db but doesn't show in admin

Posted: Tue Aug 02, 2011 2:22 am
by replytomk3
EoinDubh wrote:my ISP is not telling me for "security reasons"
Idiots. Move to a different host. By converting your domain name to an IP you can find out

1) Where your server is located
2) Which other websites reside on the same server

You can also SSH into your server and find out the timezone it is set to. No SSH? Like I said, get a different host.