Project

General

Profile

Actions

Bug #79065

closed

Install tool upgrade wizard at 95% on a fresh install

Added by Riccardo De Contardi over 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2016-12-21
Due date:
% Done:

100%

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

Description

new, fresh installation of 8.5.0 under Windows (XAMPP) environment:

Webserver:    Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9
PHP Version:    7.0.9
Database (Default):    MySQL 5.5.5

after the installation, open the install tool > section "Upgrade Wizard"
(please note the the installation is new, so there is nothing to update) > the progress
bar is at 95% and it reads the following message:

Update database schema: Modify tables and fields

There are tables or fields in the database which need to be changed.

This update wizard can be run only when there are no other update wizards left to make sure they have all needed fields unchanged.

If I click the "execute" button:

Update database schema: Modify tables and fields

Change the following keys in tables:

sys_file_processedfile: identifier
sys_file_reference: tablenames_fieldname
sys_category_record_mm: uid_foreign_tablefield

selecting "Show database queries performed" and clicking "Perfom updates!"

DROP INDEX `identifier` ON sys_file_processedfile 
CREATE INDEX `identifier` ON sys_file_processedfile (storage, identifier(199)) 
DROP INDEX `tablenames_fieldname` ON sys_file_reference 
CREATE INDEX `tablenames_fieldname` ON sys_file_reference (tablenames(32), fieldname(12)) 
DROP INDEX `uid_foreign_tablefield` ON sys_category_record_mm 
CREATE INDEX `uid_foreign_tablefield` ON sys_category_record_mm (uid_foreign, tablenames(40), fieldname(3), sorting_foreign) 

the update seems successful (it appears the message "Update successful"), but if I go back to the wizard, the progress bar is still
at 95% and it asks to perform the same update .

Notes:

1) According to Install tool > important actions > database analyzer, the database is OK

2)if I try for example to perform

CREATE INDEX `identifier` ON sys_file_processedfile on phpmyadmin
I get the error
1.Unexpected beginning of statement. (near "sys_file_processedfile" at position 29)

3) executing
SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE;
on phpmyadmin, the result is:
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #78024: DB Upgrade Wizard shows different results than DB AnalyzerClosedMorton Jonuschat2016-09-21

Actions
Actions #1

Updated by Riccardo De Contardi over 7 years ago

also present with 8.6.0-dev (latest master)

Actions #2

Updated by Gerrit Code Review over 7 years ago

  • Status changed from New to Under Review

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/50081

Actions #3

Updated by Gerrit Code Review over 7 years ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/50081

Actions #4

Updated by Gerrit Code Review over 7 years ago

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/50081

Actions #5

Updated by Gerrit Code Review over 7 years ago

Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/50081

Actions #6

Updated by Gerrit Code Review over 7 years ago

Patch set 8 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/50081

Actions #7

Updated by Angelo Previtali over 7 years ago

This bug has not be fixed in the latest TYPO3 verison 8.5.1: We still get in the Install tool the upgrade wizard stick at 95%.

Actions #8

Updated by Wouter Wolters over 7 years ago

Angelo, the patch is not merged yet and will probably included in the 8.6.0 release. No fix for 8.5 planned.

Actions #9

Updated by Morton Jonuschat over 7 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #10

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF