Bug #89063

Index too large for sys_redirect

Added by Ingo Fabbri 2 months ago. Updated 20 days ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2019-09-02
Due date:
% Done:

0%

TYPO3 Version:
9
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

The following errors occurred:
+---------------+-------------------------------------------------+-----------------------------+
| Type          | SQL Statement                                   | Message                     |
+---------------+-------------------------------------------------+-----------------------------+
| Change fields | ALTER TABLE `sys_redirect` CHANGE `source_path` | Specified key was too long; |
|               | `source_path` VARCHAR(2048) DEFAULT '' NOT NULL | max key length is 3072      |
|               |                                                 | bytes                       |
|               |                                                 |                             |
+---------------+-------------------------------------------------+-----------------------------+

Reason: https://forge.typo3.org/issues/88336

affected database server version: mariadb-10.1.37


Related issues

Related to TYPO3 Core - Bug #88336: redirects: longer URL strings are stripped in source_path Resolved 2019-05-12
Duplicates TYPO3 Core - Bug #89169: Redirects indey key too long after source path increase Needs Feedback 2019-09-13

Associated revisions

Revision ac4e3bfa (diff)
Added by Manuel Selbach 20 days ago

[BUGFIX] Respect changed indexes within schema migration

With this change all indexes identified as "changed" will get proper
SQL statements to update them (e.g. DROP and ADD afterwards).

The order has also been changed to apply the index changes first, to
avoid issues on changing a field on a table, see #89169.

Releases: master, 9.5
Resolves: #88176
Related: #89169
Related: #89063
Change-Id: Ia683ff1a6ccea47cc9b3848f2db0b9f32b984626
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/61476
Tested-by: TYPO3com <>
Tested-by: Daniel Goerz <>
Tested-by: Alexander Schnitzler <>
Tested-by: Manuel Selbach <>
Reviewed-by: Daniel Goerz <>
Reviewed-by: Guido Schmechel <>
Reviewed-by: Markus Klein <>
Reviewed-by: Alexander Schnitzler <>
Reviewed-by: Manuel Selbach <>

Revision 4e9c9ac3 (diff)
Added by Manuel Selbach 20 days ago

[BUGFIX] Respect changed indexes within schema migration

With this change all indexes identified as "changed" will get proper
SQL statements to update them (e.g. DROP and ADD afterwards).

The order has also been changed to apply the index changes first, to
avoid issues on changing a field on a table, see #89169.

Releases: master, 9.5
Resolves: #88176
Related: #89169
Related: #89063
Change-Id: Ia683ff1a6ccea47cc9b3848f2db0b9f32b984626
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/62063
Tested-by: TYPO3com <>
Tested-by: Manuel Selbach <>
Reviewed-by: Manuel Selbach <>

History

#1 Updated by Ingo Fabbri 2 months ago

  • Related to Bug #88336: redirects: longer URL strings are stripped in source_path added

#2 Updated by Marco Bresch 2 months ago

Another affected database server is MySQL 5.7.23

#3 Updated by Ingo Fabbri 2 months ago

updated from 9.5.8 to 9.5.9

#4 Updated by bitfire it services about 2 months ago

Can confirm this for Typo3 after upgrade from 9.5.8 to 9.5.9 with 5.7.27-0ubuntu0.18.04.1.

#5 Updated by Guido Schmechel about 1 month ago

  • Related to Bug #89169: Redirects indey key too long after source path increase added

#6 Updated by Frank Naegler about 1 month ago

  • Duplicates Bug #89169: Redirects indey key too long after source path increase added

#7 Updated by Frank Naegler about 1 month ago

  • Related to deleted (Bug #89169: Redirects indey key too long after source path increase)

#8 Updated by Manuel Selbach 20 days ago

  • Status changed from New to Closed

See issue #89169

Also available in: Atom PDF