Issue Bug Closed

#16422Updating database tables doesn't work

Torkil Svensgaard 08/02/06, 08:44 updated 03/13/07, 15:16

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.