Montato db su
Tipo di server: Percona Server
Versione del server: 5.7.32-35-log - Percona Server (GPL), Release 35, Revision 5688520
su aggiornamento db si ottiene errore:
[2021-11-09 13:22:43] Logs.EMERGENCY: Aggiornamento fallito: ALTER TABLE my_componenti
ADD FOREIGN KEY (id_intervento
) REFERENCES in_interventi
(id
) ON DELETE SET NULL, ADD FOREIGN KEY (id_sostituzione
) REFERENCES my_componenti
(id
) ON DELETE SET NULL, ADD FOREIGN KEY (id_impianto
) REFERENCES my_impianti
(id
) ON DELETE CASCADE, ADD FOREIGN KEY (id_articolo
) REFERENCES mg_articoli
(id
) ON DELETE CASCADE []
{"url":"/Azienda/index.php?action=do_update&firstuse=false","ip":"11.222.22.444","http_method":"GET","server":"www.xxx.it","referrer":"https://www.xxx.it/Azienda/index.php","unique_id":"YYpoEmRfVLBO9XwIDSiM7QAAAA8","uid":"1fc3dd0"}
eseguito query direttamente su Server SQL
ALTER TABLE
my_componentiADD FOREIGN KEY (
id_intervento) REFERENCES
in_interventi(
id) ON DELETE SET NULL, ADD FOREIGN KEY (
id_sostituzione) REFERENCES
my_componenti(
id) ON DELETE SET NULL, ADD FOREIGN KEY (
id_impianto) REFERENCES
my_impianti(
id) ON DELETE CASCADE, ADD FOREIGN KEY (
id_articolo) REFERENCES
mg_articoli(
id) ON DELETE CASCADE
si ottiene:
#1452 - Cannot add or update a child row: a foreign key constraint fails (nomedatabase
.#sql-6133d_24fa9297
, CONSTRAINT #sql-6133d_24fa9297_ibfk_3
FOREIGN KEY (id_impianto
) REFERENCES my_impianti
(id
) ON DELETE CASCADE)
Dunque il problema non era la versione database
Stefano