http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1230 ------- Comment #15 from rhariram@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.