Feature #24869

Enhance Upgrade Wizard SQL queries verbosity and error handling

Added by Ernesto Baschny almost 9 years ago. Updated almost 2 years ago.

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

0%

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

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

History

#1 Updated by Xavier Perseguers over 8 years ago

  • Target version changed from 4.6.0 to 4.6.0-beta1

#2 Updated by Xavier Perseguers over 8 years ago

  • Target version deleted (4.6.0-beta1)

#3 Updated by Ernesto Baschny almost 6 years ago

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

#4 Updated by Mathias Schreiber almost 5 years ago

  • Target version set to 8 LTS

#5 Updated by Riccardo De Contardi over 2 years ago

  • Target version changed from 8 LTS to 9.0

#6 Updated by Benni Mack about 2 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?

#7 Updated by Christian Kuhn almost 2 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.

Also available in: Atom PDF