Project

General

Profile

Actions

Bug #82245

closed

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

Added by Fabian Keilholz over 6 years ago. Updated over 5 years ago.

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

issue82245_1.0.0_201710292032.zip (3.57 KB) issue82245_1.0.0_201710292032.zip Nicole Cordes, 2017-10-29 20:33
Actions

Also available in: Atom PDF