Project

General

Profile

Actions

Bug #34557

closed

Missing backticks in t3lib_install_Sql->getUpdateSuggestions

Added by Nico de Haen over 12 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2012-03-06
Due date:
% Done:

0%

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

Description

Is there any reason not to add backticks in the field definitions? If I try to add a column named "order" or any other reserved word it won't work without backticks.

The attached patch adds backticks to all field and table names in this method, except in the ADD KEY field list like in:

ALTER TABLE `sys_log` ADD KEY user_auth (type,action,tstamp);


Files

t3lib_install_sql-backtick.patch (5.63 KB) t3lib_install_sql-backtick.patch Nico de Haen, 2012-03-06 12:35

Related issues 1 (0 open1 closed)

Is duplicate of TYPO3 Core - Bug #35253: Installer should respect backticks while creating sql queriesRejected2012-03-26

Actions
Actions

Also available in: Atom PDF