E_FATAL_NOSACHOBJ
Object :: obj_init(...)
------------------------
key_node => sm-master-avs
key_obj => 591
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 = '591'
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
------------------------