Xibo update 1.8.2 to 2.3.12: no daypart appears, it is empty

[alex]

I suspect you have deleted the first super admin level user in the system and now the dayparts are owned by a user that no longer exists.

You’ll need to run some SQL on the database to resolve that.

UPDATE `daypart` SET userId = (SELECT userId FROM `user` WHERE usertypeid = 1 LIMIT 1) WHERE userId NOT IN (SELECT userId FROM `user`);
UPDATE `display` SET userId = (SELECT userId FROM `user` WHERE usertypeid = 1 LIMIT 1) WHERE userId NOT IN (SELECT userId FROM `user`);

If you need guidance on running SQL commands, there’s a document here which explains for a Docker-based installation:

How can I run a SQL command when using a Docker Install?

While troubleshooting an issue you maybe asked to run a SQL statement on your database Docker container, or you may want to run a statement yourself for another purpose. To do either of these things there are two options. Using the command line Using the GUI called PhpMyAdmin Command Line Before you can run a statement inside the docker container you will need to find the container name. This can be done using the docker ps command. The resulting output will show a list of running docker con…