MODS.DB9.DK

[dnj]

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]

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

[meshka mira]

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 HELP PLEASE!

[meshka mira]

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.

[shawng]

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]

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

[OFFICER]

i have the default value "99999" set to "0" but the error is in there...anyone have a solution? PLEASE!