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

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