From 475d328960a7e4c4545b595b4783ee59226cb0e9 Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Thu, 8 Sep 2016 11:08:21 +0200 Subject: [roomplanner] Fix key constraint error on room saving --- modules-available/roomplanner/page.inc.php | 11 +---------- 1 file changed, 1 insertion(+), 10 deletions(-) diff --git a/modules-available/roomplanner/page.inc.php b/modules-available/roomplanner/page.inc.php index 5c58789c..ecbf9d1f 100644 --- a/modules-available/roomplanner/page.inc.php +++ b/modules-available/roomplanner/page.inc.php @@ -87,15 +87,6 @@ class Page_Roomplanner extends Page if ($this->action === 'getmachines') { $query = Request::get('query', false, 'string'); - /* the query could be anything: UUID, IP or macaddr */ -// $result = Database::simpleQuery('SELECT machineuuid, macaddr, clientip, hostname ' -// . ', MATCH (machineuuid, macaddr, clientip, hostname) AGAINST (:query) AS relevance ' -// . 'FROM machine ' -// . 'WHERE MATCH (machineuuid, macaddr, clientip, hostname) AGAINST (:query) ' -// . 'ORDER BY relevance DESC ' -// . 'LIMIT 5' -// , ['query' => $query]); -// $result = Database::simpleQuery('SELECT machineuuid, macaddr, clientip, hostname ' . 'FROM machine ' . 'WHERE machineuuid LIKE :query ' @@ -204,7 +195,7 @@ class Page_Roomplanner extends Page 'locationid' => $this->locationid, 'roomplan' => $obj, 'managerip' => Request::post('managerip', '', 'string'), - 'tutoruuid' => '' // TODO + 'tutoruuid' => null // TODO ]); } -- cgit v1.2.3-55-g7522