same problem over here.
mysql time zone settings are the same like in php.
Checked with:
> SELECT @ @global.time_zone , @ @session.time_zone
@@global.time_zone => Europe/Paris
@@session.time_zone => Europe/Paris
phpinfo() tells me:
Default timezone => Europe/Paris
any ideas? :S
*there are no strangers - just friends who never met*
-
☆ A M B ☆
- 1,780 Posts
This may be a silly question, but have you tried clearing the cache?
Try also clearing the cache manually by deleting all the files in the cache folder
[ed. note: frogabog last edited this post 14 years, 8 months ago.]
no, not a silly question

But I've cleared the cache... no template changing anyway...
*there are no strangers - just friends who never met*
-
☆ A M B ☆
- 1,780 Posts
When this was an issue for me, I just set the timezone in the manager and everything started working. Well, except the save doesn't work unless I make some kind of character edit in one of the fields first.
Have you checked the manager setting too?
this'll be maybe a silly question: I don't see any timezone settings in the manager. Which key(s) I have to check?
Btw: My Apache just crashed (xampp on windows) while changing the template. I recognized, that the manager will reload the page with a &reload parameter. I searched for the key in my database and found in the table modx_register_messages an entry with this id. Within the expires field is a timestamp which is in the near future (about 5mins). In the payload field everything seems to be fine.
As the apache crashed an the site didn't reload the template is set correctly. :S
*there are no strangers - just friends who never met*
-
☆ A M B ☆
- 1,780 Posts
It's in the "system & server" area - or just search "timezone" and it'll pull the setting area up for you.
Ahhh . .. I didn't know that was there. That does mostly fix it for me.
---------------------------------------------------------------------------------------------------------------
PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
MODx info for everyone:
http://bobsguides.com/MODx.html
-
☆ A M B ☆
- 1,780 Posts
Will the REAL Bob Ray please stand up?
hehe... I'm having issues digesting the concept that I knew something about MODX The Incredible Bob Ray didn't know. Now that's funny!
The timezone does fix it "mostly". The issue remains however with save not being active or available with ctrl+s until one makes some kind of character change in one of the fields. It's a small issue, but I think some peeps out there might not realize that's all one needs to do to activate it.
Fortunately there's two simple solutions. Either use the quick create or make a character change (space+delete). What's great is the discussion regarding templates and inheritance taught us all something valuable (and time saving).
-
☆ A M B ☆
- 120 Posts
Ok, have changed the MODX timezone in System & Server to GMT. Now, where do I find the MySql bit? Have gone into phpMyAdmin and then to Server Variables and Settings. Here I can find Timezone which has a value of SYSTEM. Oh, how I wish I was a proper techie .... What do I do next?? Or do I need to write the word SYSTEM into MODX??
[ed. note: intandem last edited this post 14 years, 8 months ago.]
LOL. Yes, if only there was an Official Guide book I could read to find out how to configure things for MODX.
I learn something new about MODX every day. I'm sure what I don't know would fill a medium-sized stadium.
I found this:
http://support.modwest.com/content/6/256/en/how-do-i-change-mysql-timezone.html (ignore the stuff at the top -- it's wrong).
3) MySQL has its own time zone setting that can be configured. I added the following lines to "my.cnf" I added this as root but each MySQL user also has their own ".my.cnf" that can be used to override the global settings. If you do not find "[mysqld_safe]" in brackets already in my.cnf you may need to add it. The following time zone setting is PST on my system, but it my be different on yours. On linux I found the available time zones in the file /usr/share/zoneinfo/zone.tab
I don't know what the optimum settings are, but I do know that PHP and MySQL assume that timestamps in the DB are in GMT (presumably offset from the system and/or MODX settings).
---------------------------------------------------------------------------------------------------------------
PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
MODx info for everyone:
http://bobsguides.com/MODx.html