[Koha-bugs] [Bug 25624] Update patrons category script should allow finding null and not null and wildcards

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

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

Andrew Fuerste-Henry <andrew at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #20 from Andrew Fuerste-Henry <andrew at bywatersolutions.com> ---
Now I'm getting a different SQL error when running this with a --where, a
--field, or neither:
perl misc/cronjobs/update_patrons_category.pl -f PT -t B --where
"firstname='koha'" -v
No actions will be taken (test mode)
Will update patrons from PT to B with conditions below (if any)
DBD::mysql::st execute failed: Unknown column
'me.exclude_from_local_holds_priority' in 'field list' [for Statement "SELECT
`me`.`categorycode`, `me`.`description`, `me`.`enrolmentperiod`,
`me`.`enrolmentperioddate`, `me`.`upperagelimit`, `me`.`dateofbirthrequired`,
`me`.`finetype`, `me`.`bulk`, `me`.`enrolmentfee`,
`me`.`overduenoticerequired`, `me`.`issuelimit`, `me`.`reservefee`,
`me`.`hidelostitems`, `me`.`category_type`,
`me`.`BlockExpiredPatronOpacActions`, `me`.`default_privacy`,
`me`.`checkprevcheckout`, `me`.`reset_password`, `me`.`change_password`,
`me`.`exclude_from_local_holds_priority` FROM `categories` `me` WHERE (
`me`.`categorycode` = ? )" with ParamValues: 0='PT'] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
'me.exclude_from_local_holds_priority' in 'field list' at
/kohadevbox/koha/Koha/Objects.pm line 96

-- 
You are receiving this mail because:
You are watching all bug changes.