[Koha-bugs] [Bug 14067] 500 error when deleting patrons

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon May 11 17:48:35 CEST 2015


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14067

--- Comment #5 from Barton Chittenden <barton at bywatersolutions.com> ---
(In reply to David Cook from comment #4)
> (In reply to Barton Chittenden from comment #2)
> > Here's the error as found in intranet-error.log
> > 
> > [Mon May 04 08:52:27 2015] [error] [client xx.xx.xx.xx] [Mon May  4 08:52:27
> > 2015] deletemem.pl: DBD::mysql::st execute failed: Column 'cardnumber'
> > cannot be null at /usr/local/share/perl/5.10.1/DBIx/Class/Storage/DBI.pm
> > line 1834.
> > [Mon May 04 08:52:27 2015] [error] [client xx.xx.xx.xx] Premature end of
> > script headers: deletemem.pl



> 
> That's an interesting error. When I look at my databases, 'cardnumber' is a
> nullable column. I'd suggest looking at Koha::Schema::Result::Borrower.pm
> and seeing if "cardnumber" has "is_nullable" set to 1. I'd also check the
> actual database to see if it's a nullable column...

Yes, borrowers.cardnumber is nullable in the database in question:

mysql> describe borrowers;
+---------------------+--------------+------+-----+---------+----------------+
| Field               | Type         | Null | Key | Default | Extra          |
+---------------------+--------------+------+-----+---------+----------------+
| borrowernumber      | int(11)      | NO   | PRI | NULL    | auto_increment |
| cardnumber          | varchar(16)  | YES  | UNI | NULL    |                |

and in /usr/share/koha/lib/Koha/Schema/Result/Borrower.pm

=head2 cardnumber

  data_type: 'varchar'
  is_nullable: 1
  size: 16

So... I don't know.

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


More information about the Koha-bugs mailing list