Bug #33580

prepending "zzz_deleted_" might exceed the maximal lenght for column names

Added by Tolleiv Nietsch about 9 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
Start date:
2012-02-01
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
4.7
PHP Version:
5.4
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

I found that renaming a column to "zzz_deleted_tx_powermail_tellAFriendForm_receiverEmailContentField" didn't work because if it's size of 66 characters. MySQL allows only 64 - therefore I suggest to add that limitation also to t3lib_install_sql.

At the same time the patch has to make sure that the shortened names don't create collisions - therefore the field names are cut of from the beginning of the name because it's less likely to create collision this way.

See MySQL documentation: http://dev.mysql.com/doc/refman/5.5/en/identifiers.html


Related issues

Related to TYPO3 Core - Bug #37425: Install Tool renames all tables and fields to "zzz_deleted_"Closed2012-05-23

Actions
#1

Updated by Gerrit Code Review about 9 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/8791

#2

Updated by Gerrit Code Review about 9 years ago

Patch set 2 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/8791

#3

Updated by Gerrit Code Review about 9 years ago

Patch set 3 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/8791

#4

Updated by Gerrit Code Review about 9 years ago

Patch set 4 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/8791

#5

Updated by Gerrit Code Review almost 9 years ago

Patch set 5 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/8791

#6

Updated by Gerrit Code Review almost 9 years ago

Patch set 1 for branch TYPO3_4-7 has been pushed to the review server.
It is available at http://review.typo3.org/11327

#7

Updated by Gerrit Code Review almost 9 years ago

Patch set 1 for branch TYPO3_4-6 has been pushed to the review server.
It is available at http://review.typo3.org/11329

#8

Updated by Tolleiv Nietsch almost 9 years ago

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

Updated by Riccardo De Contardi over 3 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF