DBIx::Class::ResultSet::pager(): DBI Exception: DBD::Pg::st execute failed: ERROR: date/time field value out of range: "2004-13-01 00:00:00" HINT: Perhaps you need a different "datestyle" setting. [for Statement "SELECT COUNT( DISTINCT( me.identifier ) ) FROM media me LEFT JOIN media_group_access m2ga ON ( m2ga.media = me.identifier ) LEFT JOIN media_dbuser_access m2ua ON ( m2ua.media = me.identifier ) WHERE ( ( ( date_time_loc >= ? ) AND ( date_time_loc < ? ) AND ( rating >= ? ) AND ( ( ( m2ga.dbgroup = ? ) OR ( m2ga.dbgroup IN ( ? ) ) OR ( owner = ? ) OR ( ( ( m2ua.dbuser > ? ) AND ( m2ua.dbuser = ? ) ) ) ) ) ) )" with ParamValues: 6='0', 3='5', 7='0', 2='2004-13-01 00:00:00', 8='0', 1='2004-12-01 00:00:00', 4='3', 5='0'] at /home/olivier/mason_shared_comps/displayThumbs line 74 Stack: [/usr/lib/perl5/vendor_perl/5.8.8/Carp/Clan.pm:213] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Exception.pm:58] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Schema.pm:919] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage.pm:125] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm:772] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm:898] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm:542] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm:912] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm:1026] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI/Cursor.pm:78] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm:553] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI/Cursor.pm:97] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/ResultSet.pm:974] [/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/ResultSet.pm:1393] [/home/olivier/mason_shared_comps/displayThumbs:74] [/home/olivier/calle.org/htdocs/mosaic/dhandler:29] [/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:914] [/home/olivier/mason_data/obj/3721650159/calle/mosaic/dhandler.obj:48] [/home/olivier/calle.org/htdocs/mosaic/autohandler:1] [/home/olivier/calle.org/htdocs/autohandler:41]