https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20125
Arthur Suzuki <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #22 from Arthur Suzuki <[email protected]> --- I managed to rebase the patch but I get an error when I try to execute the script : -------- kohadev-koha@kohadevbox:koha(bug20125)$ misc/cronjobs/ordersClaim.pl -d 0 {UNKNOWN}: DBI Exception: DBD::mysql::db selectall_arrayref failed: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x5630cbcc1000), "DBI Exception: DBD::mysql::db selectall_arrayref failed: Mixi"...) called at /usr/share/perl5/DBIx/Class/Storage.pm line 113 DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x5630d59f10d0), "DBI Exception: DBD::mysql::db selectall_arrayref failed: Mixi"...) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1623 DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db selectall_arrayref failed: Mixing of GROUP col"..., DBI::db=HASH(0x5630d5e39220), undef) called at misc/cronjobs/ordersClaim.pl line 11 -------- If I run the same query with koha-mysql it does return results though : -------- MariaDB [koha_kohadev]> select aqorders.*, aqbasket.*, biblio.*, count(aqorders_claims.claimed_on) as claims_count, max(aqorders_claims.claimed_on) as last_claim FROM aqorders LEFT JOIN biblio ON aqorders.biblionumber = biblio.biblionumber LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno LEFT JOIN aqorders_claims ON aqorders.or dernumber = aqorders_claims.ordernumber having claims_count<=2 AND (last_claim IS NULL or last_claim <= DATE_SUB(CAST(now() AS date),INTERVAL 0 day)); 4 rows in set (0.019 sec) -------- -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
