- Koha - lists.katipo.co.nz

koha bugs
by Caitlin McGurk 15 Nov '10

15 Nov '10

Hello everyone, I'm currently working on a proposal for a Koha system for my library, and trying to get a handle on where and how frequently bugs are come across in the system. I will be installing and maintaining it myself with no vendor help or IT department, and am a bit worried on the sort of bugs that I will come across in the process as well as when running it in the future. Do the main issues lie in upgrading? Or are daily problems often found within the system? Truly hoping this is the right solution for us Caitlin McGurk Head Librarian The Center for Cartoon Studies mcgurk(a)cartoonstudies.org

3 2

Re: [Koha] Add new option to OPAC user menu
by Owen Leonard 15 Nov '10

15 Nov '10

> Problem solved. I've tried now in Firefox and it is working. Perhaps you could share with us what you've developed? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

Koha bugs
by Caitlin McGurk 15 Nov '10

15 Nov '10

Hello everyone, I'm currently working on a proposal for a Koha system for my library, and trying to get a handle on where and how frequently bugs are come across in the system. I will be installing and maintaining it myself with no vendor help or IT department, and am a bit worried on the sort of bugs that I will come across in the process as well as when running it in the future. Do the main issues lie in upgrading? Or are daily problems often found within the system? Truly hoping this is the right solution for us Caitlin McGurk Head Librarian The Center for Cartoon Studies mcgurk(a)cartoonstudies.org

1 0

Add new option to OPAC user menu
by Vitor Fernandes 15 Nov '10

15 Nov '10

Hello. I've added an new option in the OPAC user menu where the user can change his reading preferences. The reading preferences is a custom attribute created for the effect. The problem is that the OPAC uses Javascript to change the interface, but when the user select the new option reading preferences the all page is reload. I know that the problem is that I'm not using Javascript to do the page change, but I don't know where and which JavaScript file I need to change. Thanks for your time. Regards. Vitor Fernandes

2 1

Upgrading from 3.0.6 to 3.2
by Martin Longo 15 Nov '10

15 Nov '10

Hello list ... Today I was testing around the new koha 3.2 release (very last 3.02.00.004)... trying to upgrade our current production Koha (3.0.6) ... I just droped the new database and loaded the old one, to see if updatedatabase.pl would take all the work on it's shoulders... And it did... almost. In step 3 I had a lot of errors and I'd like to know if someone has faced the same situation and have any tips on the matter. Most of them refer to duplicated entries and already present tables (could I assume that that's not a big problem?) except for this two (that seems to be a little more troublesome): * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near './koha-tmpl/opac-tmpl/prog/en/xslt/MARC21slim2OPACResults.xsl,'YesNo')' at line 2 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3449. * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near './koha-tmpl/opac-tmpl/prog/en/xslt/MARC21slim2OPACDetail.xsl,'YesNo')' at line 2 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3453. Following I paste the errors reported by the updater (a little long list) Thanks in advance * [Wed Nov 3 13:07:34 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'hold_fill_targets' already exists at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 1969. * [Wed Nov 3 13:07:34 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'item_level_request' at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 1988. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowRenewalLimitOverride' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2035. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'OPACDisplayRequestPriority' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2042. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'reserves-HOLD' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2049. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2053. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-sms-0' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2054. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-email-0' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2055. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'issn' at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2062. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_transfer_limits' already exists at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2098. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'UseBranchTransferLimits' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2107. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '1-circulate_remaining_permissions' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2117. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '1-override_renewals' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2118. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowHoldPolicyOverride' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2151. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_item_rules' already exists at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2152. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'default_branch_item_rules' already exists at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2163. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'holdallowed' at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2171. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'holdallowed' at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2175. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'OPACAmazonCoverImages' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2260. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AmazonCoverImages' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2262. * [Wed Nov 3 13:07:37 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'smsalertnumber' at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2298. * [Wed Nov 3 13:08:33 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'ceilingDueDate' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2353. * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AmazonReviews' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2377. * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowNotForLoanOverride' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2395. * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'RenewalPeriodBase' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2412. * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewISBD' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2455. * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewLabeledMARC' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2456. * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewMARC' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2457. * [Wed Nov 3 13:08:38 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AWSPrivateKey' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2501. * [Wed Nov 3 13:09:04 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'fieldmapping' already exists at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2695. * [Wed Nov 3 13:09:04 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'finedays' at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 2752. * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near './koha-tmpl/opac-tmpl/prog/en/xslt/MARC21slim2OPACResults.xsl,'YesNo')' at line 2 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3449. * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near './koha-tmpl/opac-tmpl/prog/en/xslt/MARC21slim2OPACDetail.xsl,'YesNo')' at line 2 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3453. * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'reserves-HOLDPLACED' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3561. * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '9-edit_items' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3663. * [Wed Nov 3 13:10:16 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '15-check_expiration' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3672. * [Wed Nov 3 13:10:19 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'HomeOrHoldingBranchReturn' for key 1 at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3754. * [Wed Nov 3 13:10:19 2010] updatedatabase.pl: Argument "3.0100XXX" isn't numeric in numeric lt (<) at /home/koha/koha-clone/installer/data/mysql/updatedatabase.pl line 3803. -- Ing. J. Martin Longo Depto. Gestion Informatica SID - UNCuyo http://sid.uncu.edu.ar

3 4

Official Koha Newsletter: Volume 1, Issue 11: November 2010
by Nicole Engard 15 Nov '10

15 Nov '10

This issue has a lot of links and should be read online to see all of the external content: http://koha-community.org/koha-newsletter-volume-1issue-11-november-2010 Official Koha Newsletter (ISSN 2153-8328) Volume 1, Issue 11: November 2010 Table of Contents * KohaCon10 Summary o Summary of KohaCon10 in Blog Posts o KohaCon10 Presentations o KohaCon10 Videos o KohaCon10 Pictures KohaCon10 Summary of KohaCon10 in Blog Posts KohaCon10 took place in Wellington, New Zealand last month to honor 10 years of Koha development, use and community! It seems that your trusty documentation manager was unofficially names the official blogger of the conference, so excuse a newsletter full of links to posts written by me (and Ian Walls, my colleague who had cover the sessions I couldn’t). * Conference Proper o Keynote o Why a Librarian Loves Koha o Koha and Kete o Koha Adoption in Nigeria o Koha Governance o What’s Coming in Koha 3.4 o Fun with Library Data o Identifying eBooks o A cooperative view o Koha in Schools o Sharing is Good o History of Koha o Koha in Prison o Participation is Key o Koha in Malaysia o LAMP to Koha o Promoting Free Software in Libraries o Open Library and Koha o Koha: 10 years in 10 minutes * Hackfest o Intro to Git o Git and Koha o Template Toolkit o MySQL and Postgres Differences o Debian Packaging for Koha o Koha in the Cloud o An Argument for a project Coding Style o Ideas for Koha 4.0 o Koha Performance * Summaries o KohaCon10 is Finished o KohaCon10 Additional Posts KohaCon10 Presentations Some KohaCon10 presentations were posted on SlideShare, others posted on personal websites and others plotted on a map. If I’ve missed any please feel free to add them in the comments below. * KohaCon10 on SlideShare * KohaCon10 Presentation Map * Specific Presentations o Koha at ASHS by Mark Osborne o Fun with Library Data by David Friggens KohaCon10 Videos KohaCon10 videos are still making their way online, here are a few that are up so far. You can search for the rest as they’re added on blip.tv by using the keyword “kohacon10” * Keynote by Rosalie Blake * Why Librarians Love Koha by Lee Phillips o Video of Lee’s librarians * Kete and Koha by Walter McGinnis * Koha uptake in Nigeria by Olugbenga Adara * Library Data for Fun & Profit by David Friggens * Koha: 10 years in 10 minutes KohaCon10 Pictures Mostly KohaCon10 pictures were posted on Flickr and tagged “kohacon10“. My favorites were taken by Kristina, she knows how to take pictures!! Thank you to all who took pictures and shared them so that those back home could share in the festivities with us and so that we can all look back and remember our time together fondly. What we didn’t get was a group picture that I could post here, so you’ll have to go browse through the Flickr pictures and spot your friends and community members that way. Newsletter edited by Nicole C. Engard, Koha Documentation Manager. Please send future story ideas to me.

1 0

how to access koha 3.0 opac from client system
by Yatheesh Y 15 Nov '10

15 Nov '10

Dear all I installed koha 3.0 on ubuntu my sytem in LAN i want give permission to access koha from client system please tell me what steps should i follow --

1 0

storage space concern for Koha and requirements
by Caitlin McGurk 14 Nov '10

14 Nov '10

Hi all, Very base (and possibly ignorant) question regarding the installation of Koha and its requirements (Linux, Apache, MySQL, Perl) from a beginner. For a collection of 9,000 materials, does anyone have a concept of how much computer space that would take up on a hard drive? Trying to evaluate how large of a backup will be needed once everything is in place. Thank you Caitlin McGurk Head Librarian The Center for Cartoon Studies mcgurk(a)cartoonstudies.org

2 1

Semi-automatic minutes for IRC meetings on #koha
by Galen Charlton 14 Nov '10

14 Nov '10

Hi, At Chris Cormack's suggestion, I have added the MeetBot [2] plugin to munin's bag of tricks. MeetBot is a tool to help run IRC meetings and, more importantly, produce a summary of the discussion, including action items, automatically. Here's a brief list of the important commands. Commands for the chair: #startmeeting - Start a meeting. Whoever starts the meeting is designated the owner (and have permanent chair powers). #chair - Add somebody to the list of chairs #endmeeting - End the meeting. #topic - Set a new topic. #agreed - Document an agreement in the minutes. Commands for Everyone: #info - Add an info item to the minutes. People should liberally use this for important things they say, so that they can be logged in the minutes. #action - Document an action item in the minutes. Include any nicknames in the line, and the item will be assigned to them. (nicknames are case-sensitive) #idea - Add an idea to the minutes. #help - Add a "Call for Help" to the minutes. Use this command when you need to recruit someone to do a task. (Counter-intuitively, this doesn't provide help on the bot) #link - Add a link to the meeting minutes. The link should be the first non-command on the line, other commentary after the link is OK. Links beginning with http:// and a few other protocols are automatically detected. There is a manual [2] for MeetBot available which includes a tutorial and a reference to its full set of commands. For an example of the summary generated by the bot, please check out: http://librarypolice.com/koha-meetings/2010/koha.2010-11-14-19.41.html The full log corresponding to this meeting is: http://librarypolice.com/koha-meetings/2010/koha.2010-11-14-19.41.log.html If anybody wants to hold a fake (or even a real) meeting to try it out, I'll be around to help. I propose that we try MeetBot for the next general IRC meeting; if we like the results, we can adopt it. [1] http://wiki.debian.org/MeetBot [2] http://meetbot.debian.net/Manual.html Regards, Galen -- Galen Charlton gmcharlt(a)gmail.com

1 0

November Newsletter
by Nicole Engard 13 Nov '10

13 Nov '10

Hello all, I'm thinking for the next Koha Newsletter we'll do a conference sum-up. So between the start of the conference and the 12th of November please send me links to posts you may have written about conference sessions, links to pictures from KohaCon, and anything else conference related. Thanks Nicole C. Engard

1 2