Bug #79065
closedInstall tool upgrade wizard at 95% on a fresh install
100%
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 phpmyadminI 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
Updated by Riccardo De Contardi over 7 years ago
also present with 8.6.0-dev (latest master)
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
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
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
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
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
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%.
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.
Updated by Morton Jonuschat over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset d9b52a59deec5d58838158777e914fc9ee537295.