How do I?
Please sign in to post.
« Back to Main Forums
« Back to Topic List
Challenges, signing up and time zones
Page: 1
| Poster | Message |
|---|---|
pterodaustrodreamsJoined: 26 Apr 2008 11:41:00 Posts: 39 |
So, this is probably me being stupid, but when I tried to sign up to SocNoc I got the following error:
System error error: DBD::Pg::db do failed: ERROR: unrecognized time zone name: "" context: ... 316: my $sql1 = "SET TIME ZONE '$hr->{_tzname}'"; 317: my $sql2 = "SELECT CASE WHEN CURRENT_TIMESTAMP > ? THEN 1 else 0 END AS passed"; 318: my $sql3 = "SET TIME ZONE 'Pacific/Auckland'"; 319: 320: $self->dbh()->do($sql1); 321: my $res = $self->dbh()->selectrow_hashref($sql2, undef, $hr->{_time}); 322: $self->dbh()->do($sql3); 323: 324: return $res; ... code stack: /usr/share/perl5/KiwiWriters/Zaapt/Store/Pg/Challenge.pm:320 /usr/share/kiwiwriters/htdocs/zaapt/model/challenge/user-event.mhtml:44 /usr/share/perl5/HTML/Mason/Component.pm:135 /usr/share/kiwiwriters/htdocs/zaapt/model/challenge/user.mhtml:55 /usr/share/perl5/HTML/Mason/Component.pm:135 /usr/share/kiwiwriters/htdocs/my/challenge/site/dhandler:8 /usr/share/perl5/HTML/Mason/Component.pm:135 /usr/share/kiwiwriters/htdocs/my/challenge/autohandler:3 /usr/share/perl5/HTML/Mason/Component.pm:135 /usr/share/kiwiwriters/htdocs/my/autohandler:25 /usr/share/perl5/HTML/Mason/Component.pm:135 /usr/share/kiwiwriters/htdocs/autohandler:49 /usr/share/perl5/HTML/Mason/Component.pm:135 /usr/share/kiwiwriters/htdocs/syshandler:57 /usr/share/perl5/HTML/Mason/Component.pm:135 raw error I then tried to edit the time zone on my challenge settings, thinking this was the cause of the problems, but I got a page not found error. Any advice? 01 May 2008 10:18:08 |
gaye-belleJoined: 01 Jun 2007 12:11:33 Posts: 967 |
Wow that's a lot of information telling you nothing. I only know the time zone is Pacific, but Andy the expert will do doubt help you out.
01 May 2008 12:20:35
http://gay_belle.livejournal.com
The Zing Thing: "The Makeover." 'Southern Scriber.' |
andychiltonJoined: 21 Dec 2006 21:30:06 Posts: 784 |
Hi pterodaustrodreams! Really sorry about that but you should be good to go now. I've realised I have a bug when people sign up, they are not assigned a default timezone hence that unrecognised time zone in that horrible text above. :-)
I've worked around the error for now and I don't think we'll see it again (though I've made a note to fix it properly a little later). Thanks for your help now go and sign up for the challenge and have fun! Good luck. 01 May 2008 22:09:29
Andrew Chilton - http://kapiti.geek.nz/
|
pterodaustrodreamsJoined: 26 Apr 2008 11:41:00 Posts: 39 |
That's awesome, thank you!
02 May 2008 21:04:28 |
strawberry-sunshineJoined: 25 May 2008 12:11:12 Posts: 4 |
I can't get my time zone changed. Every time I update it and press "Save Changes" or whatever that is, it just goes back to the default zone. I've tried it multiple times.
Please help. 01 Jun 2008 16:26:28 |
kerrynangellJoined: 22 Dec 2006 09:00:56 Posts: 1168 |
Sorry, strawberry-sunshine (two of my favourite things!). Andy is aware of this and will be fixing it in 3 or 4 hours time.
01 Jun 2008 18:36:07
No Excuses. Just Write.
WIP - Freeing the Flame: 0/66 scenes of rewrite #2. Eve's Vineyard: 2,158/6,000 (Sept Zing Thing) |
andychiltonJoined: 21 Dec 2006 21:30:06 Posts: 784 |
Hi strawberry-sunshine ... let me know what timezone you want (KiwiMail Me) and I can update it for you. I can't quite figure out this bug yet :-) but we'll get there :-)
01 Jun 2008 22:37:17
Andrew Chilton - http://kapiti.geek.nz/
|
andychiltonJoined: 21 Dec 2006 21:30:06 Posts: 784 |
Ok, I think I've fixed the problem. Please post again here if you're still having a problem, then I can look at any individual issues.
03 Jun 2008 23:02:25
Andrew Chilton - http://kapiti.geek.nz/
|
Key
A Post![http://kiwiwriters.org/d/challenge/site/winner:socnoc-2008.png [winner:socnoc-2008.png]](http://kiwiwriters.org/d/challenge/site/winner:socnoc-2008.png)
![http://kiwiwriters.org/d/challenge/member/progkiwi:rejection-collecting-challenge:pterodaustrodreams.png [progkiwi:rejection-collecting-challenge:pterodaustrodreams.png]](http://kiwiwriters.org/d/challenge/member/progkiwi:rejection-collecting-challenge:pterodaustrodreams.png)
![http://kiwiwriters.org/d/challenge/site/winner:the-end-is-nigh-2008.png [winner:the-end-is-nigh-2008.png]](http://kiwiwriters.org/d/challenge/site/winner:the-end-is-nigh-2008.png)
![http://kiwiwriters.org/d/challenge/site/progkiwi:zing-thing-sep08:pterodaustrodreams.png [progkiwi:zing-thing-sep08:pterodaustrodreams.png]](http://kiwiwriters.org/d/challenge/site/progkiwi:zing-thing-sep08:pterodaustrodreams.png)