Bug #81610
closedInstall Tool > Database Analyzer: Migration failed for fields containing a space
100%
Description
In one of my installations, the install tool database analyzer shows the following query to execute:
ALTER TABLE tx_foo_bar CHANGE l18n_diffsourc e `zzz_deleted_l18n_diffsourc e` MEDIUMBLOB DEFAULT NULL
The existing field contains really a space, which is fine for some databases. (sure in is this case it is a mistake)
After executing the query, this query fails:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`zzz_deleted_l18n_diffsourc e` MEDIUMBLOB DEFAULT NULL' at line 1
I guess the problem is, that the field name is not quoted.
Files
Updated by Morton Jonuschat over 7 years ago
- Status changed from New to Accepted
- Assignee set to Morton Jonuschat
Updated by Gerrit Code Review over 7 years ago
- Status changed from Accepted 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/53373
Updated by Morton Jonuschat over 7 years ago
Updated by Gerrit Code Review over 7 years ago
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/53373
Updated by Gerrit Code Review over 7 years ago
Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53403
Updated by Morton Jonuschat over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 1dd2254c112b3191cb3a86b964ec221e67637f52.