Problems with DH

edperks · Apr 16, 2004, 07:42 PM

I noticed that my birthdate was wrong. Went to change it to June 10 1965 but it has that date there allready but when you check my profile it say December 31, 1969. Not a big issue but needs to be looked into could be causeing other issues.

Andrew275 · Apr 16, 2004, 07:53 PM

I think it's a vBulletin bug.

edperks · Apr 16, 2004, 08:09 PM

Cool, I justed wanted to bring it to your attention just in case it causes any other issues.

***craig5320*** · Apr 17, 2004, 12:02 AM

yeah, it's the year that does it, if i've set it to just June 10 and it works fine, but a year older than i think 69 and it defaults to dec31'69 strange.

edperks · Apr 17, 2004, 01:11 AM

Atleat I was 4 years younger not older hehe!!

Jeff · Apr 18, 2004, 04:07 AM

I *believe* it is due to the fact that the birthday field in the database is set to UNSIGNED INT, therefore not allowing a value below 0, which is 12:00AM Jan 1st, 1970. With timezone differences, it may show Dec. 31st 1969.

I'll look into maybe changing the DB field type.

edperks · Apr 30, 2004, 01:38 AM

I think I found the prob

Actually, it's a limit of how the date() function works on certain systems. Breaks in Windows as well. Times less than Jan 1, 1970 will be negative relative to the epoch, and some OS's don't handle that.

Here a link on vBulletin forum explain everthing
click here

I would have posted code here but when i do it diplays wrong . I would backup the page first its better to be safe then sorry.

Jeff · Apr 30, 2004, 08:07 AM

Interesting, I knew of the issue with Windows systems, since we aren't running Windows, I assumed it was a database thing.

Apr 16, 2004, 07:42 PM	#1
edperks HardwareHeaven Senior Member Join Date: May 2002 Location: Southern Illinois Posts: 780 Rep Power: 0 System Specs	Problems with DH I noticed that my birthdate was wrong. Went to change it to June 10 1965 but it has that date there allready but when you check my profile it say December 31, 1969. Not a big issue but needs to be looked into could be causeing other issues.

Apr 17, 2004, 12:02 AM	#4
*craig5320* HH Administrator Join Date: May 2002 Location: Manchester, UK Posts: 8,565 Rep Power: 445 System Specs	yeah, it's the year that does it, if i've set it to just June 10 and it works fine, but a year older than i think 69 and it defaults to dec31'69 strange. __________________ HardwareHeaven on Facebook

Apr 18, 2004, 04:07 AM	#6
Jeff Yarr... I be blind! Join Date: May 2002 Location: Calgary, Canada Posts: 3,191 Rep Power: 80	I believe it is due to the fact that the birthday field in the database is set to UNSIGNED INT, therefore not allowing a value below 0, which is 12:00AM Jan 1st, 1970. With timezone differences, it may show Dec. 31st 1969. I'll look into maybe changing the DB field type. __________________

Apr 30, 2004, 08:07 AM	#8
Jeff Yarr... I be blind! Join Date: May 2002 Location: Calgary, Canada Posts: 3,191 Rep Power: 80	Interesting, I knew of the issue with Windows systems, since we aren't running Windows, I assumed it was a database thing. __________________

Apr 16, 2004, 07:53 PM	#2
Andrew275 Custom User Title Join Date: May 2002 Location: Washington Posts: 1,125 Rep Power: 0 System Specs	I think it's a vBulletin bug.

Apr 16, 2004, 08:09 PM	Thread Starter #3
edperks HardwareHeaven Senior Member Join Date: May 2002 Location: Southern Illinois Posts: 780 Rep Power: 0 System Specs	Cool, I justed wanted to bring it to your attention just in case it causes any other issues.

Apr 17, 2004, 01:11 AM	Thread Starter #5
edperks HardwareHeaven Senior Member Join Date: May 2002 Location: Southern Illinois Posts: 780 Rep Power: 0 System Specs	Atleat I was 4 years younger not older hehe!!

Apr 30, 2004, 01:38 AM	Thread Starter #7
edperks HardwareHeaven Senior Member Join Date: May 2002 Location: Southern Illinois Posts: 780 Rep Power: 0 System Specs	I think I found the prob Actually, it's a limit of how the date() function works on certain systems. Breaks in Windows as well. Times less than Jan 1, 1970 will be negative relative to the epoch, and some OS's don't handle that. Here a link on vBulletin forum explain everthing click here I would have posted code here but when i do it diplays wrong . I would backup the page first its better to be safe then sorry.