On Wed, Oct 14, 2009 at 05:10:57PM +0100, Dermot wrote: > Hi, > > I have had a number of errors trying to add a record to a SQLite3 db > and DBIx '0.08010'; > The original error was: > > DBIx::Class::ResultSet::update_or_create(): Object ARRAY(0x8f3f7a8) > isn't a My::Schema::MotionDB:: > > I created a small test to see if I could narrow it down but that is > throwing this exception: > > DBIx::Class::ResultSet::update_or_create(): DBI Exception: > DBD::SQLite::db prepare_cached failed: near "CONTRIB": syntax error(1) > at dbdimp.c line 271 [for Statement "SELECT me.id, me.sub_id, > me.contrib_id FROM clipData me WHERE ( ( ( ( me.id CONTRIB ID ? ) ) ) > )"] at t/test_update_or_create.t line 45 > > I can't find 'CONTRIB ID' anywhere on my sources. I have parred my > schema and script down to the bone but as long as I try and create a > row with a row in a related (has_one) table, I get errors. > > Can anyone spot where I am going wrong?
Yes, you are using a version that is almost 2 years old. Upgrade to the 0.081xx family which sports a from the ground rewrite of multicreate (among other things). _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk