[Koha-bugs] [Bug 28048] Can't import patrons without checkprevcheckout and autorenew_checkouts

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

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

Owen Leonard <oleonard at myacpl.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Getting Internal Server     |Can't import patrons
                   |Error while importing       |without checkprevcheckout
                   |Patrons                     |and autorenew_checkouts
            Version|unspecified                 |master
           Priority|P1 - high                   |P5 - low
           Severity|critical                    |major
                 OS|Linux                       |All
           Hardware|HP                          |All

--- Comment #1 from Owen Leonard <oleonard at myacpl.org> ---
I don't know if this is the same issue, but I'll take over this bug since there
are no other details:

Although they're not mentioned on the page as required field, it doesn't seem
to be possible to import a CSV of patrons without putting a value in the
checkprevcheckout and autorenew_checkouts columns.

An error appears in the log if you omit them:

[WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Column 'autorenew_checkouts' cannot be null [for Statement
"UPDATE `borrowers` SET `autorenew_checkouts` = ?, `checkprevcheckout` = ?,
`dateexpiry` = ?, `dateofbirth` = ?, `debarred` = ?, `flags` = ?,
`gonenoaddress` = ?, `lang` = ?, `lost` = ?, `password` = ?, `relationship` =
?, `updated_on` = current_timestamp, `userid` = ? WHERE ( `borrowernumber` = ?
)" with ParamValues: 0=undef, 1=undef, 2='2024-03-30T00:00:00', 3=undef,
4=undef, 5=undef, 6=undef, 7=undef, 8=undef, 9='!', 10=undef, 11='test.test',
12='65581'] at /kohadevbox/koha/Koha/Object.pm line 169

[WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Column 'checkprevcheckout' cannot be null [for Statement
"UPDATE `borrowers` SET `checkprevcheckout` = ?, `dateexpiry` = ?,
`dateofbirth` = ?, `debarred` = ?, `flags` = ?, `gonenoaddress` = ?, `lang` =
?, `lost` = ?, `password` = ?, `relationship` = ?, `updated_on` =
current_timestamp, `userid` = ? WHERE ( `borrowernumber` = ? )" with
ParamValues: 0=undef, 1='2024-03-30T00:00:00', 2=undef, 3=undef, 4=undef,
5=undef, 6=undef, 7=undef, 8='!', 9=undef, 10='test.test', 11='65581'] at
/kohadevbox/koha/Koha/Object.pm line 169

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