SQL error [ORA-00937: not a single-group group function] in [SELECT h.host,t.triggerid,t.description,t.expression,t.priority,t.status,count(d.triggerid_up) as dep_count FROM hosts h,items i,functions f, triggers t LEFT JOIN trigger_depends d ON d.triggerid_down=t.triggerid WHERE f.itemid=i.itemid AND h.hostid=i.hostid AND t.triggerid=f.triggerid AND round(t.triggerid/100000000000000) in (0) AND (t.triggerid IN (16730,12784,12809,15290,15885,15283,15296,15284,15318,15026,33972,15016,15234,15237,15233,15263,15268,15261,15106,15112,15370,27026,15088,15084,15117,15343,15170,13549,14131,14132,33977,15419,15444,20916,34802,23458,23439,23433,23448,23428,34822,32082,31727,31726,31824,31833,12777,12791,12796,12811,15297,16723,16733,15028,15003,15022,15035,15033,15214,15349,15344,15223,15224,15225,33974,24511,24644,15083,15380,15381,15118,15186,15341,15335,16737,15185,15192,15191,15176,15168,23677,34797,32080,15439,15433,15449,15428,34800,32070,23296,33980,20893,23266,23280,23434,33982,23419,23436,23444,23430,31713,31715,31732,31721,31827,31830,31831,32085,12778,13001,12793,15294,15887,15358,15359,15305,15311,34792,16715,15324,15010,15017,15354,15239,15353,15350,15250,15355,15271,15262,21648,27028,15115,34796,15174,15334,15173,13548,23681,15410,15413,15437,15421,15451,20905,20891,23285,23284,23271,23257,23437,23453,23424,23449,31725,31737,31720,31734,31813,34003,31838,31837,31828,31819,31832,31812,31821,12768,34791,33971,16732,15304,15317,15323,15023,15034,15037,15345,15203,15231,15266,15253,15267,15274,15273,34795,32084,15103,16614,27022,27024,15338,15187,15182,15164,15193,14134,15875,15450,15435,15443,15432,15427,15415,20903,23297,20895,20896,20915,20912,20904,34801,23258,23268,23259,23270,23281,23265,23279,23264,23269,23420,23438,23427,23443,23432,31714,31722,31730,31731,31835,31823,12769,12787,12792,12805,12806,15357,15303,15308,15014,15013,15024,15042,15025,15021,15004,15038,15351,33973,15213,15222,15208,15238,15254,15243,15275,15248,15278,15257,33975,15122,15108,15101,16107,27008,27012,27016,27020,15336,33976,15188,15198,15177,23680,23678,15411,15434,16738,15453,23300,20917,20890,20908,20911,23283,23263,23418,23457,23455,23441,23450,23452,31836,31816,13997,12782,12788,12795,12810,15319,15322,15312,15301,15307,15302,15320,32081,15039,15869,15027,34793,15210,15346,15228,16735,15264,15265,15244,15277,21649,15090,15093,15104,15105,15107,15376,15114,15333,15183,15181,15195,15197,15425,15874,15438,15445,15448,20892,23295,20920,23301,20897,20899,20894,23282,33981,23261,23267,23276,23426,32083,31738,31711,31719,31733,31729,34823,31815,31834,31822,31826,12783,13003,12797,32086,15306,15360,15293,15314,15313,16713,15032,15031,15008,16734,15242,15232,15216,15240,15217,34794,34563,15272,15094,15119,16736,15111,27010,15102,15113,15340,15342,15339,15184,15202,15163,15194,13995,15412,20785,15424,15436,15414,23299,20901,20889,20914,23256,23454,23421,23456,23447,23422,23451,31736,31728,31717,31825,31814,34790,33970,12789,12790,12798,12808,15356,15886,15315,15288,16717,15040,15226,15347,15352,15221,15227,15235,15204,15279,15282,15256,15280,15877,15876,15096,27014,27018,15120,15097,15199,15200,13547,14133,23298,15442,15446,23294,20918,20919,20906,20902,20898,23255,23262,23273,23260,23277,23435,23446,31735,34002,31723,31724,31712,31716,31811,31820,31817,31829)) AND h.status in (0,1) AND h.hostid=10055]

?????? ?????????? ??? ?????? ???????? ? popup.php ? ????????.
?????? ? ?????? 719/1451:
' AND h.hostid='.$hostid;
' GROUP BY h.host, t.triggerid, t.description, t.expression, t.priority, t.status'.
' ORDER BY h.host,t.description';

?????
' AND h.hostid='.$hostid.
' GROUP BY h.host, t.triggerid, t.description, t.expression, t.priority, t.status'.
' ORDER BY h.host,t.description';