Created attachment 70601 [details] Software error: Error on print summary
Hi Mohd, please always include some step by step information on what you did in order for the error message to show up. Thx!
I test Some error show when patron borrow over 80 item. But not all patron have this error
On summary-print.pl line 107 $row{'itemtype_description'} = $itemtype->description; #FIXME Should not it be translated_description
Anybody cal help me?
It looks like you have an item that have an item type not defined in your system. To know the item types that are not defined in Koha, you can execute the following query: If item-level_itypes is "specific item" select distinct(itype) from items left join itemtypes on itype=itemtype where itemtype is null; If item-level_itypes is "biblio record" select distinct(bi.itemtype) from biblioitems bi left join itemtypes it on bi.itemtype=it.itemtype where bi.itemtype is null;
Created attachment 71233 [details] Result NULL After run query, result is NULL, how next step to do?
I am sorry I have no idea then. Do you have something else in the log? Maybe your item does not have an item type defined? Make sure your items have an item type correctly defined. Otherwise you could apply this change: diff --git a/members/summary-print.pl b/members/summary-print.pl index a6a0e36194..bb57ee0d00 100755 --- a/members/summary-print.pl +++ b/members/summary-print.pl @@ -100,6 +100,7 @@ sub build_issue_data { if ( $issue->{replacementprice} ); #find the charge for an item + warn "Getting charges for " . $issue->{itemnumber}; my ( $charge, $itemtype ) = GetIssuingCharges( $issue->{itemnumber}, $borrowernumber ); Restart plack, then reload the page. In the log you should see the "Getting charges for " line with the itemnumber that cause problem.
Created attachment 71240 [details] Log after edit code For your info, this problem come affer upgrade from KOHA 16.05 to 17.11 After add code warn "Getting charges for " . $issue->{itemnumber}; Error log in attachment
What are the return of these queries: select itype from items where itemnumber=322947; select itemtype from biblioitems bi left join items it on bi.biblionumber=it.biblionumber where it.itemnumber=322947; select value from systempreferences where variable="item-level_itypes"; select itemtype from itemtypes;
Created attachment 71256 [details] Result on test query Before I run the query, I edit biblio dan itemnumber for 322947 - Sorry for this. Now I try with new error log, I found the error on itemnumber=274334 and biblionumber=121544 At biblio, Koha [default] item type 942 is NULL and Koha item type BOOK. After run the query, result like attachment
Created attachment 71257 [details] Another error log
Created attachment 71258 [details] 942 is NULL
Created attachment 71259 [details] Koha Item type BOOK
You have item types defined at biblio level (item-level_itypes=0), but not defined in biblioitems table (942$c is empty), you need to fix your records.
How to query all biblio number with 942$c is empty?
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Biblio_Items_without_a_Koha_Item_Type