Issue Bug Closed

#82245Installing a plugin failes to create table if a field is named 'alter'

Fabian Keilholz 08/30/17, 14:50 updated 10/02/18, 10:57

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

Reviews 1