phpScheduleIt
May 23, 2013, 09:15:57 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: phpScheduleIt 2.4.2 has been released!
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: Apparent timezone calculation problem  (Read 4048 times)
cfaber
Newbie
*

Karma: 0
Posts: 5


« on: June 13, 2007, 05:18:08 PM »

PHP version: PHP 4.4.6

Database server and version: mysql 4.1.21

Web server and version: apache 2.0.52

Browser vendor and version: N/A (happens in all browsers)

Description of bug:

If a user in GMT -6 sets reserves a block of time, and the user in GMT +3 views the reservation it's WAY off.

So an example would be me, in GMT -6 reserves Monday 900 through 1600 hours the user in GMT +3 sees the reservation for Tuesday (the next day) between 1800 and 100 hours. This to me seems totally wrong as it's well over 12 hours difference.

I can provide screen shots and database entries for this to debug.

What you were doing at the time of the bug:
Thinking about having a beer =)
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #1 on: June 14, 2007, 10:48:47 AM »

I'll try and reproduce this.  Thanks.
Logged
cfaber
Newbie
*

Karma: 0
Posts: 5


« Reply #2 on: June 18, 2007, 12:55:26 PM »

Hi,

Any luck on this one? Can I provide you with more information to assist you in your investigation?

This is a real problem and we really do need to correct it. Likely others are experiencing the same issue and just haven't noticed yet.

-cf
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #3 on: June 19, 2007, 10:54:46 PM »

This appears to be working as designed.  What's the timezone setup as for the server in config.php?
Logged
cfaber
Newbie
*

Karma: 0
Posts: 5


« Reply #4 on: June 28, 2007, 01:47:42 PM »

Hi,

Here is an example of what I'm talking about:

I scheduled time from 0800 - 1700 on Tuesday June 26. I am in GMT -6. The people in Russia are in GMT +3 so that is a 9 hour difference.

What should have happened is:
0800 - 1700 Tuesday local Colorado time
1700 - 2400 Tuesday Russia time,  Plus 0000 - 0200 on Wednesday.

What is displayed in Russia is that I have time scheduled on Wednesday June 27 from 1700 - 0200. This is not correct, it shows all my time scheduled for tomorrow not today. I think the bug is when I put in a length of time that rolls over to another day in the local (Russia or China)  environment. As I stated above it should have shown the systems as allocated today from 1700-2400 Tuesday and then more time tomorrow (Wednesday) from 0000 - 0200.


What is displayed: This is wrong.

0800
    0900
    1000
    1100
    1200
    1300
    1400
    1500
    1600
    1700
    Tuesday Colorado
1700
    1800
    1900
    2000
    2100
    2200
    2300
    2400
    0100
    0200
    Wednesday Russia


What should be displayed: This is right.

0800
    0900
    1000
    1100
    1200
    1300
    1400
    1500
    1600
    1700
    Tuesday Colorado
1700
    1800
    1900
    2000
    2100
    2200
    2300
    2400
    Tuesday Russia

    0100
    0200
    Wednesday Russia


Does this make sense now?
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #5 on: June 29, 2007, 05:35:58 PM »

What timezone is the server set to in config.php?
Logged
cfaber
Newbie
*

Karma: 0
Posts: 5


« Reply #6 on: June 29, 2007, 08:27:03 PM »

Sorry, It's set to -6
Logged
cfaber
Newbie
*

Karma: 0
Posts: 5


« Reply #7 on: July 18, 2007, 06:24:58 PM »

Have you had any luck with this problem?
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #8 on: July 19, 2007, 01:16:09 PM »

This is working as it should.

Here was my test data:

Server was configured as -6, as well as config.php
User profile was configured as +3

Logged in as a user set as -6, I viewed a reservation for 4:30 - 9:00 pm July 4
Logged in as a user set as +3, I viewed that same reservation as 1:30 - 6:00 am July 5

I confirmed the times were correct by checking the current time in GMT +3
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!