1969? I think not...

Jaduna · Member Joined: 31 Dec 1969 Posts: 70

This place sure has changed in the time that I've been gone!
Sooo my join date is all wonky. I'm not even that old...

I did look through a few pages in the help forums, but I didn't see a topic about this.

I'm pretty sure joined FAC somewhere in 2002, so I don't know why it says 1969. ):

Is there any way to change it back to where it should be?

Battou · Posted: Thu Feb 19, 2009 3:08 am Post subject:

It's a known bug that effects just about all forums, It is caused by registration prior to the recording of registration dates. Here on FaAC that date is January 27, 2004, Anyone who registered prior to that will display December 31, 1969.
_________________
[b]RPG[/b]-[i]n[/i]. A computer programing language designed for business reporting that generates specific programs from the users specifications.([b]R[/b]eport [b]P[/b]rogram [b]G[/b]enerator)[i]The American Heritage Dictionary[/i]

[u][url=http://www.photo-lucidity.com/user-Battou.php]Photo-Lucidity[/url][/u] - [u][url=http://www.fanart-central.net/user-battou.php]FaAC[/url][/u] - [u][url=http://www.funart-central.net/user-Battou.php]FuAC[/url][/u] - [u][url=http://forums.fanart-central.net/index.php]Joke of the day[/url][/u]

Stratadrake · Posted: Thu Feb 19, 2009 7:14 am Post subject:

A bit of phpBB modding could help block the display of null dates, but a true fix is rather intensive. Generally to the tune of tracking down the first account activity, i.e. submission, comment, or forum post and setting that as the registration date.
_________________
Strata here: [url=http://www.nanowrimo.org/eng/user/242293]Nanowrimo[/url] - [url=www.fanart-central.net/user-Stratadrake.php]FAC[/url] - [url=http://stratadrake.deviantart.com]dA[/url] - [url=www.furaffinity.net/user/Stratadrake/]FA[/url]
[size=9]Disclaimer: Posts may contain URLs. Click [url=http://tvtropes.org/pmwiki/pmwiki.php/Main/TVTropesWillRuinYourLife]at your own risk.[/url][/size]

London · Moderator Joined: 23 Mar 2006 Posts: 6474

Um. That is so not worth the time and effort. Most of the people who have join dates written as 1969 don't even post anymore, so what's the point?
_________________
[i][size=9]Go Yankees![/size][/i]

Stratadrake · Posted: Thu Feb 19, 2009 8:00 pm Post subject:

Those are actually null dates rather than zeros, which [i]does[/i] make a slight difference.
_________________
Strata here: [url=http://www.nanowrimo.org/eng/user/242293]Nanowrimo[/url] - [url=www.fanart-central.net/user-Stratadrake.php]FAC[/url] - [url=http://stratadrake.deviantart.com]dA[/url] - [url=www.furaffinity.net/user/Stratadrake/]FA[/url]
[size=9]Disclaimer: Posts may contain URLs. Click [url=http://tvtropes.org/pmwiki/pmwiki.php/Main/TVTropesWillRuinYourLife]at your own risk.[/url][/size]

FJORDR · Rookie Joined: 10 Feb 2009 Posts: 32

Make the phpbb interpret the null dates as the date when registration dates were recorded.

There's also a MySQL query that can set all "registration_date" cells that have "null" in them to a value, but I don't remember how it was.

That's why you have Denis.

Stratadrake · Posted: Thu Feb 19, 2009 9:40 pm Post subject:

We use postgreSQL; null values can be compensated for via coalesce().

But it's debatably easier to just run one query to eliminate null values than to try modding phpBB itself, since modding the forum software makes it more difficult to upgrade the forums in the future.
_________________
Strata here: [url=http://www.nanowrimo.org/eng/user/242293]Nanowrimo[/url] - [url=www.fanart-central.net/user-Stratadrake.php]FAC[/url] - [url=http://stratadrake.deviantart.com]dA[/url] - [url=www.furaffinity.net/user/Stratadrake/]FA[/url]
[size=9]Disclaimer: Posts may contain URLs. Click [url=http://tvtropes.org/pmwiki/pmwiki.php/Main/TVTropesWillRuinYourLife]at your own risk.[/url][/size]

FJORDR · Rookie Joined: 10 Feb 2009 Posts: 32

Well then, problem solved. Rolling Eyes

Nobody will be registered here before the Internet was born. Very Happy

cstdenis · Posted: Thu Feb 19, 2009 10:08 pm Post subject:

For these purposes, null and 0 are the same. December 31, 1969 11:59:59 is UNIX_EPOCH -1 so it is datetime = 0
_________________
You will obey or molten silver will be poured into your ears.

RickRoll · Newb Joined: 05 Feb 2009 Posts: 20 Location: England

Funny. I was wondering why some dates were 1969/1970. I knew the Internet could not have been that old. Laughing

_________________
[img]http://i243.photobucket.com/albums/ff38/SnipeTimeR34/Stickers/Rick_Astley.jpg[/img]

Stratadrake · Posted: Fri Feb 20, 2009 7:06 am Post subject:

[quote="cstdenis"]For these purposes, null and 0 are the same. December 31, 1969 11:59:59 is UNIX_EPOCH -1 so it is datetime = 0[/quote]
Already noted in the SH forum that nulls and zeros show up on completely opposite ends of the sort spectrum, which more or less breaks the "Memberlist" available at the top.
_________________
Strata here: [url=http://www.nanowrimo.org/eng/user/242293]Nanowrimo[/url] - [url=www.fanart-central.net/user-Stratadrake.php]FAC[/url] - [url=http://stratadrake.deviantart.com]dA[/url] - [url=www.furaffinity.net/user/Stratadrake/]FA[/url]
[size=9]Disclaimer: Posts may contain URLs. Click [url=http://tvtropes.org/pmwiki/pmwiki.php/Main/TVTropesWillRuinYourLife]at your own risk.[/url][/size]