Missing Displays after Update

[Gustel]

Hi Xibo-Team,

after upgrading from V2.3.11 to V3.0.1, 2 displays are missing from Calendar (but are present under Displays):

V3.0.1:

In V2.3.11 the Displays are present:

V2.3.11:

This happened after the update from V2.3.10 to V3.0.0 as well.

PS: And they are not wrongly ordered, the are simply not in the list.

Best Reagrds

[natasha]

Hi, try running the SQL command as in the post below:

After update 3.0.0 - Calendar not showing all displays

@Peter has looked at this for you and somehow you have display groups not owned by a user. There was an old bug along those lines, so it’s potentially something historical that has slipped under the radar so to speak. We’re fairly certain you’d have seen the same in 2.3 though, and can’t explain why you didn’t right now. You can run the following SQL on your 3.0.0 database to resolve that issue: UPDATE `displaygroup` SET userId = (SELECT userId FROM `user` WHERE usertypeid = 1 LIMIT 1) WHERE…

[Gustel]

Hi Natasha,

thank you! This brought back our displays!

Just for other user having the same issue, the following command was not working:
mysql -u cms -h mysql -p cms

I needed the following:
mysql -u cms -h localhost -p cms

Found the solution here:

Local installation: Unknown MySQL server host

Regards