September 2003 - Koha-bugs - lists.koha-community.org

[Bug 500] [INTRANET]Only 21 items are displayed in the search result
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Sep '03

30 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=500 paul.poulain(a)free.fr changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED ------- Additional Comments From paul.poulain(a)free.fr 2003-10-01 04:34 ------- already fixed a few time ago. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 599] edited items are stored incorrectly in old Koha DB
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Sep '03

30 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=599 paul.poulain(a)free.fr changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |paul.poulain(a)free.fr ------- Additional Comments From paul.poulain(a)free.fr 2003-10-01 04:33 ------- *** Bug 608 has been marked as a duplicate of this bug. *** ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 608] barcode can be null in MARC & cannot in non MARC
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Sep '03

30 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=608 paul.poulain(a)free.fr changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED OS/Version| |All Resolution| |DUPLICATE ------- Additional Comments From paul.poulain(a)free.fr 2003-10-01 04:33 ------- *** This bug has been marked as a duplicate of 599 *** ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 616] MARCgetbiblio doesn't create leader
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Sep '03

30 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=616 paul.poulain(a)free.fr changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From paul.poulain(a)free.fr 2003-10-01 04:32 ------- fixed. It was a bug in leader length (19 char instead of 24) ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 599] edited items are stored incorrectly in old Koha DB
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Sep '03

30 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=599 paul.poulain(a)free.fr changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED ------- Additional Comments From paul.poulain(a)free.fr 2003-10-01 04:22 ------- added barcode NOT mandatory feature. Just run updatedatabase to get it. Note it's impossible to issue an item without barcode, as issue/returns is based on barcode... ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 622] processz3950queue fails
by bugzilla-daemon＠wilbur.katipo.co.nz 29 Sep '03

29 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=622 chris(a)clanhobbs.org changed: What |Removed |Added ---------------------------------------------------------------------------- OS/Version| |All ------- Additional Comments From chris(a)clanhobbs.org 2003-09-30 08:35 ------- I was able to solve the problem by removing all records in the 'z3950queue' table, and modifying the name field of the LOC record in the 'z3950servers' table to read 'Library_of_Congress'. There's something unquoted that should be in the script. I am now able to query LOC, although I never get back any records, but that will likely be another bug after I experiment some more. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 622] New: processz3950queue fails
by bugzilla-daemon＠wilbur.katipo.co.nz 27 Sep '03

27 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=622 Summary: processz3950queue fails Product: Koha Version: 2.0.0 Platform: PC Status: NEW Severity: major Priority: P2 Component: MARC AssignedTo: paul.poulain(a)free.fr ReportedBy: chris(a)clanhobbs.org QAContact: koha-bugs(a)lists.sourceforge.net When attempting to use z3950 search, error log fills with these entries... no results are ever returned. starting loop DBD::mysql::st execute failed: Unknown MySQL error at /usr/local/koha/scripts/z3950daemon//processz3950queue line 62. DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/koha/scripts/z3950daemon//processz3950queue line 134. DBD::mysql::st fetchrow failed: Unknown MySQL error at /usr/local/koha/scripts/z3950daemon//processz3950queue line 58. DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/koha/scripts/z3950daemon//processz3950queue line 118. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/scripts/z3950daemon//processz3950queue line 119. DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/koha/scripts/z3950daemon//processz3950queue line 118. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/scripts/z3950daemon//processz3950queue line 119. DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/koha/scripts/z3950daemon//processz3950queue line 134. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/local/koha/scripts/z3950daemon//processz3950queue line 134. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/local/koha/scripts/z3950daemon//processz3950queue line 134. Library ==> at /usr/local/koha/scripts/z3950daemon//processz3950queue line 156.Processing title="Count Zero" at Library (6 forks) Library ERROR: Can't call method "option" on an undefined value at /usr/local/koha/scripts/z3950daemon//processz3950queue line 157. done. Library ==> at /usr/local/koha/scripts/z3950daemon//processz3950queue line 156.Processing isbn="0441117732" at Library (4 forks) Library ERROR: Can't call method "option" on an undefined value at /usr/local/koha/scripts/z3950daemon//processz3950queue line 157. done. of ==> at /usr/local/koha/scripts/z3950daemon//processz3950queue line 156. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/local/koha/scripts/z3950daemon//processz3950queue line 250. of ==> at /usr/local/koha/scripts/z3950daemon//processz3950queue line 156. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/local/koha/scripts/z3950daemon//processz3950queue line 250. Processing isbn="0441117732" at of (5 forks) of ERROR: Can't call method "option" on an undefined value at /usr/local/koha/scripts/z3950daemon//processz3950queue line 157. done. Processing title="Count Zero" at of (7 forks) of ERROR: Can't call method "option" on an undefined value at /usr/local/koha/scripts/z3950daemon//processz3950queue line 157. done. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 599] edited items are stored incorrectly in old Koha DB
by bugzilla-daemon＠wilbur.katipo.co.nz 26 Sep '03

26 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=599 ------- Additional Comments From paul.poulain(a)free.fr 2003-09-27 01:11 ------- OK, I think i've got it... Let me explain... The problem is here : "First, remember that the problem started when staff had added an item to an existing biblio record *without* *a* *barcode*, and then edited that item to add the barcode." why ? Because in the DB barcode is set to NOT NULL. And there is a UNIQUE INDEX on this row. So, if you try to enter an item without barcode, you get in error log : DBD::mysql::st execute failed: Column 'barcode' cannot be null at /home/paul/koha.dev/koha/C4/Biblio.pm line 1701. meaning the item row has NOT been created. the problem is that the itemnumber is returned even if no item has been created. then, you create a new item (with a barcode) that has the same number as the "false one". Then you have 2 items with the same items.itemnumber in MARC. Then your DB is broken... The solution(s) : * immediate solution : modify barcode in your MARC parameter table to make it mandatory : i've tested, it works => you can't validate if there is no barcode number. If the barcode exists, it's refused too. * we could change the DB structure to barcode = non mandatory. Is it a good idea ? I'll ask on koha ml. /me is quite happy to have found the problem... ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 599] edited items are stored incorrectly in old Koha DB
by bugzilla-daemon＠wilbur.katipo.co.nz 26 Sep '03

26 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=599 ------- Additional Comments From paul.poulain(a)free.fr 2003-09-27 00:17 ------- THIS is important : >>>> But also notice that the MARC record has an accession date (tag 952v) attached to barcode 37000000025523 that is actually the date when the edit to barcode 31000000109284 was done! It should actually have no accession date, because no date was in the imported MARC record loaded on September 1. <<<< Why ? Because dateaccessioned is managed only in NEWitem, not in MODitem (why ? I don't know. Maybe it's a bug...) so, it means data has been "created" by the OLDNEWitem sub, not another one (even in circulation it seems. Maybe we could dig a little bit if this is a bug or not. I continue my digging. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 532] Can't assign new password without changing UserID
by bugzilla-daemon＠wilbur.katipo.co.nz 26 Sep '03

26 Sep '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=532 mjr(a)ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From mjr(a)ttllp.co.uk 2003-09-27 00:15 ------- Fixed and committed to CVS. This page now cannot set a userid to be blank, which may be another bug. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0