Bug #86810

After Upgrade Wizard: Add the default Extension Manager database tables - Reports Update Incomplete

Added by extremo74 no-lastname-given about 1 year ago. Updated about 1 month ago.

Status:
Accepted
Priority:
Must have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2018-10-31
Due date:
% Done:

0%

TYPO3 Version:
9
PHP Version:
7.3
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Tested on clean installed 9.5.0, 9.5.1 and upgraded 8.7 to 9.5.1, always the same problem:

After I run the Upgrade Wizard "Add the default Extension Manager database tables" I get the warning on start screen:
Important Notice!
One or more problems were detected with your TYPO3 installation. Please check the status report for more information.

And in the reports:
Update Incomplete
This installation is not configured for the TYPO3 version it is running. If you did so intentionally, this message can be safely ignored. If you are unsure, visit the Update Wizard section of the Install Tool to see how TYPO3 would change.

Upgrade Wizard says: 100%
Analyze Database Structure says: Database schema is up to date. Good job!


Second issue or hint:
After that I have installed the news extension, then the Upgrade Wizard says 50% and wants me to execute the wizard "Add the default Extension Manager database tables" again.
After that I go to the Database Analyzer. It brings several database changes:

ALTER TABLE `tx_news_domain_model_news` CHANGE `uid` `uid` INT AUTO_INCREMENT NOT NULL
Current value: uid INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE `tx_news_domain_model_news` CHANGE `tstamp` `tstamp` INT DEFAULT 0 NOT NULL
Current value: tstamp INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE `tx_news_domain_model_news` CHANGE `crdate` `crdate` INT DEFAULT 0 NOT NULL
Current value: crdate INT UNSIGNED DEFAULT 0 NOT NULL
.....
I have selected all and executed, then it says: Database schema is up to date. Good job!

I go back to the Upgrade Wizard, it says 50% again as above. It's like a loop.


Related issues

Related to TYPO3 Core - Bug #89535: Extension Manager Upgrade Wizard makes wrong schema changes Under Review 2019-10-29

History

#1 Updated by Alexander Jaschke about 1 year ago

I can confirm the first issue. I have updated an 8.7 version and get the same message.

#2 Updated by Tobias Schmidt 9 months ago

Same here. Upgrading from TYPO3 7.6 to 9.5.4. It's either upgrade wizard or database analyzer. Both cannot be happy.

#3 Updated by Rene Tobias Tobias 8 months ago

Same problem here. TYPO3 9.5.5 and PHP 7.2

#4 Updated by Attila Glück 8 months ago

I have the same Problem

#5 Updated by Angelo Previtali 7 months ago

Got the same problem. PHP 7.2, TYPO3 9.5.6

#6 Updated by Riccardo De Contardi 7 months ago

  • Category set to Install Tool

#7 Updated by Rene Tobias Tobias 6 months ago

Still the same problem here in different TYPO3 upgrade to 9.5.7 (Upgraded from 8.7.24)

#8 Updated by Christoph Hendreich 6 months ago

  • PHP Version changed from 7.2 to 7.3

Got the same problem. PHP 7.2, TYPO3 9.5.7

Looking for a problem with tx_new, as soon as the extension is uninstalled and database compare the behavior does not occur anymore.
After re-installation the problem is present again.

#9 Updated by Joerg Kummer 3 months ago

Same in TYPO3 version 9.5.9 with several custom extensions.
  • integer fields will got added vs removed UNSIGNED
  • select fields will change length of varchar

#10 Updated by Markus Klein about 1 month ago

  • Related to Bug #89535: Extension Manager Upgrade Wizard makes wrong schema changes added

#11 Updated by Markus Klein about 1 month ago

  • Status changed from New to Accepted

The second part is extracted to #89535.

#12 Updated by Markus Klein about 1 month ago

I pushed a patch, which could potentially fix this issue as well: https://review.typo3.org/c/Packages/TYPO3.CMS/+/62154
Kindly asking for tests.

Also available in: Atom PDF