Project

General

Profile

Actions

Feature #24869

closed

Enhance Upgrade Wizard SQL queries verbosity and error handling

Added by Ernesto Baschny almost 14 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Should have
Category:
Install Tool
Target version:
Start date:
2011-01-28
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

Currently every individual Upgrade Wizard class does its own SQL processing and error handling. There is no central API for an Upgrade Wizard to push their queries in.

Result is that many wizards do no error checking at all and the result is that the user interface doesn't really help in case of an error.

The second problem is that wizards which install some new extension might execute lots of "CREATE TABLE" statements which are neither logged nor displayed to the user (even if he chose to "display SQL queries").

First find an unified method for upgrade wizards to UPDATE / INSERT / REPLACE stuff in the database (with logging and using the same way of catching, displaying and handling the errors).

Second, to catch also the extension installation queries (CREATE TABLE) one idea would be to add the query logging to the underlying layer (t3lib_db) in some API where the upgrade wizard could fetch them at any time (or as a collected list at the end). Or to some layer above, maybe in the EM classes which fire those queries.
(issue imported from #M17377)


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #24682: Queries triggered by extension installation are not displayedClosed2011-01-20

Actions
Actions #1

Updated by Xavier Perseguers over 13 years ago

  • Target version changed from 4.6.0 to 4.6.0-beta1
Actions #2

Updated by Xavier Perseguers over 13 years ago

  • Target version deleted (4.6.0-beta1)
Actions #3

Updated by Ernesto Baschny about 11 years ago

  • Category set to Install Tool
  • Parent task set to #24849
Actions #4

Updated by Mathias Schreiber almost 10 years ago

  • Target version set to 8 LTS
Actions #5

Updated by Riccardo De Contardi almost 8 years ago

  • Target version changed from 8 LTS to 9.0
Actions #6

Updated by Benni Mack about 7 years ago

  • Status changed from New to Needs Feedback
  • Assignee set to Christian Kuhn
  • Target version changed from 9.0 to 9 LTS
  • Parent task deleted (#24849)

Lolli, can you post the current status?

Actions #7

Updated by Christian Kuhn almost 7 years ago

  • Status changed from Needs Feedback to Closed

this would require a full new migration approach. if done, it should have a full concept outlined including risk and decision assessment. this issue here is not enough to tackle such an approach and i hope it is ok if i close it for now.

Actions

Also available in: Atom PDF