SQL Error while importing Layouts from ZIP


we’ve set up a fresh XIBO Installation (Docker vairant).
I’ve ex- and imported 4 existing layouts from an existing XIBO instance what worked like a charm.

Now if i try to import additional Layouts i recieve the following error message within the import dialog after hitting the “upload” button:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (xibo_cms_db.lkwidgetmedia, CONSTRAINT lkwidgetmedia_ibfk_2 FOREIGN KEY (mediaId) REFERENCES media (mediaId))

The zip files have around 110 Kb in size and contain some text and only one image.

any idea what might went wrong and how to fix this?


I am having the same trouble… In my case, the whole file is only 2k and has only webpage content.