E_FATAL_NOSACHOBJ
Object :: obj_init(...)
------------------------
key_node => sm-master-avs
key_obj => 551
key_evn => Default
SQL => SELECT avs_sm_clnt_nodes.id AS node_id, avs_sm_clnt_nodes.Caption AS node_Caption, avs_sm_clnt_nodes.Note AS node_Note, avs_sm_clnt_nodes.Url AS node_Url, avs_sm_clnt_nodes.EKey AS node_EKey, avs_sm_clnt_objects.id AS obj_id, avs_sm_clnt_objects.Note AS obj_Note, avs_sm_clnt_objects.date AS obj_DATE_YmdHis, DATE_FORMAT(avs_sm_clnt_objects.date,'%Y') as obj_DATE_Y, DATE_FORMAT(avs_sm_clnt_objects.date,'%m') as obj_DATE_m, DATE_FORMAT(avs_sm_clnt_objects.date,'%M') as obj_DATE_F, DATE_FORMAT(avs_sm_clnt_objects.date,'%d') as obj_DATE_d, DATE_FORMAT(avs_sm_clnt_objects.date,'%w') as obj_DATE_w, DATE_FORMAT(avs_sm_clnt_objects.date,'%W') as obj_DATE_l, DATE_FORMAT(avs_sm_clnt_objects.date,'%j') as obj_DATE_j, DATE_FORMAT(avs_sm_clnt_objects.date,'%H') as obj_DATE_H, DATE_FORMAT(avs_sm_clnt_objects.date,'%i') as obj_DATE_i, DATE_FORMAT(avs_sm_clnt_objects.date,'%S') as obj_DATE_s, UNIX_TIMESTAMP(avs_sm_clnt_objects.date) as obj_DATE_utime, if (pm.Par1!='#NOUSE#',avs_sm_clnt_objects.Par1,'#NOUSE#') as obj_PAR_Par1, pm.Par1 AS obj_PAR_Par1Name, if (pm.Par2!='#NOUSE#',avs_sm_clnt_objects.Par2,'#NOUSE#') as obj_PAR_Par2, pm.Par2 AS obj_PAR_Par2Name, if (pm.Par3!='#NOUSE#',avs_sm_clnt_objects.Par3,'#NOUSE#') as obj_PAR_Par3, pm.Par3 AS obj_PAR_Par3Name, if (pm.Par4!='#NOUSE#',avs_sm_clnt_objects.Par4,'#NOUSE#') as obj_PAR_Par4, pm.Par4 AS obj_PAR_Par4Name, if (pm.Par5!='#NOUSE#',avs_sm_clnt_objects.Par5,'#NOUSE#') as obj_PAR_Par5, pm.Par5 AS obj_PAR_Par5Name, if (pm.Par6!='#NOUSE#',avs_sm_clnt_objects.Par6,'#NOUSE#') as obj_PAR_Par6, pm.Par6 AS obj_PAR_Par6Name, if (pm.Par7!='#NOUSE#',avs_sm_clnt_objects.Par7,'#NOUSE#') as obj_PAR_Par7, pm.Par7 AS obj_PAR_Par7Name, e.id AS evn_id, e.Note AS evn_Note, e.Code AS evn_Code FROM avs_sm_clnt_nodes, avs_sm_clnt_objects, avs_sm_clnt_paramaps as pm, avs_sm_clnt_grp_obj_evn as goe, avs_sm_clnt_events as e WHERE avs_sm_clnt_nodes.EKey = 'sm-master-avs' AND avs_sm_clnt_nodes.id = 1 AND avs_sm_clnt_objects.EKey = '551' AND avs_sm_clnt_objects.enabled = 1 AND pm.id = avs_sm_clnt_objects.id_parmap AND goe.id_obj = avs_sm_clnt_objects.id AND e.id = goe.id_evn AND e.EKey = 'Default' GROUP BY avs_sm_clnt_objects.id
------------------------