Bug #89874

Can't updata database structure on MariaDB 10.0 and TYPO3 9.5 (can't rename index)

Added by Tymoteusz Motylewski about 2 months ago. Updated about 2 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2019-12-06
Due date:
% Done:

0%

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

Description

I just have an issue when upgrading TYPO3 from 8.7 to 9.5.11 on Mariadb v10.0. It fails on trying to rename db index on sys_file_metadata table:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDEX pid TO `parent`' at line 1

The sql query is

ALTER TABLE sys_file_metadata RENAME INDEX pid TO `parent` 

It seems that mariadb 10 doesn't support index rename
https://stackoverflow.com/questions/19797105/does-mariadb-support-renaming-an-index (edited)
So basically we either have to fix the logic of index rename or bump db server requirements.
Or maybe its' possible to figure out some detection of the mysql/mariadb type?

https://github.com/doctrine/migrations/issues/196

This issue might be related to
https://review.typo3.org/c/Packages/TYPO3.CMS/+/62063

History

#1 Updated by Tymoteusz Motylewski about 2 months ago

  • Description updated (diff)

#2 Updated by Tymoteusz Motylewski about 2 months ago

The workaround is it set server version manually in Localconfiguration.php

$GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default']['serverVersion'] = 5.6;

Also available in: Atom PDF