Eloy, can you take a quick look at this? The change for this field looks OK:
if ($result && $oldversion < 2007012400) {
/// Rename field access on table mnet_sso_access_control to accessctrl
$table = new XMLDBTable('mnet_sso_access_control');
$field = new XMLDBField('access');
/// Launch rename field accessctrl
$result = $result && rename_field($table, $field, 'accessctrl');
}
But the SQL fails during upgrade on MySQL 5.0.22 like this (the prefix for this site was "poo_")
(mysql): ALTER TABLE poo_mnet_sso_access_control CHANGE access accessctrl DEFAULT NULL 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT NULL' at line 1
ADOConnection._Execute(ALTER TABLE poo_mnet_sso_access_control CHANGE access accessctrl DEFAULT NULL, false) % line 889, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE poo_mnet_sso_access_control CHANGE access accessctrl DEFAULT NULL) % line 75, file: dmllib.php
execute_sql(ALTER TABLE poo_mnet_sso_access_control CHANGE access accessctrl DEFAULT NULL, true) % line 1766, file: dmllib.php
execute_sql_arr(Array[1], true, true) % line 921, file: ddllib.php
rename_field(Object:XMLDBTable, Object:XMLDBField, accessctrl) % line 588, file: upgrade.php
Assigning to Martín L.