#93 Birthdays not saved

[Dave]

When setting a users birthday, I see the date is
written to the MySQL db as expected. Thsi is retained
until the user logs out and then back in. Upon login,
the date is somehow rewritten to the current date.

Using version 0.7.3 "Finally", php 4.3.10, and Apache
on Windows 2000. (Also verified this issue on SuSE
Linux 9.2 webserver and the MGW demo).

Thanks,

Ab

[Dave]

Logged In: YES
user_id=745211

I fixed this, FYI... Just changed the field type for the
birthday field in the mgw_users table from a timestamp to a
date type field.

Thanks,

Ab

[Franky Van Liedekerke]

Logged In: YES
user_id=109671

Has this change been committed to cvs, or did you just do it
at your mgw setup?

Franky

[Dave]

Logged In: YES
user_id=745211

I apologize for the delayed response, I wasn't actually
watching this and just noticed it on my sf.net page. I
didn't (and am not really sure how to) commit this to CVS.
I just changed it on my webserver by issuing the command
(without quotes):

"alter table mgw change birthday birthday date"

Birthday is repeated so that it keeps the field name and
just changes the field type ( alter table [tableName] change
[field name] [new field name] [field options]).

Thanks,

Ab

[Dragon]

Logged In: YES
user_id=1226591

The value in the mgw_users table is changed on login.
It is rewritten with the current timestamp.
The reason is a default NOW() function that MySQL puts on
the first timestamp column in a table. Therefore this field gets
updated everytime the table is updated (which in this case
happens on login). I saw nothing in the MySQL
documentation on this.
The type should be changed to datetime (not date, because
we will loose the empty time :). However, someone might
decide to use this for some astro module, who knows...

[Karsten Dambekalns]

Logged In: YES
user_id=105527

Since we don't create the database tables directly, but
through ADOdb XML Schema, we have the choice between either
'T' or 'D' for the birthday field.

'T' obviously evaluates to a TIMESTAMP in MySQL, whereas 'D'
gives us a DATE column. So... I made it a 'D', if someone
wants to use the field for an astro module - bad luck... :)

Please test the change, since I didn't... Sorry.