In my case I tried to add a translation manually:
SQL query:
INSERT INTO ps23_translation( `id_lang` , `key` , `translation` , `domain` , `theme` ) VALUES ( 1, 'Order with an obligation to pay', 'Submit Order', 'ShopThemeCheckout', 'altrezo' ) ;
MySQL said:
#1452 - Cannot add or update a child row: a foreign key constraint fails (`northwe3_pres559`.`ps23_translation`, CONSTRAINT `FK_F874C02DBA299860` FOREIGN KEY (`id_lang`) REFERENCES `ps23_lang` (`id_lang`))
I wonder if this is the error prestashop is having. It's a weird error because the target row DOES exist in ps23_lang. Completely stumped by this one.