TYPO3 Core

quick and DIRTY (!) fix for t3lib_install:

Replace the line:
} elseif (strcmp($FDcomp[$table][$theKey][$fieldN], $fieldC)){
with:
} elseif (strcmp($this->getNormalizedFieldDefinition($fieldC), $this->getNormalizedFieldDefinition($FDcomp[$table][$theKey][$fieldN]))){

And somewhere below insert this new function:

function getNormalizedFieldDefinition($FD) {
        // remove duplicate spaces and convert to upper case
        $FD = ereg_replace(' +',' ',strtoupper($FD));

$mysqlExpressions = array(
            'NOT NULL' => 'not_null',
            "DEFAULT \'([^']*)\'" => 'default_\\1', // DOES THIS DOES NOT WORK STABLE!
        );

foreach($mysqlExpressions as $mysqlExpression => $replacement) {
            $FD = ereg_replace($mysqlExpression,$replacement,$FD);
        }

if(strstr($FD,'AUTO_INCREMENT')) {
            $FD = str_replace('default_0','',$FD);
        }

$parts = t3lib_div::trimExplode(' ',$FD);
        sort($parts);

if(!strcmp($parts[0],'')) unset ($parts[0]);

return implode($parts,',');
    }

I have a similar situation, but it is not only the order of things:

ALTER TABLE be_groups CHANGE uid uid int(11) unsigned NOT NULL auto_increment;
Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment

The difference is that the Current value has DEFAULT '0' and the definition doesn't.

Should be fixed in 3.8.0beta2 - please reopen if this is wrong.

I still find these problems wit 3.8.0beta2 as well as current HEAD.

Install-Tool->Update required tables->COMPARE

ALTER TABLE be_groups CHANGE uid uid int(11) DEFAULT '0' NOT NULL auto_increment;
Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
.....
.....

seems finally solved.
Thx to all bugfixers