2.2.0-pl2, cannot change template on new resource, console errors

Ok, so what you are saying is that mysql requires it to be "+02:00" instead of "Africa/Johannesburg"? Because it's currently set as "Africa/Johannesburg"

Quote from: EvoBunny at Jan 13, 2012, 09:04 AM

Ok, so what you are saying is that mysql requires it to be "+02:00" instead of "Africa/Johannesburg"? Because it's currently set as "Africa/Johannesburg"

That is correct. AFAIK, Africa/Johannesburg is not a valid time zone value for MySQL.

That solved the problem, thanks a million! Never knew mysql needed the UTC format...

AFAIK, Africa/Johannesburg is not a valid time zone value for MySQL

I found details here:
http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html

Named time zones can be used only if the time zone information tables in the mysql database have been created and populated.

Quote from: opengeek at Jan 13, 2012, 09:01 AM

MySQL requires an offset from UTC, not that string which is only valid for PHP time zones. So what specifically is it set to in MySQL?

I too am having this problem. Much appreciated if someone could shed some light on what I need to change to fix this. Here are my settings:

PHP date.timezone is set to America/Toronto
MySQL time_zone is set to SYSTEM, and system_time_zone is set to Eastern Standard Time
MODx date_timezone is blank, and server_offset_time is 0

Mucho thanks

If your php.ini has date.timezone already set, and it matches the one set for MySQL (in this and many cases this is the SYSTEM timezone), then this is not your issue.

Thanks. Any ideas then why I can't change templates? Any other info I can provide that would help?

My templates (blog in this case) in MODx call a snippet:



which allowed me to have templates in the filesystem as opposed to everything in the database. Obviously I wanted to be able to edit these files without impacting anything.

Would this have anything to do with this problem? Is this the point of you guys adding "Is Static"?

I see that you said your MODX setting is blank. Set it with the php timezone value. I would bet that's what the remaining problem is.

Static Resources takes the place of the includeFile snippet that you're using. It's quite slick! Just point the static resource to the file and delete the includeFile call. Same thing, just simpler.

But it does not have anything to do with the template save issue.