<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px">no, nodeID is auto increment field as seen in tabel description. it is complaining there is no such key. i dont know why...<br><div id="yui_3_16_0_ym19_1_1503322935090_7807"><span></span></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"><font face="Arial" size="2"> On Monday, August 21, 2017 7:39 AM, tirveni yadav <yadav.tirveni@gmail.com> wrote:<br></font></div> <br><br> <div class="y_msg_container"><div dir="ltr">On Mon, Aug 21, 2017 at 6:50 AM, Rajeev Prasad <<a shape="rect" ymailto="mailto:rp.neuli@yahoo.com" href="mailto:rp.neuli@yahoo.com">rp.neuli@yahoo.com</a>> wrote:<br clear="none">><br clear="none">> why am i getting this err in DBIx::Class ?<br clear="none">><br clear="none">> $./update_db.pl<br clear="none">> DBIx::Class::ResultSource::unique_constraint_columns(): Unknown unique<br clear="none">> constraint nodeid on 'node' at ./update_from_ieds.pl line 80<br clear="none">><br clear="none">><br clear="none">> relevant code:<br clear="none">> ...<br clear="none">> sub addNode<br clear="none">> {<br clear="none">> my $node = shift; my $lcNode = lc($node);<br clear="none">> my $id = $schema<br clear="none">> ->resultset('Node')<br clear="none">> ->find_or_create<br clear="none">> (<br clear="none">> { nodeName => $lcNode },<br clear="none">> { key => 'nodeid' }<br clear="none">> );<br clear="none">> return $id;<br clear="none">> }<br clear="none"><br clear="none"><br clear="none">Are you trying to do this:<div class="yqt9850060855" id="yqtfd19851"><br clear="none"><br clear="none">my $id = $schema<br clear="none"> ->resultset('Node')->find_or_create<br clear="none"> (<br clear="none"> {<br clear="none"> nodeName => $lcNode ,</div><br clear="none"> nodeID => $nodeid,<br clear="none"> }<br clear="none"> );<br clear="none"><br clear="none"><br clear="none">-- <br clear="none">Regards,<br clear="none"><br clear="none">Tirveni Yadav<br clear="none"><br clear="none">www.bael.io<br clear="none"><br clear="none">What is this Universe ? From what it arises ? Into what does it go?<br clear="none">In freedom it arises, In freedom it rests and into freedom it melts away.<br clear="none">Upanishads.<div class="yqt9850060855" id="yqtfd82939"><br clear="none"></div></div><br><br></div> </div> </div> </div></div></body></html>