[Koha-bugs] [Bug 1230] On editing marc entry: Publisher fields(tag 260) NOT stored as utf8 in mysql
bugzilla-daemon at daddy.katipo.co.nz
bugzilla-daemon at daddy.katipo.co.nz
Thu Dec 14 10:07:53 CET 2006
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1230
------- Comment #15 from rhariram at gmail.com 2006-12-14 22:07 -------
The problem came down to answering the question:
During modification, why the data for
the table biblio has the expected data
but the data for table biblioitem has junk ?
So, comparing sub OLDmodbiblio & sub OLDmodbibitem
in Biblio.pm, found differences in how the
record is getting updated.
In OLDmodbiblio its:
$dbh->prepare("Update biblio set title = ?,... ;
$sth->execute( $biblio->{'title'},... ;
In OLDmodbibitem its:
$biblioitem->{'itemtype'} = $dbh->quote( $biblioitem->{'itemtype'}... ;
$query = "Update biblioitems set itemtype = $biblioitem->{'itemtype'},... ;
$dbh->do($query);
I made changes to OLDmodbibitem to
be similar to that of OLDmodbiblio. ie,
$dbh->prepare("Update biblioitems set itemtype = ?, ... ;
$sth->execute( $biblioitem->{'itemtype'},... ;
And that fixes the bug !!
So, the issue seems to with the $dbh->quote thingy.
------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.
More information about the Koha-bugs
mailing list