Unknown error when "edit display"

Get Help
1

I’m trying to register a new display, but when I select “edit” it responds with “unknown error”. See below for the log.
I’ve tried to Google and tried searching the Xibo community but with no luck, any help would be greatly appreciated!

404
17-01-13 03:53:11
CMS
display
Unknown Error
256
User Error
D:\xibo-cms-1.7.9\Xibo\lib\pages\display.class.php
199

403
17-01-13 03:53:11
CMS
display
SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION xibodb.X does not exist

2

Could you look at Report Fault page, make sure there are no ‘X’ there.
It might be a good idea to enable debugging and recreate the problem, then look at Logs page for more details.

It failed to load display, are there any other issues with your db or is it working fine? What’s the display’s name?

You can also have a look at permissions on your web server perhaps.

3

Thanks,
there’s a “!” on the internationalization row, otherwise everyhing looks fine.
I trurned on debugging and get the below log.

432	17-01-18 05:05:21	CMS	User	DisplayList	SQL: SELECT display.displayid, display.display, displaygroup.description, layout.layout, display.loggedin, IFNULL(display.lastaccessed, 0) AS lastaccessed, display.inc_schedule, display.licensed, display.email_alert, displaygroup.DisplayGroupID, display.ClientAddress, display.MediaInventoryStatus, display.MacAddress, display.client_type, display.client_version, display.client_code, display.screenShotRequested, display.storageAvailableSpace, display.storageTotalSpace, currentLayout.layout AS currentLayout, currentLayout.layoutId AS currentLayoutId FROM display INNER JOIN lkdisplaydg ON lkdisplaydg.DisplayID = display.DisplayID INNER JOIN displaygroup ON displaygroup.DisplayGroupID = lkdisplaydg.DisplayGroupID LEFT OUTER JOIN layout ON layout.layoutid = display.defaultlayoutid LEFT OUTER JOIN layout currentLayout ON currentLayout.layoutId = display.currentLayoutId WHERE displaygroup.IsDisplaySpecific = 1 ORDER BY displayid. Params: array (
).
431	17-01-18 05:05:14	CMS	display		Creating a Response Manager to deal with the HALT Error.
430	17-01-18 05:05:14	CMS	display		<errormsg>Unknown Error</errormsg>
<errornum>256</errornum>
<errortype>User Error</errortype>
<scriptname>D:\xibo-cms-1.7.9\Xibo\lib\pages\display.class.php</scriptname>
<scriptlinenum>199</scriptlinenum>
429	17-01-18 05:05:14	CMS	Data Module	SetError	Data Class: Error Number [1] Error Message [Unknown Error]
428	17-01-18 05:05:14	CMS	display		SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION xibodb.X does not exist
427	17-01-18 05:05:11	CMS	User	DisplayList	SQL: SELECT display.displayid, display.display, displaygroup.description, layout.layout, display.loggedin, IFNULL(display.lastaccessed, 0) AS lastaccessed, display.inc_schedule, display.licensed, display.email_alert, displaygroup.DisplayGroupID, display.ClientAddress, display.MediaInventoryStatus, display.MacAddress, display.client_type, display.client_version, display.client_code, display.screenShotRequested, display.storageAvailableSpace, display.storageTotalSpace, currentLayout.layout AS currentLayout, currentLayout.layoutId AS currentLayoutId FROM display INNER JOIN lkdisplaydg ON lkdisplaydg.DisplayID = display.DisplayID INNER JOIN displaygroup ON displaygroup.DisplayGroupID = lkdisplaydg.DisplayGroupID LEFT OUTER JOIN layout ON layout.layoutid = display.defaultlayoutid LEFT OUTER JOIN layout currentLayout ON currentLayout.layoutId = display.currentLayoutId WHERE displaygroup.IsDisplaySpecific = 1 ORDER BY displayid. Params: array (
'displaygroupid' => 0,
'display' => '',
'macAddress' => '',
'clientVersion' => '',
).
426	17-01-18 05:05:11	CMS	Display	ValidateDisplays	Timed out display. Last Accessed: 1970-01-01 01:00:00. Time out: 1970-01-01 01:12:00
425	17-01-18 05:05:11	CMS	Display	ValidateDisplays	Timed out display. Last Accessed: 1970-01-01 01:00:00. Time out: 1970-01-01 01:12:00
424	17-01-18 05:05:10	CMS	display		Retreiving list of displaygroups for xibo with SQL: SELECT displaygroup.DisplayGroupID, displaygroup.DisplayGroup, displaygroup.IsDisplaySpecific, displaygroup.Description FROM displaygroup WHERE 1 = 1 AND displaygroup.IsDisplaySpecific = 0 ORDER BY displaygroup.DisplayGroup
4

Any clues on what to look for based on the below error message?
(I have tried from three different dislays and get the same result. The server and displays are running on a corporate network, but communication is only over http (port 80) or https (443) right?