Actions
Bug #82245
closedInstalling a plugin failes to create table if a field is named 'alter'
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Extension Manager
Target version:
-
Start date:
2017-08-30
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
Hello,
If a plugin contains a create table statement in ext_tables.sql, in which a field is named 'alter' (german for "age"), Typo3 silently failes to create that table.
Steps to reproduce:
1) Put below (or a similar) statement in the ext_tables.sql and install the plugin
(This is a valid SQL Statement and works if executed manually, also queries to that statement work if executed manually)
2) install the plugin
3) check if table is created
#
# Table structure for table 'tx_mymodel_domain_model_xyz'
#
CREATE TABLE `tx_invngtr_domain_model_xyz` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`pid` int(11) NOT NULL DEFAULT '0',
`alter` int(4) unsigned not null,
`tstamp` int(11) unsigned NOT NULL DEFAULT '0',
`crdate` int(11) unsigned NOT NULL DEFAULT '0',
`cruser_id` int(11) unsigned NOT NULL DEFAULT '0',
`deleted` tinyint(4) unsigned NOT NULL DEFAULT '0',
`hidden` tinyint(4) unsigned NOT NULL DEFAULT '0',
`starttime` int(11) unsigned NOT NULL DEFAULT '0',
`endtime` int(11) unsigned NOT NULL DEFAULT '0',
`t3ver_oid` int(11) NOT NULL DEFAULT '0',
`t3ver_id` int(11) NOT NULL DEFAULT '0',
`t3ver_wsid` int(11) NOT NULL DEFAULT '0',
`t3ver_state` tinyint(4) NOT NULL DEFAULT '0',
`t3ver_label` varchar(255) NOT NULL DEFAULT '',
`t3ver_stage` int(11) NOT NULL DEFAULT '0',
`t3ver_count` int(11) NOT NULL DEFAULT '0',
`t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
`t3ver_move_id` int(11) NOT NULL DEFAULT '0',
`sys_language_uid` int(11) NOT NULL DEFAULT '0',
`l10n_parent` int(11) NOT NULL DEFAULT '0',
`l10n_diffsource` mediumblob,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
KEY `language` (`l10n_parent`,`sys_language_uid`)
);
Expected Result: The Table gets created if i install the plugin
Actual Result: The Table is missing after installing the plugin, no errors displayed anywhere
Typo3 Version: 7.6.17
PHP-Version: 5.6.30
OS: Centos Linux 7
Files
Actions