I did as you told, but it's not working....
After the 6.4 altertable, I run convertbday.php and here are some results:
[]// script to convert JoshPet's birthday mod dates to the 6.4 date format // Written by Joshua Pettit
www.joshuapettit.com We need to rename the old field. You might get an error here, which is OK.
SQL ERROR: Wed, Dec 10 2003 18:10:35 -0600 Database error only visible to forum administrators
We need to create the new birthday fields - in case the 6.4 altertable couldn't do this at the time. You might get an error here too, which is OK.
SQL ERROR: Wed, Dec 10 2003 18:10:35 -0600 Database error only visible to forum administrators
Now we will cycle through the users and update their birthday information.
The User Pasqual - had 1-8-1974 for their birthday the new field was set to 1/8/1974
Marcela - No Birthday Information
The User Nicole - had 8-31-1977 for their birthday the new field was set to 8/31/1977
Yvonne - No Birthday Information
lamlam - No Birthday Information[/]
This seems to work fine, but as you can see in the attached picture, the U_Birthday field is not filled. How come ?
Which SQL command should I use to fill that columm ?
Thank you very much!
Pasquale
