Issue Bug Closed

#34557Missing backticks in t3lib_install_Sql->getUpdateSuggestions

Nico de Haen 03/06/12, 12:35 updated 07/03/13, 15:20

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);

Reviews 1