Can't delete display xibo 1.8.11

Get Help
1

Hi Everyone.

Im having an issue when i try to delete one of my displays:

image
image885×304 5.37 KB

is the only one that show that error.

here is my troubleshoot log:

https://barcelogroup-my.sharepoint.com/:u:/g/personal/maya_it2_barcelo_com/EYtpK2UETy1Jk3OkzjiCtjIB5nX-eaJxkNOEqGyM2ngEJA?e=HiQEl6

2

Are you using manual or docker installation?

You can make a check on the display permission settings.

3

It is a docker installation.

this is the permisssions asigned to this display.

image
image884×734 15.3 KB

4

Digging in the log, i found this error:

25916,f64bc81,“2018-08-24 12:54:27”,WEB,/display/53,DELETE,"SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (cms.lktagmedia, CONSTRAINT lktagmedia_ibfk_1 FOREIGN KEY (mediaId) REFERENCES media (mediaID))#0 /var/www/cms/lib/Storage/PdoStorageService.php(239): PDOStatement->execute(Array)

I dont know if i should delete the display directly in mysql, or try to add the key and then try to delete it using the GUI.

5

That would be due to this bug - https://github.com/xibosignage/xibo/issues/1632

It will be fixed in 1.8.12.

We will also attempt to put a function in place to clear any existing issues with db on upgrade.

6

I should mention I also saw the bug when trying to assign a display settings profile to a display. Same error as pasted above.

7

Just to clarify, this issue is resolved in latest 1.8 xibo.

Is there any way i can mark this as solved?