Bug #81610

Install Tool > Database Analyzer: Migration failed for fields containing a space

Added by Frank Naegler 9 days ago. Updated 8 days ago.

Status:
Accepted
Priority:
Must have
Category:
Database API
Target version:
Start date:
2017-06-19
Due date:
% Done:

0%

TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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.

History

#1 Updated by Morton Jonuschat 8 days ago

  • Status changed from New to Accepted
  • Assignee set to Morton Jonuschat

Also available in: Atom PDF