Project

General

Profile

Actions

Bug #38932

closed

EM creates INDEX with space after the commas again and again

Added by Oliver Klee over 12 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Extension Manager
Target version:
-
Start date:
2012-07-13
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.0
PHP Version:
5.4
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

Steps to reproduce:

1. install the attached extension
2. In the tab "Database update", update the DB tables for the extensions

Expected results:
The DB table is created, and so is the index. The EM says "everything is okay".

Actual results:
The DB table is created, and so is the index. However, the EM still keeps displaying the following message:

Changing fields
select/deselect all
ALTER TABLE tx_indextest_test DROP KEY publication_key;
ALTER TABLE tx_indextest_test ADD KEY publication_key (deleted, hidden);

The demo extension basically just includes the ext_emconf.php and the following ext_tables.php:

CREATE TABLE tx_indextest_test (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid),
    INDEX publication_key (deleted, hidden)
);

The problem is the space after the comma in the INDEX line. With the space, the EM does not recognize the index that already has been created as the same as the index in the SQL file. (If I remove the space, the EM is satisfied. However, the space improves readability, and the EM should be able to handle this.)


Files

T3X_indextest-0_0_1-z-201207131353.t3x (1.09 KB) T3X_indextest-0_0_1-z-201207131353.t3x demo extension Oliver Klee, 2012-07-13 13:55

Related issues 1 (0 open1 closed)

Is duplicate of TYPO3 Core - Bug #63599: Fresh TYPO3 7.0.0 install - Install tool - analyze databaseClosedMathias Schreiber2014-12-05

Actions
Actions #1

Updated by Mathias Schreiber almost 10 years ago

  • Status changed from New to Closed
  • Is Regression set to No

Dupe of #63599

Actions

Also available in: Atom PDF