Hi, Can anybody tell me what is wrong with this? $rs = $schema->resultset("Location")->search( { name => { like => '%' }, }, { order_by => 'location_id', rows => 2, } );
I get: Can't use an undefined value as an ARRAY reference at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/DBIx/Class/Storage/DBIHacks.pm line 70. at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/DBIx/Class/Schema.pm line 1101. DBIx::Class::Schema::throw_exception('TestProject::Schema=HASH(0x155e628)', 'Can\'t use an undefined value as an ARRAY reference at /opt/A...') called at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/DBIx/Class/Storage.pm line 112 DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::mysql=HASH(0x155e868)', 'Can\'t use an undefined value as an ARRAY reference at /opt/A...') called at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/DBIx/Class/Storage/BlockRunner.pm line 188 DBIx::Class::Storage::BlockRunner::__ANON__() called at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/Context/Preserve.pm line 37 Context::Preserve::preserve_context('CODE(0x578d1e0)', 'replace', 'CODE(0x5791e58)') called at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/DBIx/Class/Storage/BlockRunner.pm line 219 DBIx::Class::Storage::BlockRunner::_run('DBIx::Class::Storage::BlockRunner=HASH(0x56aea78)') called at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/DBIx/Class/Storage/BlockRunner.pm line 110 DBIx::Class::Storage::BlockRunner::run('DBIx::Class::Storage::BlockRunner=HASH(0x56aea78)') called at /opt/TestProject/lib/DBIx/Class/Storage/DBI.pm line 803 DBIx::Class::Storage::DBI::dbh_do(undef, undef, 'DBIx::Class::Storage::DBI::Cursor=HASH(0x59c8a78)') called at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/DBIx/Class/Storage/DBI/Cursor.pm line 116 DBIx::Class::Storage::DBI::Cursor::next('DBIx::Class::Storage::DBI::Cursor=HASH(0x59c8a78)') called at /opt/TestProject/platform/Linux/x86_64/lib/perl5/site_perl/5.16.0/DBIx/Class/ResultSet.pm line 1249 DBIx::Class::ResultSet::next('DBIx::Class::ResultSet=HASH(0x59486a0)') called at ./test.pl line 44 If I remove the rows directive the error is gone. I am using perl 5.16 and DBIx::Class DBIx-Class-0.08204 -- Kind regards, Theo Bot Network Management Engineer Tel: +31653965698 e-mail: theo....@proxy.nl Website: http://www.proxy.nl LinkedIn: http://www.linkedin.com/in/theobot
_______________________________________________ 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