This is what I was talking about
<?
require("main.inc.php");
echo "We need to rename the old field. You might get an error here, which is OK. <br /><br />";
// 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);
That sure looks the same as post 99336 which I tried.
No worries the last part works
All I was saying is every script you posted renamed the old one but does not create the new one.
