July 2005 - Koha-bugs - lists.koha-community.org

[Bug 1002] Error in bulkmarcimport indicates possible permissions problem with install.
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Jul '05

18 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1002 ------- Additional Comments From jferraro(a)athenscounty.lib.oh.us 2005-07-19 02:05 ------- All the production Koha's I know about are running at least MySQL 4 if not 4.1. 3.23 has major speed limitations (no query_cache) so any sites not using 4 should probably upgrade. Since 4.x is the default for most modern distros these days (yes, even Debian ;-)), we should at least warn if our default password type isn't set correctly for that version. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1002] Error in bulkmarcimport indicates possible permissions problem with install.
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Jul '05

18 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1002 ------- Additional Comments From mjr(a)ttllp.co.uk 2005-07-19 01:54 ------- Do we support mysql 4 now? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1002] Error in bulkmarcimport indicates possible permissions problem with install.
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Jul '05

18 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1002 ------- Additional Comments From jferraro(a)athenscounty.lib.oh.us 2005-07-19 00:52 ------- Shouldn't the installer notify the user of this potential problem? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1002] Error in bulkmarcimport indicates possible permissions problem with install.
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Jul '05

18 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1002 tgarip(a)neu.edu.tr changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED ------- Additional Comments From tgarip(a)neu.edu.tr 2005-07-19 00:21 ------- This is not a bug but an issue with MySql as of version 4. You have to set your Mysql to accept old style passwords Try this: mysql> set password for kohaadmin=old_password('somepassword'); This should remedy 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 1002] Error in bulkmarcimport indicates possible permissions problem with install.
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Jul '05

18 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1002 ------- Additional Comments From jferraro(a)athenscounty.lib.oh.us 2005-07-19 00:11 ------- Sure ... : select user,host from mysql.user; | kohaadmin | localhost | select user,host,db from mysql.db; | kohaadmin | % | Koha | ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1002] Error in bulkmarcimport indicates possible permissions problem with install.
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Jul '05

18 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1002 mjr(a)ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Additional Comments From mjr(a)ttllp.co.uk 2005-07-18 20:46 ------- Can you please send me the output of: select user,host from mysql.user; select user,host,db from mysql.db; Thanks. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1002] New: Error in bulkmarcimport indicates possible permissions problem with install.
by bugzilla-daemon＠wilbur.katipo.co.nz 17 Jul '05

17 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1002 Summary: Error in bulkmarcimport indicates possible permissions problem with install. Product: Koha Version: 2.2.0 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P2 Component: Installation AssignedTo: mjr(a)ttllp.co.uk ReportedBy: jferraro(a)athenscounty.lib.oh.us QAContact: koha-bugs(a)lists.sourceforge.net I think the mysql user permissions aren't quite right with a new installation. Here's the error: DBD::mysql::db do failed: Access denied for user 'kohaadmin'@'localhost' to database 'Koha' at koha//C4/Biblio.pm line 333. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1001] New: Issuing Rules Error
by bugzilla-daemon＠wilbur.katipo.co.nz 12 Jul '05

12 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1001 Summary: Issuing Rules Error Product: Koha Version: 2.2.0 Platform: PC URL: http://article.gmane.org/gmane.comp.misc.koha/4814 OS/Version: All Status: NEW Severity: normal Priority: P2 Component: Circulation AssignedTo: chris(a)katipo.co.nz ReportedBy: mjr(a)ttllp.co.uk QAContact: koha-bugs(a)lists.sourceforge.net Mailing list report from Sandra Smith: "I am testing out the functions of a borrower group and I get this warning Too many issues /already issued / max a 0 / 0 I have checked the parameters and changed them to 99,99 on the * area. But even when the issuing rules were set to 99,99 for just that type of item I received the same error but that time it was c / 0." Suggested bugfix is at the URL given in this report. I've not seen a reply on-list, so I'm copying it here: sub TooMany ($$){ my $borrower = shift; my $iteminformation = shift; my $cat_borrower = $borrower->{'categorycode'}; my $branch_borrower = $borrower->{'branchcode'}; my $dbh = C4::Context->dbh; my $sth = $dbh->prepare('select itemtype from biblioitems where biblionumber = ?'); $sth->execute($iteminformation->{'biblionumber'}); my $type = $sth->fetchrow; $sth = $dbh->prepare('select * from issuingrules where categorycode = ? and itemtype = ? and branchcode = ?'); my $sth2 = $dbh->prepare("select COUNT(*) from issues i, biblioitems s where i.borrowernumber = ? and i.returndate is null and i.itemnumber = s.biblioitemnumber and s.itemtype like ?"); my $sth3 = $dbh->prepare('select COUNT(*) from issues where borrowernumber = ? and returndate is null'); my $alreadyissued; # check the 3 parameters $sth->execute($cat_borrower, $type, $branch_borrower); my $result = $sth->fetchrow_hashref; my $cnt_f = $DBI::rows; # return("==>".$result->{maxissueqty}.$cnt_f); # return("==>".$result->{maxissueqty}); # warn "==>".$result->{maxissueqty}; if (defined($result)) { $sth2->execute($borrower->{'borrowernumber'}, "%$type%"); my $alreadyissued = $sth2->fetchrow; return ("a $alreadyissued / ".($result->{maxissueqty}+0)) if ($result->{'maxissueqty'} <= $alreadyissued); return; } # check for branch=* $sth->execute($cat_borrower, $type, ""); my $result = $sth->fetchrow_hashref; if (defined($result)) { $sth2->execute($borrower->{'borrowernumber'}, "%$type%"); my $alreadyissued = $sth2->fetchrow; return ("b $alreadyissued / ".($result->{maxissueqty}+0)) if ($result->{'maxissueqty'} <= $alreadyissued); return; } # check for itemtype=* $sth->execute($cat_borrower, "*", $branch_borrower); my $result = $sth->fetchrow_hashref; if (defined($result)) { $sth3->execute($borrower->{'borrowernumber'}); my $alreadyissued = $sth2->fetchrow; return ("c $alreadyissued / ".($result->{maxissueqty}+0)) if ($result->{'maxissueqty'} <= $alreadyissued); return; } #check for borrowertype=* $sth->execute("*", $type, $branch_borrower); my $result = $sth->fetchrow_hashref; if (defined($result)) { $sth2->execute($borrower->{'borrowernumber'}, "%$type%"); my $alreadyissued = $sth2->fetchrow; return ("d $alreadyissued / ".($result->{maxissueqty}+0)) if ($result->{'maxissueqty'} <= $alreadyissued); return; } $sth->execute("*", "*", $branch_borrower); my $result = $sth->fetchrow_hashref; if (defined($result)) { $sth3->execute($borrower->{'borrowernumber'}); my $alreadyissued = $sth2->fetchrow; return ("e $alreadyissued / ".($result->{maxissueqty}+0)) if ($result->{'maxissueqty'} <= $alreadyissued); return; } $sth->execute("*", $type, ""); my $result = $sth->fetchrow_hashref; if (defined($result) && $result->{maxissueqty}>=0) { $sth2->execute($borrower->{'borrowernumber'}, "%$type%"); my $alreadyissued = $sth2->fetchrow; return ("f $alreadyissued / ".($result->{maxissueqty}+0)) if ($result->{'maxissueqty'} <= $alreadyissued); return; } return; } $sth->execute($cat_borrower, "*", ""); my $result = $sth->fetchrow_hashref; if (defined($result)) { $sth2->execute($borrower->{'borrowernumber'}, "%$type%"); my $alreadyissued = $sth2->fetchrow; return ("g $alreadyissued / ".($result->{maxissueqty}+0)) if ($result->{'maxissueqty'} <= $alreadyissued); return; } $sth->execute("*", "*", ""); my $result = $sth->fetchrow_hashref; if (defined($result)) { $sth3->execute($borrower->{'borrowernumber'}); my $alreadyissued = $sth2->fetchrow; return ("h $alreadyissued / ".($result->{maxissueqty}+0)) if ($result->{'maxissueqty'} <= $alreadyissued); return; } return; } ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 119] Dewey Numbers like 000 or 581.0 aren't handled properly
by bugzilla-daemon＠wilbur.katipo.co.nz 12 Jul '05

12 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=119 ------- Additional Comments From shedges(a)athenscounty.lib.oh.us 2005-07-13 05:32 ------- This bug is still a problem in 2.2.3. I have mapped MARC 21 subfield 082a to biblioitems.dewey. When I enter a Dewey number -- e.g. "505.5" -- the value that always gets saved in biblioitems.dewey is "99.999999" ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1000] installer: drop/suppress entries in mysql if re-launching installer script
by bugzilla-daemon＠wilbur.katipo.co.nz 05 Jul '05

05 Jul '05

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1000 mjr(a)ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Additional Comments From mjr(a)ttllp.co.uk 2005-07-05 20:57 ------- The installer is cautious about deleting data. If you already have koha installed, why not use the upgrader? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0