Ho anch'io lo stesso problema, ma solo da alcuni giorni, e non capisco perché.
Non è strettamente legato alla versione, perché ne ho un'altra copia attiva col DataBase molto più sgombro e lì funziona...
Ho provato ad attivare il Log di MySQL e questo è il risultato
2019-02-18T17:58:29.619756Z 10 Connect osmgps@localhost on osmgps using Socket
2019-02-18T17:58:29.621386Z 10 Prepare select * from information_schema.tables where table_schema = ? and table_name = ?
2019-02-18T17:58:29.622444Z 10 Close stmt
2019-02-18T17:58:29.622887Z 10 Prepare select * from `zz_users` where `zz_users`.`id` = ? limit 1
2019-02-18T17:58:29.622975Z 10 Execute select * from `zz_users` where `zz_users`.`id` = 3 limit 1
'updates'
2019-02-18T17:58:29.627100Z 10 Execute SELECT * FROM `updates` WHERE `done` != 1 OR `done` IS NULL ORDER BY `done` DESC, `id` 1
2019-02-18T17:58:29.635430Z 10 Close stmt
2019-02-18T17:58:29.635930Z 10 Prepare select `zz_groups`.*, `zz_permissions`.`idmodule` as `pivot_idmodule`, `zz_permissions`.`idgruppo` as `pivot_idgruppo`, `zz_permissions`.`permessi` as `pivot_permessi` from `zz_groups` inner join `zz_permissions` on `zz_gr2019-02-18T17:58:29.636234Z 10 Close stmt
.`idgruppo` as `pivot_idgruppo`, `zz_permissions`.`permessi` as `pivot_permessi` from `zz_groups` inner join `zz_permissions` on `zz_groups`.`id` = `zz_permissions`.`idgruppo` where `zz_permissions`.`idmodule` in (1, 2, 3, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 20,2019-02-18T17:58:29.639384Z 10 Execute select * from `zz_plugins` where `zz_plugins`.`idmodule_to` in (1, 2, 3, 6, 7, 8, 9, 102019-02-18T17:58:29.642670Z 10 Prepare select * from `zz_modules` where `parent` is null order by `order` asc
2019-02-18T17:58:29.644554Z 10 Close stmt
2019-02-18T17:58:29.645065Z 10 Prepare select * from `zz_modules` where `zz_modules`.`parent` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?2019-02-18T17:58:29.645997Z 10 Prepare select * from `zz_modules` where `zz_modules`.`parent` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?.`idgruppo` as `pivot_idgruppo`, `zz_permissions`.`permessi` as `pivot_permessi` from `zz_groups` inner join `zz_permissions` on `zz_gr2019-02-18T17:58:29.648092Z 10 Execute select `zz_groups`.*, `zz_permissions`.`idmodule` as `pivot_idmodule`, `zz_permissions`25, 26, 27, 28, 29, 31, 32, 36, 38, 39, 40, 41, 50, 51, 53, 54, 56, 57, 60, 62, 64)
.`idgruppo` as `pivot_idgruppo`, `zz_permissions`.`permessi` as `pivot_permessi` from `zz_groups` inner join `zz_permissions` on `zz_groups`.`id` = `zz_permissions`.`idgruppo` where `zz_permissions`.`idmodule` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2019-02-18T17:58:29.649315Z 10 Execute select `zz_groups`.*, `zz_permissions`.`idmodule` as `pivot_idmodule`, `zz_permissions`.`idgruppo` as `pivot_idgruppo`, `zz_permissions`.`permessi` as `pivot_permessi` from `zz_groups` inner join `zz_permissions` on `zz_groups`.`id` = `zz_permissions`.`idgruppo` where `zz_permissions`.`idmodule` in (1, 2, 3, 12, 20, 30, 33, 34, 35, 37, 52, 55, 61)
2019-02-18T17:58:29.649642Z 10 Close stmt
2019-02-18T17:58:29.661929Z 10 Query START TRANSACTION
2019-02-18T17:58:29.663133Z 10 Close stmt
2019-02-18T17:58:29.663715Z 10 Prepare SELECT *, (SELECT tipo FROM an_anagrafiche WHERE idanagrafica = in_interventi.idanagrafica) AS tipo_anagrafica, (SELECT completato FROM in_statiintervento WHERE idstatointervento=in_interventi.idstatointervento) AS flag_completato, IF((in_interventi.idsede = 0), (SELECT idzona FROM an_anagrafiche WHERE idanagrafica = in_interventi.idanagrafica), (SELECT idzona FROM an_sedi WHERE id = in_interventi.idsede)) AS idzona, (SELECT colore FROM in_statiintervento WHERE idstatointervento=in_interventi.idstatointervento) AS colore, (SELECT idcontratto FROM co_promemoria WHERE idintervento=in_interventi.id LIMIT 0,1) AS idcontratto, in_interventi.id_preventivo as idpreventivo FROM in_interventi WHERE id='1258'
2019-02-18T17:58:29.663998Z 10 Execute SELECT *, (SELECT tipo FROM an_anagrafiche WHERE idanagrafica = in_interventi.idanagrafica) AS tipo_anagrafica, (SELECT completato FROM in_statiintervento WHERE idstatointervento=in_interventi.idstatointervento) AS flag_completato, IF((in_interventi.idsede = 0), (SELECT idzona FROM an_anagrafiche WHERE idanagrafica = in_interventi.idanagrafica), (SELECT idzona FROM an_sedi WHERE id = in_interventi.idsede)) AS idzona, (SELECT colore FROM in_statiintervento WHERE idstatointervento=in_interventi.idstatointervento) AS colore, (SELECT idcontratto FROM co_promemoria WHERE idintervento=in_interventi.id LIMIT 0,1) AS idcontratto, in_interventi.id_preventivo as idpreventivo FROM in_interventi WHERE id='1258'
2019-02-18T17:58:29.664503Z 10 Close stmt
2019-02-18T17:58:29.665534Z 10 Prepare select * from `mg_articoli` where `mg_articoli`.`id` = ? limit 1
2019-02-18T17:58:29.665650Z 10 Execute select * from `mg_articoli` where `mg_articoli`.`id` = '90' limit 1
2019-02-18T17:58:29.665852Z 10 Close stmt
2019-02-18T17:58:29.666339Z 10 Prepare select * from `in_interventi` where `in_interventi`.`id` = ? limit 1
2019-02-18T17:58:29.666393Z 10 Execute select * from `in_interventi` where `in_interventi`.`id` = '1258' limit 1
2019-02-18T17:58:29.666570Z 10 Close stmt
2019-02-18T17:58:29.667875Z 10 Prepare select * from `co_iva` where `co_iva`.`id` is null limit 1
2019-02-18T17:58:29.667913Z 10 Execute select * from `co_iva` where `co_iva`.`id` is null limit 1
2019-02-18T17:58:29.668062Z 10 Close stmt
2019-02-18T17:58:29.726831Z 10 Prepare select * from `co_ritenutaacconto` where `co_ritenutaacconto`.`id` is null limit 1
2019-02-18T17:58:29.727112Z 10 Execute select * from `co_ritenutaacconto` where `co_ritenutaacconto`.`id` is null limit 1
2019-02-18T17:58:29.727303Z 10 Close stmt
2019-02-18T17:58:29.774537Z 10 Prepare select * from `co_rivalsainps` where `co_rivalsainps`.`id` is null limit 1
2019-02-18T17:58:29.774814Z 10 Execute select * from `co_rivalsainps` where `co_rivalsainps`.`id` is null limit 1
2019-02-18T17:58:29.775154Z 10 Close stmt
2019-02-18T17:58:29.799179Z 10 Prepare insert into `zz_operations` (`id_module`, `id_plugin`, `id_record`, `id_utente`, `op`, `options`) values (?, ?, ?, ?, ?, ?)
2019-02-18T17:58:29.799403Z 10 Execute insert into `zz_operations` (`id_module`, `id_plugin`, `id_record`, `id_utente`, `op`, `options`) values (3, NULL, '1258', 3, 'addarticolo', NULL)
2019-02-18T17:58:29.799706Z 10 Close stmt
2019-02-18T17:58:29.799923Z 10 Query ROLLBACK
2019-02-18T17:58:29.800952Z 10 Quit
È particolarmente strano questo ROLLBACK alla fine... come se qualcosa andasse storto e il software chiedesse di annullare l'operazione, ma non ho idea del perché lo faccia. Sospetto ancora i seriali, anche se in questo caso non dovrebbero entraci un gran che, ma è l'operazione più sostanziosa che ho fato di recente (v. altro post in altro thread).
COME SI PUÒ FARE DEBUG?
Ho attivo quello di PHP ma non lo so usare un gran che, e le query riportate qui sopra non le elenca ad esempio. Help!!!
