I have recently installed a new Xibo server, which is working apart from a few niggles. I have created some layouts and got them showing on a windows client, but can not view any media I upload into the library.
Going to Library->Media shows no entries, and the footer states “Showing 0 to 0 of 0 entries (filtered from NaN total entries)”
The error log displays the following error :
SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 0, 10’ at line 29 Exception Type: PDOException
I am using server 2.2.1
Any help would be gratefully received