Posts: 18
Threads: 5
Joined: Sep 2012
(11-Sep-2012, 10:17 AM)Steven Wrote: Hi,
I'm glad this issue came up because I have attempted to fix this in the current development version and it would be helpful to find out if the fix works.
Basically your MySQL server is in a different location to your web server, and your MySQL server is missing the time zone definitions. It's the same as this thread, see post #6.
However, instead of using the solution in that thread:
PHP Code:
<?php
@mysql_query("SET time_zone = '-8:00'"); //set time zone DB
Can you try this solution and let me know if it works:
PHP Code:
<?php
@mysql_query("SET time_zone = '" . date("P") . "'"); //set time zone DB
The line doesn't require any editing.
Ah, OK I understand.
The fix you suggested worked! Now both preview and comment time stamp show correct time.
Thank you!
/N
Posts: 2,894
Threads: 59
Joined: Jun 2010
Ok, thanks for the confirmation.
Have
you completed
the interview?