Project

General

Profile

Actions
Copy link

Bug #59444

closed

DB Compare Fails Key sha1(40)

Added by Kay Strobach over 10 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Morton Jonuschat
Category:
Install Tool
Target version:
7.5
Start date:
2014-06-10
Due date:
% Done:

100%

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

Description

During the Installation of TYPO3 i got a problem with that query:

ALTER TABLE sys_file ADD KEY sha1 (sha1(40));

Correcting it worked out:

-> Backticks ...
ALTER TABLE sys_file ADD KEY sha1 (`sha1`(40));

PS: There was a similar issue requesting backtick support, which was quite old ...

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Feature #68407: Check for MySQL strict mode in install toolClosedMorton Jonuschat2015-07-20

Actions
Actions
Copy link
 #1

Updated by Kay Strobach over 10 years ago

PS: MySQL 5.0 at Mittwald

Actions
Copy link
 #2

Updated by Alexander Opitz over 10 years ago

MySQL 5.1 is the minimum requirement for TYPO3 6.2. => https://github.com/TYPO3/TYPO3.CMS/blob/master/INSTALL.md

But yes, backtick support would be helpfull.

Actions
Copy link
 #3

Updated by Kay Strobach over 10 years ago

jigal said backticks will break dbal ...

Actions
Copy link
 #4

Updated by Kay Strobach over 10 years ago

then the DB Compare Tool should atleast show a warning if the mySQL version is to low ...

Actions
Copy link
 #5

Updated by Morton Jonuschat over 9 years ago

  • Category changed from Database API (Doctrine DBAL) to Install Tool
  • Assignee set to Morton Jonuschat
  • Target version changed from next-patchlevel to 7.5

A check for the minimum MySQL version in the Install Tool will be implemented after #68407

Actions
Copy link
 #6

Updated by Gerrit Code Review over 9 years ago

  • Status changed from New 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 http://review.typo3.org/42368

Actions
Copy link
 #7

Updated by Morton Jonuschat over 9 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #8

Updated by Riccardo De Contardi about 7 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF