/
Check MySQL timezone before installing

Check MySQL timezone before installing

Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/8a6121045435cfd2#

I recently came across situation, when timestamp was prepared in PHP, but
formatted into human readable form in MySQL. As a result timestamp formatted
in MySQL was "2010-11-03 23:00:00" and same timestamp formatted in php was
"2010-11-04 00:00:00".

This happened because timezone for php (specified in php.ini OR In-Portal
configuration) was different, then webserver timezone, that was used by
MySQL.

I propose that we check that database server and web server has same
timezone, before allowing to install In-Portal.

--
Best Regards,

http://www.in-portal.com
http://www.alex-time.com