Hello everyone !
I’ve been using Xibo for few years and I’m encountering a problem I’d like to resolve since the update in 4.0.
I use Xibo to display differents Layouts per player linked with Datasets to show who is in a room at a given time and when nobody is there a standard text.
Everything was running pretty fine but at the 4.0 update, no more “No data” configuration to specify a generic text.
I’ve found a solution by telling the players to run layouts on error and putting my generic text in a “NO DATA” layout which I setup as the default layout. Since I’m using an SQL filter ( NOW() > dtStart AND NOW < dtEnd), when the specified time between dtStart and dtEnd isn’t met, it shows the default layout, else it shows who is in there.
The problem I’m facing is despite the player being at GMT+2 and the CMS at GMT+2, the NOW() SQL function seems to return the UTC time and so I need to lessen 2 hours in my datasets each time. I’m assuming it’s about the function as data doesn’t show as it should in Layout preview.
Does anyone would have some idea so I can fix it please ?