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!
