Pdo exception: PDOException SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_bin,NONE) and (utf8_general_ci,COERCIBLE) for operation 'ifnull' (HY000) at file /var/www/html/RackTables/inc/database.php, line 3845 /var/www/html/RackTables/inc/database.php:3845 execute(Array ( [0] => 24 [1] => 24 [2] => 13614 [3] => 1508 ) ) /var/www/html/plugins/Linkmgmt.php:1839 usePreparedSelectBlade('SELECT remotePort.id, CONCAT(IFNULL(remoteObject.name, CONCAT('[',remoteObjectDictionary.dict_value,']')), ' : ', remotePort.name, IFNULL(CONCAT(' == ', IFNULL(IFNULL(infolnk_a.cable,infolnk_b.cable),''), ' ==> ', InfoPort.name, ' : ', IFNULL(InfoObject.name,CONCAT('[',InfoObjectDictionary.dict_value,']'))),'') ) as Text FROM Port as remotePort LEFT JOIN Object as remoteObject on remotePort.object_id = remoteObject.id LEFT JOIN Dictionary as remoteObjectDictionary on (remoteObjectDictionary.chapter_id = 1 AND remoteObject.objtype_id = remoteObjectDictionary.dict_key) LEFT JOIN LinkBackend as infolnk_a on remotePort.id = infolnk_a.porta LEFT JOIN LinkBackend as infolnk_b on remotePort.id = infolnk_b.portb LEFT JOIN Port as InfoPort on InfoPort.id = IFNULL(infolnk_a.portb, infolnk_b.porta) LEFT JOIN Object as InfoObject on InfoObject.id = InfoPort.object_id LEFT JOIN Dictionary as InfoObjectDictionary on (InfoObject.objtype_id = InfoObjectDictionary.dict_key AND InfoObjectDictionary.chapter_id = 1) LEFT JOIN Link as lnk_a on remotePort.id = lnk_a.porta LEFT JOIN Link as lnk_b on remotePort.id = lnk_b.portb INNER JOIN PortInnerInterface pii ON remotePort.iif_id = pii.id INNER JOIN Dictionary d ON d.dict_key = remotePort.type INNER JOIN ( SELECT Port.id FROM Port INNER JOIN ( SELECT DISTINCT pic2.iif_id FROM PortInterfaceCompat pic2 INNER JOIN PortCompat pc ON pc.type2 = pic2.oif_id WHERE pc.type1 = ? AND pic2.iif_id <> 1 ) AS sub1 USING (iif_id) UNION SELECT Port.id FROM Port INNER JOIN PortCompat ON type1 = type WHERE iif_id = 1 and type2 = ? ) AS sub2 ON sub2.id = remotePort.id WHERE remotePort.id <> ? AND lnk_a.porta is NULL AND lnk_b.portb is NULL AND remotePort.object_id IN (SELECT DISTINCT object_id FROM RackSpace WHERE rack_id IN (?)) ORDER BY remoteObject.name ,remotePort.name', Array ( [0] => 24 [1] => 24 [2] => 13614 [3] => 1508 ) ) /var/www/html/plugins/Linkmgmt.php:1946 linkmgmt_findSparePorts(Array ( [id] => 13614 [name] => 1 [object_id] => 1857 [object_name] => LDC-AC-TEST [l2address] => [label] => [reservation_comment] => [iif_id] => 1 [oif_id] => 24 [iif_name] => hardwired [oif_name] => 1000Base-T [cableid] => [remote_id] => [remote_name] => [remote_object_id] => [remote_object_name] => [log_count] => 0 [linked] => 0 [last_log] => Array ( ) ) , Array ( [racks] => Array ( [0] => 1508 ) [objects] => [object_id] => [ports] => ) , 'front', , , , 1) linkmgmt_renderPopupPortSelector() /var/www/html/RackTables/inc/functions.php:5285 call_user_func_array('linkmgmt_renderPopupPortSelector', Array ( ) ) /var/www/html/plugins/Linkmgmt.php:1635 getOutputOf('linkmgmt_renderPopupPortSelector') linkmgmt_opPortLinkDialog() /var/www/html/RackTables/index.php:235 call_user_func('linkmgmt_opPortLinkDialog') Error info: Array ( [0] => HY000 [1] => 1267 [2] => Illegal mix of collations (utf8_bin,NONE) and (utf8_general_ci,COERCIBLE) for operation 'ifnull' ) Parameters: GET module redirect page object tab linkmgmt object_id 1856 allports 1 op PortLinkDialog port 13614 linktype front POST COOKIE PHPSESSID fa69geubgq1nodcvv30siveiq0