<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:14px"><div id="yui_3_16_0_ym19_1_1472786460498_13314" dir="ltr">DBIx error in webserver log:</div><div id="yui_3_16_0_ym19_1_1472786460498_13379" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1472786460498_13374" dir="ltr">[cgi:error] [pid 29640] ... AH01215: Can't locate object method "HAVING" via package "COUNT" (perhaps you forgot to load "COUNT"?)</div><div id="yui_3_16_0_ym19_1_1472786460498_13373" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1472786460498_13372" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1472786460498_13369" dir="ltr">the query:</div><div id="yui_3_16_0_ym19_1_1472786460498_13370" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1472786460498_13371" dir="ltr">my $obj_rs = $schema->resultset('itemList')->serach(<br id="yui_3_16_0_ym19_1_1472786460498_13413"> { t_id => { -in => [ $tStr ] }},<br id="yui_3_16_0_ym19_1_1472786460498_13414"> {<br id="yui_3_16_0_ym19_1_1472786460498_13415"> group_by => [ qw(i_id) ],<br id="yui_3_16_0_ym19_1_1472786460498_13416"> HAVING COUNT('t_id') = $tCount<br id="yui_3_16_0_ym19_1_1472786460498_13417"> }<br id="yui_3_16_0_ym19_1_1472786460498_13418"> );</div><div id="yui_3_16_0_ym19_1_1472786460498_13437" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1472786460498_13555" dir="ltr"><br></div><div dir="ltr">currently database has no records which match the query. but i was not expecting such an error.</div><div id="yui_3_16_0_ym19_1_1472786460498_13556" dir="ltr"><br></div><div dir="ltr">what is wrong in my statement?</div><div id="yui_3_16_0_ym19_1_1472786460498_13557" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1472786460498_13558" dir="ltr">thank you.</div><div id="yui_3_16_0_ym19_1_1472786460498_13569" dir="ltr">Rajeev<br></div></div></body></html>