Feature #24869
closedEnhance Upgrade Wizard SQL queries verbosity and error handling
0%
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)
Updated by Xavier Perseguers about 13 years ago
- Target version changed from 4.6.0 to 4.6.0-beta1
Updated by Xavier Perseguers about 13 years ago
- Target version deleted (
4.6.0-beta1)
Updated by Ernesto Baschny over 10 years ago
- Category set to Install Tool
- Parent task set to #24849
Updated by Riccardo De Contardi over 7 years ago
- Target version changed from 8 LTS to 9.0
Updated by Benni Mack almost 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?
Updated by Christian Kuhn over 6 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.