Re: [lms] Unknown column 'n.shortname' in 'field list'

R99 na wp wrote:

Przy probie upgradu bazy, jak i probie utworzenia recznie tego widoku dostaje : ERROR 1054 (42S22): Unknown column 'n.shortname' in 'field list'

Oto poprawna definicja:

CREATE VIEW nas AS SELECT n.id, inet_ntoa(n.ipaddr) AS nasname, d.shortname, d.nastype AS type, d.clients AS ports, d.secret, d.community, d.description FROM nodes n JOIN netdevices d ON (n.netdev = d.id) WHERE n.nas = 1;