Dzień Dobry
Przy probie upgradu bazy, jak i probie utworzenia recznie tego widoku dostaje : ERROR 1054 (42S22): Unknown column 'n.shortname' in 'field list'
mysql> CREATE VIEW nas AS -> SELECT n.id, inet_ntoa(n.ipaddr) AS name, n.shortname, n.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; ERROR 1054 (42S22): Unknown column 'n.shortname' in 'field list'
Prosze o pomoc.
LMS 1.11.8 Belus (1.981/1.23) DB: 2009051200
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;
uczestnicy (2)
-
A.L.E.C -
R99 na wp