<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1503276054089_14627"><br></div><div id="yui_3_16_0_ym19_1_1503276054089_14535">why am i getting this err in DBIx::Class ?</div><div id="yui_3_16_0_ym19_1_1503276054089_14534"><br></div><div id="yui_3_16_0_ym19_1_1503276054089_14519" dir="ltr">$./update_db.pl<br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503276054089_14528">DBIx::Class::ResultSource::unique_constraint_columns(): Unknown unique constraint nodeid on 'node' at ./update_from_ieds.pl line 80<br id="yui_3_16_0_ym19_1_1503276054089_14525"><br></div><div id="yui_3_16_0_ym19_1_1503276054089_14494"><br></div><div id="yui_3_16_0_ym19_1_1503276054089_14537">relevant code:<br></div><div id="yui_3_16_0_ym19_1_1503276054089_14492">...<br></div><div id="yui_3_16_0_ym19_1_1503276054089_14431" dir="ltr">sub addNode<br id="yui_3_16_0_ym19_1_1503276054089_14469">{<br id="yui_3_16_0_ym19_1_1503276054089_14470"> my $node = shift; my $lcNode = lc($node);<br id="yui_3_16_0_ym19_1_1503276054089_14471"> my $id = $schema<br id="yui_3_16_0_ym19_1_1503276054089_14472"> ->resultset('Node')<br id="yui_3_16_0_ym19_1_1503276054089_14473"> ->find_or_create<br id="yui_3_16_0_ym19_1_1503276054089_14474"> (<br id="yui_3_16_0_ym19_1_1503276054089_14475"> { nodeName => $lcNode },<br id="yui_3_16_0_ym19_1_1503276054089_14476"> { key => 'nodeid' }<br id="yui_3_16_0_ym19_1_1503276054089_14477"> );<br id="yui_3_16_0_ym19_1_1503276054089_14478"> return $id;<br id="yui_3_16_0_ym19_1_1503276054089_14479">}<br id="yui_3_16_0_ym19_1_1503276054089_14480"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503276054089_14484">...<br></div><div id="yui_3_16_0_ym19_1_1503276054089_14430"><br></div><div id="yui_3_16_0_ym19_1_1503276054089_14546"><br></div><div id="yui_3_16_0_ym19_1_1503276054089_14587">other details:</div><div id="yui_3_16_0_ym19_1_1503276054089_14586"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503276054089_14269">mysql> desc node;<br id="yui_3_16_0_ym19_1_1503276054089_14260">+-----------+-----------------------+------+-----+---------+----------------+<br id="yui_3_16_0_ym19_1_1503276054089_14261">| Field | Type | Null | Key | Default | Extra |<br id="yui_3_16_0_ym19_1_1503276054089_14262">+-----------+-----------------------+------+-----+---------+----------------+<br id="yui_3_16_0_ym19_1_1503276054089_14263">| nodeID | mediumint(5) unsigned | NO | PRI | NULL | auto_increment |<br id="yui_3_16_0_ym19_1_1503276054089_14264">| nodeName | varchar(50) | NO | UNI | NULL | |<br id="yui_3_16_0_ym19_1_1503276054089_14265">| nodeNotes | varchar(1000) | YES | | NULL | |<br id="yui_3_16_0_ym19_1_1503276054089_14266">+-----------+-----------------------+------+-----+---------+----------------+<br id="yui_3_16_0_ym19_1_1503276054089_14267">3 rows in set (0.00 sec)<br id="yui_3_16_0_ym19_1_1503276054089_14268"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503276054089_14270"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503276054089_14518"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503276054089_14307">$ cat Node.pm<br id="yui_3_16_0_ym19_1_1503276054089_14378">use utf8;<br id="yui_3_16_0_ym19_1_1503276054089_14379">package Mydb::Schema::Result::Node;<br id="yui_3_16_0_ym19_1_1503276054089_14380"><br id="yui_3_16_0_ym19_1_1503276054089_14381"># Created by DBIx::Class::Schema::Loader<br id="yui_3_16_0_ym19_1_1503276054089_14382"># DO NOT MODIFY THE FIRST PART OF THIS FILE<br id="yui_3_16_0_ym19_1_1503276054089_14383"><br id="yui_3_16_0_ym19_1_1503276054089_14384">use strict;<br id="yui_3_16_0_ym19_1_1503276054089_14385">use warnings;<br id="yui_3_16_0_ym19_1_1503276054089_14386"><br id="yui_3_16_0_ym19_1_1503276054089_14387">use base 'DBIx::Class::Core';<br id="yui_3_16_0_ym19_1_1503276054089_14388">__PACKAGE__->table("node");<br id="yui_3_16_0_ym19_1_1503276054089_14389">__PACKAGE__->add_columns(<br id="yui_3_16_0_ym19_1_1503276054089_14390"> "nodeid",<br id="yui_3_16_0_ym19_1_1503276054089_14391"> {<br id="yui_3_16_0_ym19_1_1503276054089_14392"> data_type => "mediumint",<br id="yui_3_16_0_ym19_1_1503276054089_14393"> extra => { unsigned => 1 },<br id="yui_3_16_0_ym19_1_1503276054089_14394"> is_auto_increment => 1,<br id="yui_3_16_0_ym19_1_1503276054089_14395"> is_nullable => 0,<br id="yui_3_16_0_ym19_1_1503276054089_14396"> },<br id="yui_3_16_0_ym19_1_1503276054089_14397"> "nodename",<br id="yui_3_16_0_ym19_1_1503276054089_14398"> { data_type => "varchar", is_nullable => 0, size => 50 },<br id="yui_3_16_0_ym19_1_1503276054089_14399"> "nodenotes",<br id="yui_3_16_0_ym19_1_1503276054089_14400"> { data_type => "varchar", is_nullable => 1, size => 1000 },<br id="yui_3_16_0_ym19_1_1503276054089_14401">);<br id="yui_3_16_0_ym19_1_1503276054089_14402">__PACKAGE__->set_primary_key("nodeid");<br id="yui_3_16_0_ym19_1_1503276054089_14403">__PACKAGE__->add_unique_constraint("node", ["nodename"]);<br id="yui_3_16_0_ym19_1_1503276054089_14404"><br id="yui_3_16_0_ym19_1_1503276054089_14405"><br id="yui_3_16_0_ym19_1_1503276054089_14406"># Created by DBIx::Class::Schema::Loader v0.07045 @ 2017-08-18 19:20:59<br id="yui_3_16_0_ym19_1_1503276054089_14407"># DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:t6+x6tFtAwGEHH/5qfBW/w<br id="yui_3_16_0_ym19_1_1503276054089_14408"><br id="yui_3_16_0_ym19_1_1503276054089_14409"><br id="yui_3_16_0_ym19_1_1503276054089_14410"># You can replace this text with custom code or comments, and it will be preserved on regeneration<br id="yui_3_16_0_ym19_1_1503276054089_14411">1;<br id="yui_3_16_0_ym19_1_1503276054089_14412"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503276054089_14413"><br></div><div dir="ltr"><br></div></div></body></html>