[Koha] Koha Digest, Vol 146, Issue 41

Ruben Norori kachomanic at gmail.com
Wed Dec 27 13:24:31 NZDT 2017 

Try this steps:

1. Backup your database. mysqldump -u root -p yourdatabase > backup.sql
2. Make a new Installation.
3. Import your backup.sql file in the new installation. mysql -u username
-p yourdatabase < backup.sql
4. Try to access koha admin site.
5. The software will upgrade your database structure.
6. Repeat 4-6 steps until all work fine.
7. koha-rebuild-library -v -b -a -f mylibrary

El mar., 26 dic. 2017 a las 17:00, <koha-request at lists.katipo.co.nz>
escribió:

> Send Koha mailing list submissions to
>         koha at lists.katipo.co.nz
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.katipo.co.nz/mailman/listinfo/koha
> or, via email, send a message with subject or body 'help' to
>         koha-request at lists.katipo.co.nz
>
> You can reach the person managing the list at
>         koha-owner at lists.katipo.co.nz
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Koha digest..."
>
>
> Today's Topics:
>
>    1. OPAC Search Error in KOHA 1711.0001 (Mubassir Ahsan)
>    2. Fwd: OPAC Search Error in KOHA 1711.0001 (Mubassir Ahsan)
>    3. Re: OPAC Search Error in KOHA 1711.0001 (Jonathan Druart)
>    4. Re: OPAC Search Error in KOHA 1711.0001 (Mubassir Ahsan)
>    5. Re: OPAC Search Error in KOHA 1711.0001 (Jonathan Druart)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 26 Dec 2017 18:49:49 +0000
> From: Mubassir Ahsan <mahsandu at gmail.com>
> To: koha <koha at lists.katipo.co.nz>
> Subject: [Koha] OPAC Search Error in KOHA 1711.0001
> Message-ID:
>         <CAO1yrmkLY_-ZHs-7a1p6Qvz8rBQ5cYPed14W2NC=
> 2fZ14x5O1Q at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> 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*
> *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.*
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 26 Dec 2017 19:35:52 +0000
> From: Mubassir Ahsan <mahsandu at gmail.com>
> To: koha <koha at lists.katipo.co.nz>
> Subject: [Koha] Fwd: OPAC Search Error in KOHA 1711.0001
> Message-ID:
>         <CAO1yrm=
> 00OOUh8khKPn3zQh9_Jj9rF2zo-5uMKNL2OqP5e4NcQ at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> 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. (
>
> https://drive.google.com/file/d/19aYs2i7r_V1DjsSrsza8OolQCN_cTG-D/view?usp=sharing
> )
>
>
> --
>
> *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.*
> --
>
> *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.*
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 26 Dec 2017 19:42:18 +0000
> From: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
> To: Mubassir Ahsan <mahsandu at gmail.com>
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001
> Message-ID:
>         <CAJzKNY4EFHLLJkv+aQgNTT1gVfcQ=
> JF1P5auicVNHPv7BVHVaw at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> 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*
> > *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
> >
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 26 Dec 2017 20:37:32 +0000
> From: Mubassir Ahsan <mahsandu at gmail.com>
> To: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001
> Message-ID:
>         <
> CAO1yrmnn0K9KY4jWK4KrFkamuhsxoYTaE1N0vY6ao_AANuGwwA at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> 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.*
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 26 Dec 2017 20:57:05 +0000
> From: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
> To: Mubassir Ahsan <mahsandu at gmail.com>
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001
> Message-ID:
>         <
> CAJzKNY765USpruR0_SQ_wKWROtO+hRVVFGuxfPM5YJMUG18YcA at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> If you have technical skills you can try to add this line:
>
> @ opac-search.pl:229 @ my $itemtypes = GetItemTypesCategorized;
>  # add translated_description to itemtypes
>  foreach my $itemtype ( keys %{$itemtypes} ) {
>      # Itemtypes search categories don't have (yet) translated
> descriptions, they are auth values (and could still have no descriptions
> too BZ 18400)
> +    warn $itemtype;
>      my $translated_description = Koha::ItemTypes->find( $itemtype
> )->translated_description;
>      $itemtypes->{$itemtype}->{translated_description} =
> $translated_description || $itemtypes->{$itemtype}->{description} || q{};
>  }
>
> Then restart plack, reload the page and look at the Koha logs.
> It will display the different item types of the search result, the one just
> before the error is the one that is not defined in Koha.
>
> On Tue, 26 Dec 2017 at 17:37 Mubassir Ahsan <mahsandu at gmail.com> wrote:
>
> > 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.*
> >
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>
> End of Koha Digest, Vol 146, Issue 41
> *************************************
>

More information about the Koha mailing list