Child pages
  • Check MySQL timezone before installing
Skip to end of metadata
Go to start of metadata

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

3 Comments

  1. Hi Alex,

    I don't think it's a show stopper for In-Portal Installation, but more like
    Warning to a user which we can show at the end of installation with other
    Warnings.

    What you guys think?

    DA

  2. It depends on place, where developer will be using that MySQL date
    formatting of course.

  3. I think it's important but shouldn't block installation

    2010/11/4 Alexander Obuhovich <aik.b...@gmail.com>