Bug #57421
Update database scheme still fails
| Status: | Resolved | Start date: | 2014-03-28 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assigned To: | Nicole Cordes | % Done: | 100% |
|
| Category: | Install Tool | Spent time: | - | |
| Target version: | next-patchlevel | |||
| TYPO3 Version: | 6.2 | Is Regression: | No | |
| PHP Version: | Sprint Focus: | |||
| Complexity: |
Description
If you try to update a current 6.1 introduction package without any other core update the database scheme updater fails and blocks other updates.
Related issues
Associated revisions
[BUGFIX] Improve database scheme updater
This patch improves the update process as it removes the hard stop after
an SQL error occurred. All queries should get executed and errors should
be reported at the end. Sometimes it gets necessary that the updater is
called more that once - a notice to the user is added.
Besides the index length is reduced by 1 to ensure the index is set
with limitation in the database and all fields can be updated in the
second step.
Resolves: #57421
Releases: 6.2
Change-Id: I2f830a8a62b8dff3fbe949d40de8ddc30f3dfb9a
Reviewed-on: https://review.typo3.org/28945
Reviewed-by: Jigal van Hemert
Tested-by: Jigal van Hemert
Reviewed-by: Dmitry Dulepov
Tested-by: Dmitry Dulepov
Reviewed-by: Christian Kuhn
Tested-by: Christian Kuhn
History
#1 Updated by Gerrit Code Review over 1 year ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/28945
#2 Updated by Nicole Cordes over 1 year ago
- Status changed from Under Review to New
To be more clear according to the identifier key issue:
in a current 6.1 installation of the introduction package the field length of identifier is 200. Within the update of the key "identifier" the length is set to 200 chars as well. This used to be okay, as within some 6.1 update the table field was raised to a length of 512 chars. Then the database index gets correctly cropped to 200 chars.
But coming from an elder not uptodate 6.1 installation the key is only set to the field without any cropping. This causes a problem for the field update to 512 chars as the index becomes to big. To solve this issue manual handling in the compare database wizard or even the database itself is needed.
#3 Updated by Gerrit Code Review over 1 year ago
- Status changed from New to Under Review
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/28945
#4 Updated by Nicole Cordes over 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 039467b8e75487983acdd2d9cbc1192be245c9a8.