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 -- Pozdrowienia, Rafał !DSPAM:4a290ee684301310814384!
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; -- Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252 LAN Management System Developer http://lms.org.pl Roundcube Webmail Developer http://roundcube.net !DSPAM:4a2aaaa8154736908914954!
uczestnicy (2)
-
A.L.E.C -
R99 na wp