project management, project management software, collaboration software - Copper Project  
 
FORUMS
"People actually use it, that makes my life easier!" Multimediums
 
   
Register  ::  Log in  ::  Search 

Post new topic | Reply to topic
 
 Task Comment times off by 1 hour., in Support
 
nboot
 
PostPosted: Thu Mar 20, 2008 9:13 pm    Post subject: Task Comment times off by 1 hour. Reply with quote
Joined: 09 Nov 2007
Posts: 5

I'm having a weird problem that I can't seem to homebrew a fix for (build 3523).

Whenever comments are added to our tasks, the time of the comment is behind by one hour.

I checked the system time by viewing the output of `date`, which returned the correct time.

I checked the PHP date() function by printing the output of date('H:i:s'), which also returned a correct time. I also checked to make sure our timezone was being set properly in /etc/php.ini (PHP 5.1.6), which it is.

Patching modules/projects/index.php with:
Code:
@@ -4130,6 +4132,9 @@
                        }
                        else {
                                // insert comment
+                                       $fh = fopen("/tmp/sqldate.out", "w+");
+                                       fwrite($fh, date("H:i:s") . "\r\n");
+                                       fclose($fh);

Results in a timestamp one hour early being written to /tmp/sqldate.out

I can't quite figure out what might be affecting the time returned by date("H:i:s") in the above example.


Can anyone drop some knowledge on this one? No super big deal other than my sanity being at stake.
 
nboot
 
PostPosted: Thu Mar 20, 2008 9:39 pm    Post subject: Re: Task Comment times off by 1 hour. Reply with quote
Joined: 09 Nov 2007
Posts: 5

nboot wrote:
I'm having a weird problem that I can't seem to homebrew a fix for (build 3523).


sorry about that guys -- I found my own solution by changing the timezone as stored by copper (table sysAdminSettings where setting='TimeZone')
 
  Page 1 of 1





Tour | Sign-up | Demo & Free Trial | Buzz | FAQs | Forums | Blog | Contact
© Copyright Element Software 2001-2008 
Element Software - Creators of Copper Project Management Software