[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 George Veranis changed: What|Removed |Added CC||synapse@gmail.com --- Comment #10 from George Veranis --- *** Bug 18369 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Hayley Mapley changed: What|Removed |Added CC||hayleymap...@catalyst.net.n ||z --- Comment #9 from Hayley Mapley --- Minor/normal patch will not be backported to 18.11.x series -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Lucas Gass changed: What|Removed |Added Status|Pushed to stable|Pushed to oldstable Version(s)|20.05.00, 19.11.05 |20.05.00, 19.11.05, released in||19.05.10 CC||lu...@bywatersolutions.com --- Comment #8 from Lucas Gass --- backported to 19.05.x for 19.05.10 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Joy Nelson changed: What|Removed |Added Version(s)|20.05.00|20.05.00, 19.11.05 released in|| Status|Pushed to master|Pushed to stable CC||j...@bywatersolutions.com --- Comment #7 from Joy Nelson --- Backported to 19.11.x for 19.11.05 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Martin Renvoize changed: What|Removed |Added Version(s)||20.05.00 released in|| Status|Passed QA |Pushed to master -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 --- Comment #6 from Martin Renvoize --- Nice work everyone! Pushed to master for 20.05 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Marcel de Rooy changed: What|Removed |Added QA Contact|testo...@bugs.koha-communit |m.de.r...@rijksmuseum.nl |y.org | CC||m.de.r...@rijksmuseum.nl -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Marcel de Rooy changed: What|Removed |Added Attachment #100158|0 |1 is obsolete|| --- Comment #5 from Marcel de Rooy --- Created attachment 100213 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=100213=edit Bug 22969: fix biblionumber on 001 in UNIMARC XSLT In UNIMARC default configuration the 001 is linked to biblio.biblionumber. In some XSLT files, 090$a is used. This is by default biblioitems.biblionumber so it usually works but it may not be the same and var biblionumber is used to create hyperlinks to record detail page. Test plan : 1) Use UNIMARC database 2) Set default in all XSLT system preferences 3) At OPAC, perform a search and click on a result 4) Check displayed page shows the correct biblio record 5) Same at intranet Signed-off-by: Bernardo Gonzalez Kriegel Tested on clean UNIMARC install. Before insert new records: "alter table biblioitems AUTO_INCREMENT = 5" Added two records, with result: +--+--+ | biblionumber | biblioitemnumber | +--+--+ |1 |5 | |2 |6 | +--+--+ Without patch, OPAC results shows for first record http://opac/cgi-bin/koha/opac-detail.pl?biblionumber=5, Wrong! with patch result is correct Works, no errors Signed-off-by: Marcel de Rooy -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Marcel de Rooy changed: What|Removed |Added Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Bernardo Gonzalez Kriegel changed: What|Removed |Added Attachment #89994|0 |1 is obsolete|| --- Comment #4 from Bernardo Gonzalez Kriegel --- Created attachment 100158 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=100158=edit Bug 22969: fix biblionumber on 001 in UNIMARC XSLT In UNIMARC default configuration the 001 is linked to biblio.biblionumber. In some XSLT files, 090$a is used. This is by default biblioitems.biblionumber so it usually works but it may not be the same and var biblionumber is used to create hyperlinks to record detail page. Test plan : 1) Use UNIMARC database 2) Set default in all XSLT system preferences 3) At OPAC, perform a search and click on a result 4) Check displayed page shows the correct biblio record 5) Same at intranet Signed-off-by: Bernardo Gonzalez Kriegel Tested on clean UNIMARC install. Before insert new records: "alter table biblioitems AUTO_INCREMENT = 5" Added two records, with result: +--+--+ | biblionumber | biblioitemnumber | +--+--+ |1 |5 | |2 |6 | +--+--+ Without patch, OPAC results shows for first record http://opac/cgi-bin/koha/opac-detail.pl?biblionumber=5, Wrong! with patch result is correct Works, no errors -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Bernardo Gonzalez Kriegel changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 --- Comment #3 from Fridolin SOMERS --- (In reply to Andreas Roussos from comment #2) > > So, under what circumstances does this problem occur? > How can I create a record that has biblionumber != biblioitemnumber? Hi, indeed it should usually not occur. I think it sometimes appears when some insert in catalog fail to insert in biblio but create a row in biblioitems. In this case autoincrement of biblioitems.biblioitemnumber is higher than biblio.biblionumber. You may try a modification in direct SQL : UPDATE biblioitems SET biblioitemnumber = 6 WHERE biblioitemnumber=5; Only for a test database ! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Andreas Roussos changed: What|Removed |Added CC||arouss1...@gmail.com --- Comment #2 from Andreas Roussos --- Hi Fridolin, (In reply to Fridolin SOMERS from comment #0) > In UNIMARC default configuration the 001 is linked to biblio.biblionumber. > In some XSLT files, 090$a is used. > This is by default biblioitems.biblionumber so it usually works but it may > not be the same and var biblionumber is used to create hyperlinks to record > detail page. I think 090$a is linked to biblioitems.biblioitemnumber in UNIMARC default configuration for English (see lines 75-76 of installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql). While trying to sign off your patch I realised that in my test UNIMARC DB with just four records the values for biblionumber and biblioitemnumber are the same in the SQL tables that I checked: MariaDB [koha_test]> SELECT biblionumber FROM biblio ; +--+ | biblionumber | +--+ |1 | |3 | |4 | |5 | +--+ MariaDB [koha_test]> SELECT biblionumber, biblioitemnumber FROM biblioitems ; +--+--+ | biblionumber | biblioitemnumber | +--+--+ |1 |1 | |3 |3 | |4 |4 | |5 |5 | +--+--+ MariaDB [koha_test]> SELECT biblionumber, biblioitemnumber FROM items ; +--+--+ | biblionumber | biblioitemnumber | +--+--+ |1 |1 | |3 |3 | |3 |3 | |4 |4 | |4 |4 | |5 |5 | +--+--+ When I set all XSLT system preferences to 'default', the hyperlinks in the search results work OK (without the patch applied). So, under what circumstances does this problem occur? How can I create a record that has biblionumber != biblioitemnumber? -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 --- Comment #1 from Fridolin SOMERS --- Created attachment 89994 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89994=edit Bug 22969: fix biblionumber on 001 in UNIMARC XSLT In UNIMARC default configuration the 001 is linked to biblio.biblionumber. In some XSLT files, 090$a is used. This is by default biblioitems.biblionumber so it usually works but it may not be the same and var biblionumber is used to create hyperlinks to record detail page. Test plan : 1) Use UNIMARC database 2) Set default in all XSLT system preferences 3) At OPAC, perform a search and click on a result 4) Check displayed page shows the correct biblio record 5) Same at intranet -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Fridolin SOMERS changed: What|Removed |Added Status|ASSIGNED|Needs Signoff Patch complexity|--- |Trivial patch -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 22969] fix biblionumber on 001 in UNIMARC XSLT
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22969 Fridolin SOMERS changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|koha-b...@lists.koha-commun |fridolin.som...@biblibre.co |ity.org |m -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
