[Koha] OPAC Search Error in KOHA 1711.0001

[Mubassir Ahsan]

Dear Jonathan,
Thanks for the reply. I have executed the query and manually search in the
database for missing itemtype and then fix all, but the problem is still
there.

only Disabling the lines makes searching possible.


On Wed, Dec 27, 2017 at 1:42 AM Jonathan Druart <
jonathan.druart at bugs.koha-community.org> wrote:

> Hello,
>
> Yes, it's a bug and a configuration issue.
> It means you have item types that are used in your catalogue but not
> defined in Koha.
>
> There was a discussion on koha-devel in July:
> http://lists.koha-community.org/pipermail/koha-devel/2017-July/043841.html
>
> 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;
>
> It is a bug in the sense that Koha should not crash brutally in that case.
> We should at least display a warning on the about page.
>
> Regards,
> Jonathan
>
> On Tue, 26 Dec 2017 at 15:49 Mubassir Ahsan <mahsandu at gmail.com> wrote:
>
>> I have got a serious problem after upgrading to the latest version today.
>> The problem is when I search in OPAC search interface it is returning
>> "Can't call method "translated_description" on an undefined value at
>> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 229."
>>
>> I have cleaned the previous 1711 version and reinstall, but still no luck.
>> Please help . I am attaching screenshot to better understand.
>>
>>
>> --
>>
>> *Best wishes.*
>> *--------------------*
>>
>>
>>
>> *Md. Mubassir AhsanAssistant Librarian(Library In-Charge)Southeast
>> University*
>>
>> *-----------------------------*
>> *Mobile+Viber+IMO: 01916303060 <01916-303060>*
>> *Facebook:* mmahsan <http://facebook.com/mmahsan>
>> *Skype+Twitter*: mahsandu
>> Website: Mubassir.info
>> *"Proud to be a LIS Professional*"
>> *Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace,
>> Greenstone), N/W Admin, DBA.*
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> --

*Best wishes.*
*--------------------*



*Md. Mubassir AhsanAssistant Librarian(Library In-Charge)Southeast
University*

*-----------------------------*
*Mobile+Viber+IMO: 01916303060*
*Facebook:* mmahsan <http://facebook.com/mmahsan>
*Skype+Twitter*: mahsandu
Website: Mubassir.info
*"Proud to be a LIS Professional*"
*Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace,
Greenstone), N/W Admin, DBA.*