OK _ just looked.
The U_Birthday field (new one) never got created, because you have U_BirthDay from my mod.
The other 6.4 fields are there.
My new script should work for you -
As it changes the old one - then goes through one by one and adds any fields that might have been missed. It'll fail on the ones that you've already got - but otherwise should be fine, because I split the queries out to add each field separately.... like this:
// Rename the old field
$query = "
ALTER TABLE {$config['tbprefix']}Users
CHANGE U_BirthDay U_BirthDayOLD INT( 2 ) UNSIGNED DEFAULT NULL
";
$sth = $dbh -> do_query($query);
echo "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.<br /><br />";
// Add the 6.4 fields in case the query to add them failed
$query = "
ALTER TABLE {$config['tbprefix']}Users
ADD U_Birthday VARCHAR(10) NOT NULL DEFAULT '0',
";
$dbh -> do_query($query);
$query = "
ALTER TABLE {$config['tbprefix']}Users
ADD U_ShowBday INT(1) NOT NULL DEFAULT '0',
";
$dbh -> do_query($query);
$query = "
ALTER TABLE {$config['tbprefix']}Users
ADD U_TimeFormat VARCHAR(6),
";
$dbh -> do_query($query);
$query = "
ALTER TABLE {$config['tbprefix']}Users
ADD U_Ignored TEXT,
";
$dbh -> do_query($query);
$query = "
ALTER TABLE {$config['tbprefix']}Users
ADD U_OC_Userid VARCHAR(64),
";
$dbh -> do_query($query);
$query = "
ALTER TABLE {$config['tbprefix']}Users
ADD INDEX birthday_ndx (U_Birthday,U_ShowBday)
";
$dbh -> do_query($query);
Give it a go and let me know.
