Home News Reviews Forums Shop


Suggestion for 1-Jan-1970 problem

Need help with the website? Have feedback? Post it here.

Suggestion for 1-Jan-1970 problem

Postby MediumRare on Wed Dec 24, 2003 9:09 am

This is probably just a zero in the time field, so that the times shown are 0:00 hours UTC on 1 Jan. 1970, the "epoch" for the Unix time system (they show up as 31 Dec. 1969 for me at UTC+1).

Although I'm not directly affected by this problem myself, I do look through old threads occasionally, where the time got wiped. Sometimes the posts are shown in the correct order, sometimes they end up reversed- which is rather disconcerting. Furthermore, there's an ongoing discussion on the "first post" in the Beer Garden right now.

Here's a suggestion to at least show the correct order of these posts:
Code: Select all
replace all 0-times with the post number

Most posts would still show as 1-Jan-1970 (post no. 36000 would be at 10 a.m. UTC), but the chronological order would be correct.

This should be possible with a simple SQL-command or a Perl 3-liner (depending on how the data is stored). The date joined could be processed similarly- assuming that the member nos. are assigned successively.

Of course it would be best to try this out on a copy of the data first! :wink:

G
User avatar
MediumRare
CD-RW Translator
 
Posts: 1768
Joined: Sun Jan 19, 2003 3:08 pm
Location: ffm

Re: Suggestion for 1-Jan-1970 problem

Postby dodecahedron on Wed Dec 24, 2003 12:12 pm

MediumRare wrote:(they show up as 31 Dec. 1969 for me at UTC+1).

that depends if you're logged in or not, and on your GMT settings.
One Ring to rule them all, One Ring to find them,
One Ring to bring them all and in the darkness bind them
In the land of Mordor, where the Shadows lie
-- JRRT
M.C. Escher - Reptilien
User avatar
dodecahedron
DVD Polygon
 
Posts: 6865
Joined: Sat Mar 09, 2002 12:04 am
Location: Israel

Postby cfitz on Wed Dec 24, 2003 12:56 pm

Good thinking, MediumRare. I agree that it would help when reading archive threads. I also have run into the problem you describe where the individual posts are sometimes out of order and very difficult to follow in old, yet still valuable, threads.

cfitz
cfitz
CD-RW Curmudgeon
 
Posts: 4572
Joined: Sat Jul 27, 2002 10:44 am

Postby dodecahedron on Thu Dec 25, 2003 12:56 am

cfitz wrote:Good thinking, MediumRare. I agree that it would help when reading archive threads. I also have run into the problem you describe where the individual posts are sometimes out of order and very difficult to follow in old, yet still valuable, threads.

yeah, i've had that too.
it's very hilarious or very annoying. depending on your mood or how badly you need the info in that topic!
One Ring to rule them all, One Ring to find them,
One Ring to bring them all and in the darkness bind them
In the land of Mordor, where the Shadows lie
-- JRRT
M.C. Escher - Reptilien
User avatar
dodecahedron
DVD Polygon
 
Posts: 6865
Joined: Sat Mar 09, 2002 12:04 am
Location: Israel

Postby MediumRare on Tue Feb 08, 2005 8:33 am

Hey! I just noticed that this has been implemented. :D :D =D> - don't know how long it's been active, but thank you socheat. It sure helps when navigating through old threads!

G
User avatar
MediumRare
CD-RW Translator
 
Posts: 1768
Joined: Sun Jan 19, 2003 3:08 pm
Location: ffm

Postby socheat on Tue Feb 08, 2005 9:09 pm

I did it when we switched servers last week. :) Forgot to mention it, and I'm amazed you actually noticed. :o :wink:
User avatar
socheat
CD-RW Player
 
Posts: 442
Joined: Wed Aug 01, 2001 8:00 pm
Location: Ann Arbor, MI

Postby cfitz on Wed Feb 09, 2005 12:16 am

Socheat wrote:I'm amazed you actually noticed. :o :wink:

MediumRare notices everything, particularly when it comes to numbers. I think it is the "medium" in him that makes him that way... :)

cfitz
cfitz
CD-RW Curmudgeon
 
Posts: 4572
Joined: Sat Jul 27, 2002 10:44 am

Postby MediumRare on Wed Feb 09, 2005 5:02 pm

Socheat wrote:I did it when we switched servers last week. :) Forgot to mention it, and I'm amazed you actually noticed. :o :wink:

I noticed it while doing some link-chasing when checking what I'd posted here (the same information showed up redundantly in that thread).

I landed at the original thread for this hack: Next tip: displaying the real burning-speed in Nero and found it was readable (which it wasn't the last time I looked)! Eureka!

Incidentally, the oldest post I've found on the forum is this one: http://www.cdrlabs.com/phpBB/viewtopic.php?p=304#304. But you guys with access to the database can fish out the real oldest one. :wink:

Thanks again for implementing the fix!

G
User avatar
MediumRare
CD-RW Translator
 
Posts: 1768
Joined: Sun Jan 19, 2003 3:08 pm
Location: ffm


Return to Feedback and Help

Who is online

Users browsing this forum: No registered users and 0 guests

cron
All Content is Copyright (c) 2001-2024 CDRLabs Inc.