Bug #16422
closedUpdating database tables doesn't work
0%
Description
My installation was done from scratch on DBAL/Typo3 4.0/MYSQL 5.0.
I just upgraded the Typo3 source to 4.0.1 and was going through the upgrade guide. At one point you are to check if any database upgrades are needed (http://typo3.org/documentation/document-library/installation/doc_inst_upgr/current/view/4/3/)
It finds a lot of stuff it would like to change, first example is:
ALTER TABLE be_groups CHANGE uid uid int(11) unsigned NOT NULL auto_increment;
Current value: bigint(20) default ''
It doesn't work though, it just keeps coming back, reporting that the same change is needed.
In the MySQL log I find this is what is actually being done:
ALTER TABLE `be_groups` MODIFY COLUMN `uid` BIGINT UNSIGNED NOT NULL
So, is this how it is supposed to be and can I safely ignore the updates it wants to do or this this an error?
(issue imported from #M3965)
Updated by Karsten Dambekalns about 18 years ago
This is documented behaviour, see manual, Section "Known problems", subsection "Results of database comparison operations".