Re: [lms] Blad po upgrade do biezacej cvs

Nie chce byc namolny czy cos, ale CREATE VIEW vnodes_mac AS SELECT nodeid, GROUP_CONCAT(mac SEPARATOR ',' ORDER BY id) AS mac FROM macs GROUP BY nodeid zwraca mi #1064 - 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 'ORDER BY id) AS mac FROM macs GROUP BY nodeid' at line 2

A takie dziala CREATE VIEW vnodes_mac AS SELECT nodeid, GROUP_CONCAT(mac SEPARATOR ',' ) AS mac FROM macs GROUP BY nodeid ORDER BY id

Pozdrawiam :)