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, <[email protected]> escribió: > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: koha <[email protected]> > Subject: [Koha] OPAC Search Error in KOHA 1711.0001 > Message-ID: > <CAO1yrmkLY_-ZHs-7a1p6Qvz8rBQ5cYPed14W2NC= > [email protected]> > 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 <[email protected]> > To: koha <[email protected]> > Subject: [Koha] Fwd: OPAC Search Error in KOHA 1711.0001 > Message-ID: > <CAO1yrm= > [email protected]> > 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 <[email protected]> > To: Mubassir Ahsan <[email protected]> > Cc: koha <[email protected]> > Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001 > Message-ID: > <CAJzKNY4EFHLLJkv+aQgNTT1gVfcQ= > [email protected]> > 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 <[email protected]> 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 > > [email protected] > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 4 > Date: Tue, 26 Dec 2017 20:37:32 +0000 > From: Mubassir Ahsan <[email protected]> > To: Jonathan Druart <[email protected]> > Cc: koha <[email protected]> > Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001 > Message-ID: > < > cao1yrmnn0k9ky4jwk4krfkamuhsxoytae1n0vy6ao_aanug...@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 < > [email protected]> 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 <[email protected]> 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 > >> [email protected] > >> 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 <[email protected]> > To: Mubassir Ahsan <[email protected]> > Cc: koha <[email protected]> > Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001 > Message-ID: > < > cajzkny765usprur0_sq_wkwroto+hrvvfguxfpm5yjmug18...@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 <[email protected]> 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 < > > [email protected]> 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 <[email protected]> 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 > >>> [email protected] > >>> 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 146, Issue 41 > ************************************* > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
