Re: [Koha] Koha Digest, Vol 146, Issue 41

27 Dec 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@lists.katipo.co.nz>
escribió:
...
Send Koha mailing list submissions to
        koha@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@lists.katipo.co.nz
You can reach the person managing the list at
        koha-owner@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@gmail.com>
To: koha <koha@lists.katipo.co.nz>
Subject: [Koha] OPAC Search Error in KOHA 1711.0001
Message-ID:
        <CAO1yrmkLY_-ZHs-7a1p6Qvz8rBQ5cYPed14W2NC=
2fZ14x5O1Q@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@gmail.com>
To: koha <koha@lists.katipo.co.nz>
Subject: [Koha] Fwd: OPAC Search Error in KOHA 1711.0001
Message-ID:
        <CAO1yrm=
00OOUh8khKPn3zQh9_Jj9rF2zo-5uMKNL2OqP5e4NcQ@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=s...
)
--
*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@bugs.koha-community.org>
To: Mubassir Ahsan <mahsandu@gmail.com>
Cc: koha <koha@lists.katipo.co.nz>
Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001
Message-ID:
        <CAJzKNY4EFHLLJkv+aQgNTT1gVfcQ=
JF1P5auicVNHPv7BVHVaw@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@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@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@gmail.com>
To: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Cc: koha <koha@lists.katipo.co.nz>
Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001
Message-ID:
        <
CAO1yrmnn0K9KY4jWK4KrFkamuhsxoYTaE1N0vY6ao_AANuGwwA@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@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@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@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@bugs.koha-community.org>
To: Mubassir Ahsan <mahsandu@gmail.com>
Cc: koha <koha@lists.katipo.co.nz>
Subject: Re: [Koha] OPAC Search Error in KOHA 1711.0001
Message-ID:
        <
CAJzKNY765USpruR0_SQ_wKWROtO+hRVVFGuxfPM5YJMUG18YcA@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@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@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@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@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@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 146, Issue 41
*************************************

Ruben Norori

tags

participants (1)