https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19454
Katrin Fischer <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA --- Comment #14 from Katrin Fischer <[email protected]> --- Hi Marcel, 2 things I am afraid. 1) Question: I notice all other options are are -- and the new one is the only one - - is there a reason to use one or the other? 2) The example given doesn't work for me: kohadev-koha@kohadevbox:/home/vagrant/kohaclone$ ./misc/maintenance/borrowers-force-messaging-defaults.pl --doit -category PT Since: 0000-00-00 DBD::mysql::st execute failed: Column 'categorycode' in where clause is ambiguous [for Statement "SELECT DISTINCT bo.borrowernumber, bo.categorycode FROM borrowers bo LEFT JOIN borrower_message_preferences mp USING (borrowernumber) WHERE bo.dateenrolled >= ? AND categorycode = ?" with ParamValues: 0='0000-00-00', 1='PT'] at ./misc/maintenance/borrowers-force-messaging-defaults.pl line 62. DBD::mysql::st fetchrow failed: fetch() without execute() [for Statement "SELECT DISTINCT bo.borrowernumber, bo.categorycode FROM borrowers bo LEFT JOIN borrower_message_preferences mp USING (borrowernumber) WHERE bo.dateenrolled >= ? AND categorycode = ?" with ParamValues: 0='0000-00-00', 1='PT'] at ./misc/maintenance/borrowers-force My database is using the test date, I made sure there are patrons with category PT. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://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/
