All Showing - 01 Jan 1970

Mod that adds a birthday field to the users profile, theire age are displayed beside the posts, and on there birthday they will have a greeting popup
Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

All Showing - 01 Jan 1970

Postby dnj on Tue 28. Dec, 2004 20:45

Installed the birthday mod and it was working, installed a few other mods and it now only shows 01 Jan 1970.

Mods installed after the birthday:
Photo Album
Easy Assign User To Groups
Country Flags
Super Quick Reply
Moderator Control Panel
Topics A User Has Started
Profile Views
Colour On Poll Results
Username In Moderator Control Panel
Prevent Reply Notifications To Unauthorized Users
Save Posts As Drafts
IP Only By Admin
Email Posts Or Messages To Combinations Of Groups
Member Number In Profile
Posted Email java**script
Advanced User Search
Cookie
Hit Counter
Verified User
E-Mail Confirmation
Refer A Friend

Not sure if there is a code conflict causing this to happen or if the code order in the files is causing this to not access and write to the database.

Any help or ideas would be great

I am using 2.0.11
Linux
Apache 1.3.31 (Unix)
PHP 4.3.9
MySQL 4.0.22-standard
dnj
Poster
Poster
 
Posts: 2
Joined: Tue 28. Dec, 2004 19:54

Admin Side

Postby dnj on Tue 28. Dec, 2004 23:20

Just tried updating a users birthday on admin and it will set before 1970. I set it back to 1960 and it shows in the user profile.

Guess the problem is in includes/functions or includes/usercp_register
dnj
Poster
Poster
 
Posts: 2
Joined: Tue 28. Dec, 2004 19:54

Postby meshka mira on Sun 30. Jan, 2005 22:32

I have the same problem. After the installation all birthdates are set to 01 Jan 1970. When a user tries to change that nothing happens. Everyone on my forum are now 35 years ol 8O HELP PLEASE!
meshka mira
Poster
Poster
 
Posts: 3
Joined: Sun 30. Jan, 2005 21:57

Postby meshka mira on Sun 30. Jan, 2005 23:25

SOLVED

I fixed the problem by changing the TYPE value of the birthday field from DATE to INT in the MySQL database and then running the query
UPDATE prefix_users SET user_birthday=999999 WHERE user_birthday=0
to change all the values into 999999 (special value for "no value set yet"). Now everything works perfect.

Hope others can use this, 'cause damm this was frustrating...

Koos


I tried this and voila!

If you can not still solve it please have a search as "1970" and look at the topics.

I was about to get mad heh i dont want you to be mad too so i am writing these here.
meshka mira
Poster
Poster
 
Posts: 3
Joined: Sun 30. Jan, 2005 21:57

well

Postby shawng on Fri 26. Aug, 2005 21:45

My birthday feild is already int and the default is 99999, where is this "1" coming from settting everything to 1970 ONLY on registration??? Arghhhhh....
shawng
Poster
Poster
 
Posts: 6
Joined: Fri 26. Aug, 2005 21:04

YES!!

Postby shawng on Fri 26. Aug, 2005 22:57

Okay the answer has been on this board for 2 almost 3 years.

http://mods.db9.dk/viewtopic.php?t=2009 ... 2+jan+1970

Scroll down to warmweer and see what he has to say. The fact is that the ordering of these variables on the insert is very crucial. after the 0,1 on the values and before user_active on the insert line resolved the issue when ALL ELSE FAILED. Thank you to Warmweer- 2 years later!!!

-Shawn
shawng
Poster
Poster
 
Posts: 6
Joined: Fri 26. Aug, 2005 21:04

Postby OFFICER on Sun 18. Sep, 2005 04:53

i have the default value "99999" set to "0" but the error is in there...anyone have a solution? PLEASE!
OFFICER
Poster
Poster
 
Posts: 1
Joined: Sun 18. Sep, 2005 04:15


Return to Birthday [2.0.10/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron