FUNCTION xibodb.X does not exist

Hello All,

We have a 1.7.9 test installation of Xibo on Win Server 2012. Everything seems to work ok, but when we want to add license to screen with ‘Edit’ button in screen section we get ‘Unknown error’. After debugging we got something like this:

--------------------------------------
LOG Dump
--------------------------------------
Date,Page,Function,Message
"2017-06-06 07:51:42","display","","SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION xibodb.X does not exist"
"2017-06-06 07:51:42","Data Module","SetError","Data Class: Error Number [1] Error Message [Unknown error]"
"2017-06-06 07:51:42","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>
"
"2017-06-06 07:51:42","display","","Creating a Response Manager to deal with the HALT Error."
"2017-06-06 07:51:39","Display","ValidateDisplays","Timed out display. Last Accessed: 1970-01-01 01:00:00. Time out: 1970-01-01 01:12:00"
"2017-06-06 07:51:39","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' => '',
)."
"2017-06-06 07:51:38","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 "
"2017-06-06 07:50:29","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>
"
"2017-06-06 07:50:28","display","","SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION xibodb.X does not exist"

--------------------------------------

Anyone have this problem before? Thanks for any help!

Well, that is interesting - from MySQL docs:

I’ve submitted a bug for it:

To workaround your issue, you could edit /lib/data/display.data.class.php at Line 75, changing it to:

SELECT display.*, displaygroup.displaygroupid, displaygroup.description, ST_X(display.GeoLocation) AS Latitude, ST_Y(display.GeoLocation) AS Longitude

It’s working now! Thanks, dan!

1 Like