Downgrade koha database from 3.16.x to 3.14.x
Hi all, With reference to issue on searching (http://permalink.gmane.org/gmane.comp.misc.koha/36671) mentioned earlier in the Koha general mailing list, I am thinking to downgrade the database structure of Koha 3.16.4 to 3.14.x. While using the 3.16 database with Koha 3.14 software, it works, surprisingly, maybe both are stable release and their database schema don't have big changes. However, I have only tested searching and have not tested other functionalities. What I am thinking now is to create a database schema of version 3.14 and import only the data of Koha 3.16 database by disabling create table and drop table statements. If anyone have done this kind of task or have a better idea, please kindly suggest. Thank you. Regards, Dibyendra -- Dibyendra Hyoju
Hi Dibyendra, The guys are probably travelling or busy preparing for travel for KohaCon 2014.... so you might have to wait for a bit before someone can guide you. Arslan On October 4, 2014 2:25:48 PM GMT+05:00, Dibyendra Hyoju <dibyendra@gmail.com> wrote:
Hi all,
With reference to issue on searching (http://permalink.gmane.org/gmane.comp.misc.koha/36671) mentioned earlier in the Koha general mailing list, I am thinking to downgrade the database structure of Koha 3.16.4 to 3.14.x.
While using the 3.16 database with Koha 3.14 software, it works, surprisingly, maybe both are stable release and their database schema don't have big changes. However, I have only tested searching and have not tested other functionalities.
What I am thinking now is to create a database schema of version 3.14 and import only the data of Koha 3.16 database by disabling create table and drop table statements.
If anyone have done this kind of task or have a better idea, please kindly suggest.
Thank you.
Regards, Dibyendra
-- Dibyendra Hyoju _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Hi,
(http://permalink.gmane.org/gmane.comp.misc.koha/36671) mentioned earlier in the Koha general mailing list, I am thinking to downgrade the database structure of Koha 3.16.4 to 3.14.x.
I suggest you to not do this operation, the error is inside this code: Software error:
Can't call method "as_string" on an undefined value at /usr/share/koha/lib/C4/Koha.pm line 1608.
1586 1587 sub NormalizeISBN { 1588 my ($params) = @_; 1589 1590 my $string = $params->{isbn}; 1591 my $strip_hyphens = $params->{strip_hyphens}; 1592 my $format = $params->{format}; 1593 1594 return unless $string; 1595 1596 my $isbn = Business::ISBN->new($string); 1597 1598 if ( $isbn && $isbn->is_valid() ) { 1599 1600 if ( $format eq 'ISBN-10' ) { 1601 $isbn = $isbn->as_isbn10(); 1602 } 1603 elsif ( $format eq 'ISBN-13' ) { 1604 $isbn = $isbn->as_isbn13(); 1605 } 1606 1607 if ($strip_hyphens) { 1608 $string = $isbn->as_string( [] ); 1609 } else { 1610 $string = $isbn->as_string(); 1611 } 1612 1613 return $string; 1614 } 1615 } Probably you have an 020 tag without data or same other problem. To understand better the situation you can try: -- find a search on opac that gives the error -- insert the swith -d in the opac-search.pl -- start opac-search.pl on command line and use perl debugger to find the exact problem Bye
Thanks both of you for your response! I will postpone the idea of downgrading the database for a while. Zeno, I'll take a look at code to find out the exact problem, but looking at the snippet code in the email, this could be because of malformed ISBN, I guess. I will write to the list, if I come up with solutions. Thanks! -- Dibyendra On 10/4/14, Zeno Tajoli <z.tajoli@cineca.it> wrote:
Hi,
(http://permalink.gmane.org/gmane.comp.misc.koha/36671) mentioned earlier in the Koha general mailing list, I am thinking to downgrade the database structure of Koha 3.16.4 to 3.14.x.
I suggest you to not do this operation, the error is inside this code:
Software error:
Can't call method "as_string" on an undefined value at /usr/share/koha/lib/C4/Koha.pm line 1608.
1586 1587 sub NormalizeISBN { 1588 my ($params) = @_; 1589 1590 my $string = $params->{isbn}; 1591 my $strip_hyphens = $params->{strip_hyphens}; 1592 my $format = $params->{format}; 1593 1594 return unless $string; 1595 1596 my $isbn = Business::ISBN->new($string); 1597 1598 if ( $isbn && $isbn->is_valid() ) { 1599 1600 if ( $format eq 'ISBN-10' ) { 1601 $isbn = $isbn->as_isbn10(); 1602 } 1603 elsif ( $format eq 'ISBN-13' ) { 1604 $isbn = $isbn->as_isbn13(); 1605 } 1606 1607 if ($strip_hyphens) { 1608 $string = $isbn->as_string( [] ); 1609 } else { 1610 $string = $isbn->as_string(); 1611 } 1612 1613 return $string; 1614 } 1615 }
Probably you have an 020 tag without data or same other problem. To understand better the situation you can try: -- find a search on opac that gives the error -- insert the swith -d in the opac-search.pl -- start opac-search.pl on command line and use perl debugger to find the exact problem
Bye
-- Dibyendra Hyoju
Hi all, I tried clearing all the ISBNs from isbn field in the biblioitems table in my test database and re-indexed the zebra index but the same problem is shown. That means it is not related to malformed ISBN, rather could be because of malformed MARC record? The same database works okay with Koha 3.14, which is there is no such search issues. Any suggestions would be appreciated! Thank you. Regards, Dibyendra On 10/4/14, Dibyendra Hyoju <dibyendra@gmail.com> wrote:
Thanks both of you for your response! I will postpone the idea of downgrading the database for a while.
Zeno, I'll take a look at code to find out the exact problem, but looking at the snippet code in the email, this could be because of malformed ISBN, I guess.
I will write to the list, if I come up with solutions.
Thanks! -- Dibyendra
On 10/4/14, Zeno Tajoli <z.tajoli@cineca.it> wrote:
Hi,
(http://permalink.gmane.org/gmane.comp.misc.koha/36671) mentioned earlier in the Koha general mailing list, I am thinking to downgrade the database structure of Koha 3.16.4 to 3.14.x.
I suggest you to not do this operation, the error is inside this code:
Software error:
Can't call method "as_string" on an undefined value at /usr/share/koha/lib/C4/Koha.pm line 1608.
1586 1587 sub NormalizeISBN { 1588 my ($params) = @_; 1589 1590 my $string = $params->{isbn}; 1591 my $strip_hyphens = $params->{strip_hyphens}; 1592 my $format = $params->{format}; 1593 1594 return unless $string; 1595 1596 my $isbn = Business::ISBN->new($string); 1597 1598 if ( $isbn && $isbn->is_valid() ) { 1599 1600 if ( $format eq 'ISBN-10' ) { 1601 $isbn = $isbn->as_isbn10(); 1602 } 1603 elsif ( $format eq 'ISBN-13' ) { 1604 $isbn = $isbn->as_isbn13(); 1605 } 1606 1607 if ($strip_hyphens) { 1608 $string = $isbn->as_string( [] ); 1609 } else { 1610 $string = $isbn->as_string(); 1611 } 1612 1613 return $string; 1614 } 1615 }
Probably you have an 020 tag without data or same other problem. To understand better the situation you can try: -- find a search on opac that gives the error -- insert the swith -d in the opac-search.pl -- start opac-search.pl on command line and use perl debugger to find the exact problem
Bye
-- Dibyendra Hyoju
-- Dibyendra Hyoju
Hi all, Currently, I am using Koha 3.16.03 database with Koha 3.14.11 software because there is no search problem. I would appreicate if anybody have faced the similar situation and found the solutions for this issue. Thank you. Regards, Dibyendra On 10/6/14, Dibyendra Hyoju <dibyendra@gmail.com> wrote:
Hi all,
I tried clearing all the ISBNs from isbn field in the biblioitems table in my test database and re-indexed the zebra index but the same problem is shown. That means it is not related to malformed ISBN, rather could be because of malformed MARC record? The same database works okay with Koha 3.14, which is there is no such search issues.
Any suggestions would be appreciated!
Thank you.
Regards, Dibyendra
On 10/4/14, Dibyendra Hyoju <dibyendra@gmail.com> wrote:
Thanks both of you for your response! I will postpone the idea of downgrading the database for a while.
Zeno, I'll take a look at code to find out the exact problem, but looking at the snippet code in the email, this could be because of malformed ISBN, I guess.
I will write to the list, if I come up with solutions.
Thanks! -- Dibyendra
On 10/4/14, Zeno Tajoli <z.tajoli@cineca.it> wrote:
Hi,
(http://permalink.gmane.org/gmane.comp.misc.koha/36671) mentioned earlier in the Koha general mailing list, I am thinking to downgrade the database structure of Koha 3.16.4 to 3.14.x.
I suggest you to not do this operation, the error is inside this code:
Software error:
Can't call method "as_string" on an undefined value at /usr/share/koha/lib/C4/Koha.pm line 1608.
1586 1587 sub NormalizeISBN { 1588 my ($params) = @_; 1589 1590 my $string = $params->{isbn}; 1591 my $strip_hyphens = $params->{strip_hyphens}; 1592 my $format = $params->{format}; 1593 1594 return unless $string; 1595 1596 my $isbn = Business::ISBN->new($string); 1597 1598 if ( $isbn && $isbn->is_valid() ) { 1599 1600 if ( $format eq 'ISBN-10' ) { 1601 $isbn = $isbn->as_isbn10(); 1602 } 1603 elsif ( $format eq 'ISBN-13' ) { 1604 $isbn = $isbn->as_isbn13(); 1605 } 1606 1607 if ($strip_hyphens) { 1608 $string = $isbn->as_string( [] ); 1609 } else { 1610 $string = $isbn->as_string(); 1611 } 1612 1613 return $string; 1614 } 1615 }
Probably you have an 020 tag without data or same other problem. To understand better the situation you can try: -- find a search on opac that gives the error -- insert the swith -d in the opac-search.pl -- start opac-search.pl on command line and use perl debugger to find the exact problem
Bye
-- Dibyendra Hyoju
-- Dibyendra Hyoju
-- Dibyendra Hyoju
participants (3)
-
Arslan Farooq -
Dibyendra Hyoju -
Zeno Tajoli