[Koha-bugs] [Bug 19454] Script borrowers-force-messaging-defaults.pl should be able to filter on patron category

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19454

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Failed QA

--- Comment #14 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
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 at 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.