[Koha-bugs] [Bug 5379] import_borrowers.pl fails with db insert/update errors

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

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

--- Comment #5 from Chris Nighswonger <cnighswonger at foundations.edu> 2010-11-12 13:32:32 UTC ---
(In reply to comment #0)
> I'm not sure what is going on here exactly; the gonenoaddress, lost, debarred,
> guarantorid, and flags db fields default to NULL, but for some reason when the
> insert/update occurs, DBD returns an error like "Incorrect integer value: ''
> for column 'foo'..." It appears save to default these to zero for now.
> 
> This patch also adds more logging of errors and a notice to the user to check
> the logs for errors when they occur.

DB errors are also thrown for extended patron attributes when entered in the
form:

"ATTRIB1:value1", "ATTRIB2:value2", etc.

This is due to a problem introduced by smart quotes.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.