December 2012 - Koha-bugs - lists.koha-community.org

[Bug 8312] New: Bug 1633 causes an error when upgrading the database
by bugzilla-daemon＠bugs.koha-community.org 15 Mar '13

15 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8312 Priority: P5 - low Change sponsored?: --- Bug ID: 8312 Assignee: oleonard(a)myacpl.org Summary: Bug 1633 causes an error when upgrading the database Severity: major Classification: Unclassified OS: All Reporter: robin(a)catalyst.net.nz Hardware: All Status: NEW Version: rel_3_8 Component: OPAC Product: Koha This causes an error on upgrade: [Tue Jun 26 04:58:51 2012] updatedatabase.pl: DBD::mysql::db do failed: Can't create table 'koha_central.biblioimages' (errno: 150) at /home/robin/kohaclones/ca/installer/data/mysql/updatedatabase.pl line 4634. This SQL: CREATE TABLE `biblioimages` ( `imagenumber` int(11) NOT NULL AUTO_INCREMENT, `biblionumber` int(11) NOT NULL, `mimetype` varchar(15) NOT NULL, `imagefile` mediumblob NOT NULL, `thumbnail` mediumblob NOT NULL, PRIMARY KEY (`imagenumber`), CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 doesn't work unless everything after 'ENGINE' is ommitted. -- You are receiving this mail because: You are watching all bug changes.

1 5

[Bug 7176] New: Split C4::Context into submodules
by bugzilla-daemon＠bugs.koha-community.org 14 Mar '13

14 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7176 Bug #: 7176 Summary: Split C4::Context into submodules Classification: Unclassified Change sponsored?: --- Product: Koha Version: unspecified Platform: All OS/Version: All Status: NEW Severity: minor Priority: P5 - low Component: Architecture, internals, and plumbing AssignedTo: paul.poulain(a)biblibre.com ReportedBy: ian.walls(a)bywatersolutions.com QAContact: ian.walls(a)bywatersolutions.com Blocks: 7119 C4::Context currently does way too many things: Reading koha-conf.xml Retrieving system preferences Connecting to Zebra Connecting to the database Getting marc from a Koha field Handling stopwords Setting user environment Showing versions of installed software Breaking this down into submodules (C4::Context::Preferences, C4::Context::DBH, C4::Context::Config, etc) would allow us to only call the parts we need in any given place, reducing the overhead of loading a page. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 1

[Bug 8724] New: Upgrade from NoZebra installs is broken
by bugzilla-daemon＠bugs.koha-community.org 14 Mar '13

14 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8724 Priority: P5 - low Change sponsored?: --- Bug ID: 8724 Assignee: gmcharlt(a)gmail.com Summary: Upgrade from NoZebra installs is broken Severity: enhancement Classification: Unclassified OS: All Reporter: tomascohen(a)gmail.com Hardware: All Status: NEW Version: master Component: Installation and upgrade (command-line installer) Product: Koha If the NoZebra syspref is set Koha gets busted after an upgrade, which doesnt warn the user about that. -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 8551] New: Course reserves
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '13

13 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8551 Priority: P5 - low Change sponsored?: --- Bug ID: 8551 Assignee: oleonard(a)myacpl.org Summary: Course reserves Severity: enhancement Classification: Unclassified OS: All Reporter: pelletiermaxime(a)gmail.com Hardware: All Status: NEW Version: master Component: OPAC Product: Koha New functionnality to add a status Reserved for the Not For Loan field of items. It also adds fields to add the name of the Teacher and the Course. It adds a new page in the OPAC to list all the items that have this status. The functionnality looks like what is in bug #8215, but it's much more simple. It was also one of the first features I added to koha, so it really lacks comments, isn't based on master (based on 3.8.2) and doesn't have database updates yet. I'm posting it here to see if there's any interest and to have feedback on how I did the functionnality. Thanks. -- You are receiving this mail because: You are watching all bug changes.

1 7

[Bug 7874] New: Templates::get_language generates lots of not defined warnings
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '13

13 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7874 Priority: P5 - low Change sponsored?: --- Bug ID: 7874 Assignee: gmcharlt(a)gmail.com Summary: Templates::get_language generates lots of not defined warnings QA Contact: koha.sekjal(a)gmail.com Severity: minor Classification: Unclassified OS: All Reporter: colin.campbell(a)ptfs-europe.com Hardware: All Status: NEW Version: master Component: Architecture, internals, and plumbing Product: Koha Was trying to track another error and found the get_languages routine in C4::Templates was giving lots of not defined errors in the logs. Looking closer found that the routine has obviously grown by accretion and was a) not always too clear in its intention b) was carelessly using undefined values c) was actually passing undef to other routines so they could in turn log warnings and return undef - only a few cycles wasted but it is a routine that could be called freqently. Have refactored the routine to address these concerns -- You are receiving this mail because: You are watching all bug changes.

1 7

[Bug 8805] New: Add a biblio-zebra-indexdefs.xsl for NORMARC
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '13

13 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8805 Priority: P5 - low Change sponsored?: --- Bug ID: 8805 Assignee: magnus(a)enger.priv.no Summary: Add a biblio-zebra-indexdefs.xsl for NORMARC Severity: major Classification: Unclassified OS: All Reporter: magnus(a)enger.priv.no Hardware: All Status: ASSIGNED Version: master Component: Searching Product: Koha I just did a fresh install of master with NORMARC, and when I try to run rebuild_zebra.pl I get this error: 10:39:24-23/09 zebraidx(10578) [warn] /home/magnus/sites/koha-dev/etc/zebradb/biblios/etc/dom-config-marc.xml: stylesheet biblio-zebra-indexdefs.xsl not found in path /home/magnus/sites/koha-dev/etc/zebradb/biblios/etc:/home/magnus/sites/koha-dev/etc/zebradb/etc:/home/magnus/sites/koha-dev/etc/zebradb/marc_defs/normarc/biblios:/home/magnus/sites/koha-dev/etc/zebradb/lang_defs/nb:/home/magnus/sites/koha-dev/etc/zebradb/xsl 10:39:24-23/09 zebraidx(10578) [warn] /home/magnus/sites/koha-dev/etc/zebradb/biblios/etc/dom-config-marc.xml: stylesheet biblio-zebra-indexdefs.xsl not found in path /home/magnus/sites/koha-dev/etc/zebradb/biblios/etc:/home/magnus/sites/koha-dev/etc/zebradb/etc:/home/magnus/sites/koha-dev/etc/zebradb/marc_defs/normarc/biblios:/home/magnus/sites/koha-dev/etc/zebradb/lang_defs/nb:/home/magnus/sites/koha-dev/etc/zebradb/xsl -- You are receiving this mail because: You are watching all bug changes.

1 16

[Bug 5038] New: Checkout by hour
by bugzilla-daemon＠bugs.koha-community.org 11 Mar '13

11 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5038 Summary: Checkout by hour Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Circulation AssignedTo: kyle.m.hall(a)gmail.com ReportedBy: brice.sanchez(a)sys-tech.net QAContact: koha-bugs(a)lists.koha-community.org CC: gmcharlt(a)gmail.com Estimated Hours: 0.0 Hello Everyone, I work for a big group of french-canadian library, they have a feature request for the Koha SIGB. They want to checkout books for few hours and days. So i want to work on this feature request and to be approved by the community because it's a long-term project (5 years min). I will make commit on the GIT in few days and i need help to make good job because i begin to work on Koha (i saw the code guidelines). If any similar job was done before me, please tell me because i found nothing on bugzilla. See you later. Brice S. PS : Sorry for my basic English. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.

1 4

[Bug 9293] New: action_logs not tracking payments
by bugzilla-daemon＠bugs.koha-community.org 11 Mar '13

11 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9293 Bug ID: 9293 Summary: action_logs not tracking payments Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Transaction logs Assignee: koha-bugs(a)lists.koha-community.org Reporter: nengard(a)gmail.com I have been checking the action_logs table to find payments and which user paid the fines, but I'm not seeing them at all. Below are my queries on the table. Logging is on, and it's tracking fines charged automatically and manually and it's tracking dropbox forgiving fines and writeoffs (i think). But not payments that I can see. The log should log all fines actions. mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and user != 0 limit 10; +---------------------+--------+--------+---------+-----------------------------------------------------+ | timestamp | user | action | object | info | +---------------------+--------+--------+---------+-----------------------------------------------------+ | 2012-09-02 11:40:50 | 146258 | | 1058715 | due=09/01/2012 23:59 amount=0.1 itemnumber=252043 | | 2012-09-02 11:41:51 | 146258 | | 1034172 | due=08/24/2012 23:59 amount=0.9 itemnumber=468810 | | 2012-09-02 11:43:23 | 146258 | | 1098788 | due=02/06/2012 23:59 amount=3.00 itemnumber=292689 | | 2012-09-02 11:44:48 | 146258 | | 1098788 | due=01/30/2012 23:59 amount=3.00 itemnumber=395796 | | 2012-09-02 11:45:09 | 146258 | | 1034172 | due=08/24/2012 23:59 amount=0.9 itemnumber=486769 | | 2012-09-02 11:47:06 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=491656 | | 2012-09-02 11:47:12 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=526858 | | 2012-09-02 11:47:16 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=537406 | | 2012-09-02 11:47:22 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=511679 | | 2012-09-02 11:47:41 | 146258 | | 1098788 | due=02/06/2012 23:59 amount=3.00 itemnumber=489449 | +---------------------+--------+--------+---------+-----------------------------------------------------+ 10 rows in set (0.00 sec) mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and action='MODIFY' and user != 0 limit 10; +---------------------+--------+--------+---------+-----------------------------------+ | timestamp | user | action | object | info | +---------------------+--------+--------+---------+-----------------------------------+ | 2012-09-02 11:51:09 | 146257 | MODIFY | 1149266 | Dropbox adjustment 0, item 399887 | | 2012-09-02 11:51:18 | 146257 | MODIFY | 1149266 | Dropbox adjustment 0, item 537469 | | 2012-09-02 11:51:23 | 146257 | MODIFY | 1066164 | Dropbox adjustment 0, item 4588 | | 2012-09-02 11:56:03 | 146257 | MODIFY | 1104714 | Dropbox adjustment 0, item 541027 | | 2012-09-02 11:56:12 | 146257 | MODIFY | 1104714 | Dropbox adjustment 0, item 12471 | | 2012-09-02 11:57:03 | 146257 | MODIFY | 1182366 | Dropbox adjustment 0, item 84270 | | 2012-09-02 11:58:51 | 146257 | MODIFY | 1033313 | Dropbox adjustment 0, item 331794 | | 2012-09-02 11:59:27 | 146257 | MODIFY | 1066164 | Dropbox adjustment 0, item 538578 | | 2012-09-02 12:01:12 | 146257 | MODIFY | 1149753 | Dropbox adjustment 0, item 190944 | | 2012-09-02 14:17:32 | 146254 | MODIFY | 1052342 | Dropbox adjustment 0, item 553366 | +---------------------+--------+--------+---------+-----------------------------------+ 10 rows in set (0.00 sec) Database changed mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and action='MODIFY' and user != 0 and info not like '%dropbox%' limit 10; +---------------------+--------+--------+---------+-------------------------------+ | timestamp | user | action | object | info | +---------------------+--------+--------+---------+-------------------------------+ | 2012-09-04 08:38:51 | 146257 | MODIFY | 1175137 | Overdue forgiven: item 384714 | | 2012-09-04 08:39:23 | 146257 | MODIFY | 1164307 | Overdue forgiven: item 205688 | | 2012-09-04 08:40:24 | 146257 | MODIFY | 1175137 | Overdue forgiven: item 394110 | | 2012-09-04 08:40:32 | 146257 | MODIFY | 1164307 | Overdue forgiven: item 93445 | | 2012-09-04 08:40:36 | 146257 | MODIFY | 1164307 | Overdue forgiven: item 366920 | | 2012-09-04 08:40:41 | 146257 | MODIFY | 1164307 | Overdue forgiven: item 373410 | | 2012-09-04 09:14:13 | 146257 | MODIFY | 751038 | Overdue forgiven: item 372751 | | 2012-09-04 09:18:16 | 146272 | MODIFY | 1180787 | Overdue forgiven: item 208422 | | 2012-09-04 09:23:14 | 146272 | MODIFY | 1180787 | Overdue forgiven: item 517498 | | 2012-09-04 09:25:53 | 146272 | MODIFY | 1180787 | Overdue forgiven: item 415316 | +---------------------+--------+--------+---------+-------------------------------+ 10 rows in set (0.01 sec) mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and action='MODIFY' and user != 0 and info not like '%dropbox%' and info not like '%forgiven%' limit 10; Empty set (2.28 sec) mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and user != 0 and info not like '%dropbox%' and info not like '%forgiven%' limit 10; +---------------------+--------+--------+---------+-----------------------------------------------------+ | timestamp | user | action | object | info | +---------------------+--------+--------+---------+-----------------------------------------------------+ | 2012-09-02 11:40:50 | 146258 | | 1058715 | due=09/01/2012 23:59 amount=0.1 itemnumber=252043 | | 2012-09-02 11:41:51 | 146258 | | 1034172 | due=08/24/2012 23:59 amount=0.9 itemnumber=468810 | | 2012-09-02 11:43:23 | 146258 | | 1098788 | due=02/06/2012 23:59 amount=3.00 itemnumber=292689 | | 2012-09-02 11:44:48 | 146258 | | 1098788 | due=01/30/2012 23:59 amount=3.00 itemnumber=395796 | | 2012-09-02 11:45:09 | 146258 | | 1034172 | due=08/24/2012 23:59 amount=0.9 itemnumber=486769 | | 2012-09-02 11:47:06 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=491656 | | 2012-09-02 11:47:12 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=526858 | | 2012-09-02 11:47:16 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=537406 | | 2012-09-02 11:47:22 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=511679 | | 2012-09-02 11:47:41 | 146258 | | 1098788 | due=02/06/2012 23:59 amount=3.00 itemnumber=489449 | +---------------------+--------+--------+---------+-----------------------------------------------------+ 10 rows in set (0.00 sec) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 23

[Bug 5333] New: Undefined value stops import from z39.50
by bugzilla-daemon＠bugs.koha-community.org 11 Mar '13

11 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5333 Summary: Undefined value stops import from z39.50 Change sponsored?: --- Product: Koha Version: HEAD Platform: All OS/Version: Linux Status: NEW Severity: normal Priority: P5 Component: MARC Bibliographic record staging/import AssignedTo: gmcharlt(a)gmail.com ReportedBy: dtcrsby(a)gmail.com QAContact: koha-bugs(a)lists.koha-community.org CC: ian.walls(a)bywatersolutions.com Estimated Hours: 0.0 I'm having problems importing some records from z39.50. I had the issue with 3.00.01.005, so I updated to the git HEAD, but still having problems. The error I get is: "Software error: Can't call method "add_subfields" on an undefined value at /home/koha/kohaclone/cataloguing/addbiblio.pl line 142." I've got a few records that should reproduce the problem (they're from AMICUS) The MARC data of one book: LDR 01554cam a22003854a 4500 001 2005281191 003 DLC 005 20091006 .0 008 050826s2005 cc 001 0 eng 010 _a 2005281191 020 _a0596007973 040 _aDLC _beng _cDLC _dDLC 042 _apcc 050 00 _aQA76.73.P98 _bP95 2005 082 00 _a005.13/3 _222 245 00 _aPython cookbook / _cedited by Alex Martelli, Anna Martelli Ravenscroft, and David Ascher. 250 _a2nd ed. 260 _aBeijing ; _aSebastopol, CA : _bO'Reilly, _cc2005. 300 _axxxiii, 807 p. ; _c24 cm. 500 _a"Recipes from the Python community"--Cover. 500 _aIncludes index. 650 0 _aPython (Computer program language) 700 1 _aAscher, David. 700 1 _aMartelli, Alex. 700 1 _aMartelli Ravenscroft, Anna. 852 _91 _aCaBVAS _hQA 76.73 P98 P983 2005 _zILL: yes 852 _92 _aCaNFSM _hQA 76.73 P98 P95 2005 _zILL: yes 852 _93 _aCaNSLAL _hQA 76.73 P98 P95 2005 _zILL: yes 852 _94 _aCaOOU _hQA 76.73 .P98 P95 2005 _zILL: yes 852 _95 _aCaOPAL _hQA 76.73 P98P95 2005 _zILL: yes 852 _96 _aCaSPANI _hQA76.73.P98.P95 2005 _zILL: yes 852 _97 _aCaSRRE _hQA 76.73 P98 M3 2005 _zILL: yes 856 42 _3Publisher description _uhttp://www.loc.gov/catdir/enhancements/fy0715/2005281191-d.html 856 42 _3Contributor biographical information _uhttp://www.loc.gov/catdir/enhancements/fy0912/2005281191-b.html 856 41 _3Table of contents only _uhttp://www.loc.gov/catdir/enhancements/fy1001/2005281191-t.html The MARC data of a CD: LDR 01118cjm a2200265Ka 4500 001 000034984704 003 CaOOAMICUS 005 20090609 .0 007 sd fsngnnmmneu 008 080514s2008 xx n zxx d 024 8 _a00602517671836 024 1 _a602517671836 028 02 _aB0011135-02 _bDGC/Interscope Records 040 _aCaBVA _beng _cBTCTA _dJBU 110 2 _aWeezer (Musical group) 245 10 _aWeezer _h[sound recording]. 246 1 _iAlso known as: _aRed album _h[sound recording] 260 _aSanta Monica, CA : _bDGC/Interscope Records, _cp2008. 300 _a1 sound disc : _bdigital, stereo ; _c4 3/4 in. 500 _aRock songs, chiefly by Rivers Cuomo. 505 00 _tTroublemaker _g(2:44) -- _tGreatest man that ever lived (Variations on a Shaker hymn) _g(5:52) -- _tPork and beans _g(3:09) -- _tHeart songs _g(4:05) -- _tEverybody get dangerous _g(4:02) -- _tDreamin' _g(5:11) -- _tThought I knew _g(3:01) -- _tCold dark world _g(3:51) -- _tAutomatic _g(3:078) -- _tAngel and the one _g(6:46). 538 _aCompact disc. 650 0 _aRock music _y2001-2010. 700 1 _aCuomo, Rivers. 852 _91 _aCaBVA _zILL: no -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.

1 16

[Bug 8682] New: quick slip: renewals do not appear on quick slips
by bugzilla-daemon＠bugs.koha-community.org 11 Mar '13

11 Mar '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8682 Priority: P5 - low Change sponsored?: --- Bug ID: 8682 CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Assignee: koha-bugs(a)lists.koha-community.org Summary: quick slip: renewals do not appear on quick slips Severity: normal Classification: Unclassified OS: All Reporter: wizzyrea(a)gmail.com Hardware: All Status: NEW Version: rel_3_8 Component: Circulation Product: Koha If a patron brings in a book that is Due, and wishes to have it Renewed, the Quick Print Fails to print the item title, Due Date or any other piece of information about the item. The slip only prints the patron name and ID number. If the clerk chooses other print options, the entire list of items that the patron is in possession of are printed including the Renewed items. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 9