[lms] Re: Wyciagniecie z bazy klientow przypisanych do urzadzen

dezertertoja napisał(a):

Cos nie tak jest wyskakuje cos takiego

mysql> SELECT netdevices.name, SUM(*) FROM nodes, netdevices WHERE netdevices.id = netdev AND ownerid > 0 -> GROUP BY netdev, netdevices.name; ERROR 1064 (42000): 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 '*) FROM nodes, netdevices WHERE netdevices.id = netdev AND ownerid > 0 GROUP BY ' at line 1

dodam ze mysql to 5.0.22 i lms 1.8.2

zamien sum(*) na COUNT(*) i będzie ok -- Marek