Skip to: site menu | section menu | main content

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
A Post pterodaustrodreams
Joined: 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


A Post gaye-belle
Joined: 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.'
A Post andychilton
Joined: 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/
A Post pterodaustrodreams
Joined: 26 Apr 2008 11:41:00
Posts: 39
That's awesome, thank you!

02 May 2008 21:04:28


A Post strawberry-sunshine
Joined: 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

A Post kerrynangell
Joined: 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)
A Post andychilton
Joined: 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/
A Post andychilton
Joined: 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 A Post

Back to top