Issue Bug Closed

#78529Exception thrown in Install Tool > Upgrade Wizard

Frank Nägler 11/01/16, 11:31 updated 10/17/17, 23:24

Description

In case of wrong ext_tables.php file – e.g. a missing comma – the UpgradeWizard in Install tool throws an exception.

This can be tested, by removing a comma after a column definition.

example:
*no error, SQL is correct*

CREATE TABLE tx_foo_bar (
  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,
  title tinytext,
  description text,
  content text,

  PRIMARY KEY (uid),
  KEY parent (pid)
);

error, SQL is NOT correct, missing comma after column title

CREATE TABLE tx_foo_bar (
  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,
  title tinytext
  description text,
  content text,

  PRIMARY KEY (uid),
  KEY parent (pid)
);

To reproduce this issue:
1) use any ext_tables.sql file and remove a comma.
2) Go to Install Tool
3) Click on Upgrade Wizard
=> Exception thrown

Reviews 1