Project

General

Profile

Actions

Bug #16422

closed

Updating database tables doesn't work

Added by Torkil Svensgaard over 18 years ago. Updated over 17 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2006-08-02
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)

Actions #1

Updated by Karsten Dambekalns about 18 years ago

This is documented behaviour, see manual, Section "Known problems", subsection "Results of database comparison operations".

Actions

Also available in: Atom PDF