W dniu 2014-01-08 16:22, Łukasz Rostalski pisze:
Dzień Dobry, kiedy wybieram:
Komputery -> Lista, wybiera Grupa klientów wywala mi:
Wystąpiły błędy w obsłudze bazy danych! Zapytanie: SELECT n.id AS id, n.ipaddr, inet_ntoa(n.ipaddr) AS ip, ipaddr_pub, inet_ntoa(n.ipaddr_pub) AS ip_pub, n.mac, n.name, n.ownerid, n.access, n.warning, n.netdev, n.lastonline, n.info, CONCAT(c.lastname, ' ', c.name) AS owner, net.name AS netname FROM vnodes n JOIN customersview c ON (n.ownerid = c.id) JOIN networks net ON net.id = n.netidJOIN customerassignments ON (customerid = c.id) WHERE 1=1 AND customergroupid = 28 ORDER BY n.name asc Błąd: 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 'customerassignments ON (customerid = c.id) WHERE 1=1 AND customergroupid = 28 ' at line 6
Znalazłem, w LMS.class.php linia 1736 brakuje spacji na końcu. Zamiast: 'JOIN networks net ON net.id = n.netid' ma być: 'JOIN networks net ON net.id = n.netid '