PDA

View Full Version : mysql visiting time is not real time.


jdleung
07-15-2006, 09:29 AM
I found on my site, the table that records the datetime is not the real time. above 8 hours later than my local time.

is it something I have not config right? or the server need to be configed?

thanks.

GeoS
07-15-2006, 09:41 AM
Server needs it.

jdleung
07-15-2006, 10:10 AM
but the comment datetime is ok.

Joe[y]
07-15-2006, 11:42 AM
do you have the timezone configured correctly on your admin options page? also note that it doesn't update with daylight savings unfortunately - though obviously this won't cause an 8 hour difference unless you live at the north pole or something.

jdleung
07-15-2006, 05:24 PM
']do you have the timezone configured correctly on your admin options page? also note that it doesn't update with daylight savings unfortunately - though obviously this won't cause an 8 hour difference unless you live at the north pole or something.
I'm using GMT +8.

jdleung
07-16-2006, 02:37 PM
I don't think it's a problem of server now. the same thing happen on my local pc.

GeoS
07-16-2006, 07:45 PM
Thanks to you bug is fixed now.

Go to /includes/functions.php and add at the beginning of function book_visitors
line with:

global $cfgrow;

jdleung
07-17-2006, 02:53 AM
yes, it' works correctly now.;)

blinking8s
07-17-2006, 06:01 AM
moving to bugs