- Koha - lists.katipo.co.nz

Database update errors
by Perch 12 Dec '11

12 Dec '11

Upon updating koha to the latest version I got these error when running database update: [Mon Dec 12 13:04:03 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'hold_fill_targets' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 1983. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowRenewalLimitOverride' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2049. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'reserves-HOLD' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2063. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2067. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-sms-0' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2068. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-email-0' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2069. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'issn' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2076. [Mon Dec 12 13:04:06 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_transfer_limits' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2112. [Mon Dec 12 13:04:07 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '1-override_renewals' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2132. [Mon Dec 12 13:04:08 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_item_rules' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2166. [Mon Dec 12 13:04:08 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'default_branch_item_rules' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2177. [Mon Dec 12 13:04:10 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'item_circulation_alert_preferences' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2199. [Mon Dec 12 13:04:11 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'ccode' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2238. [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'OPACAmazonCoverImages' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2274. [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AmazonCoverImages' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2276. [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'smsalertnumber' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2312. [Mon Dec 12 13:04:13 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AmazonReviews' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2391. [Mon Dec 12 13:04:13 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowNotForLoanOverride' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2409. [Mon Dec 12 13:04:14 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'RenewalPeriodBase' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2426. [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'export_format' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2695. [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'fieldmapping' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2709. [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'finedays' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2766. [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqbudgets' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2951. [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed: Unknown column 'aqbudgetid' in 'aqbudgets' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2955. [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'startdate'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3003. [Mon Dec 12 13:04:25 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqorders_items' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3123. [Mon Dec 12 13:04:26 2011] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'budget_amount_sublevel'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3177. [Mon Dec 12 13:04:27 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'deliveryplace' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3239. [Mon Dec 12 13:04:28 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'billingplace' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3288. [Mon Dec 12 13:04:31 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'collections' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3377. [Mon Dec 12 13:04:31 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'collections_tracking' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3387. [Mon Dec 12 13:04:35 2011] patroncards_upgrade.pl: DBD::mysql::db do failed: Table 'creator_batches' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/patroncards_upgrade.pl line 149. [Mon Dec 12 13:04:35 2011] patroncards_upgrade.pl: DB ERROR: Table 'creator_batches' already exists [Mon Dec 12 13:04:35 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'csv_separator' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3418. [Mon Dec 12 13:04:35 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'encoding' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3429. [Mon Dec 12 13:04:48 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3997. [Mon Dec 12 13:04:48 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3998. [Mon Dec 12 13:04:51 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'freedeliveryplace' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4251. [Mon Dec 12 13:04:58 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'need_merge_authorities' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4535. Will these be a problem or is it safe to just ignore them? Most of them seem to be related to data already existing in the database with this exception: [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed: Unknown column 'aqbudgetid' in 'aqbudgets' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2955. -- View this message in context: http://koha.1045719.n5.nabble.com/Database-update-errors-tp5068234p5068234.… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Regarding the book entry
by dawit.ayalew＠tabyengineering.com 09 Dec '11

09 Dec '11

Dear sure, I can't manage to insert book to the koha library and also connect the z3950 it would be great if you guys give me small examples and steps to be done. Thanks!!! I also tried zotero to perform this task but I can't manage to get it work with koha ILS. Best Regards, -- *Dawit Ayalew Software Development TABY Engineering P.L.C. at GIZ IS Bole Road, TK International Building No. 2 5th Floor Room No. 502 Addis Ababa, Ethiopia T: +251 11 662 22 60 Ext. 5024 +251 11 618 38 50 M: +251 91 180 07 08 E: dawit.ayalew(a)tabyengineering.com I: www.tabyengineering.com *

2 1

Is it possible to take an XML feed of individual records and bring it into Koha or MARC format?
by Hartman, David W. - GBTS Library 09 Dec '11

09 Dec '11

Is it possible to take an XML feed of individual records and bring it into Koha or MARC format? Gartner can only send their article records to me as XML ... I don't know how to get it from XML to MARC.. David W. Hartman Global Business Technology Strategy Library Team Disney 336N 407 828 4250 (8-222) FAX 407 828 4868 FOLLOW MY RESEARCH on Backlot<http://backlot.disney.com/> & Yammer<http://www.yammer.com/>! Learn about our research partners in the 2011 IT Research Competency Center <http://tink.corp.disney.com/?i=n7a> GBTS CAST can click to request AV Equipment<http://tink.corp.disney.com/?i=jbo>, Books<http://tink.corp.disney.com/?i=jbp>, & Research<http://tink.corp.disney.com/?i=jbn> WATCH the GBTS Library (Video) Update<http://tink.corp.disney.com/?i=2f0> ! CLICK for the GBTS VIRTUAL LIBRARY<http://tink.corp.disney.com/?i=1wn>portal site!! "This communication is confidential, intended only for the named recipients above and may contain trade secrets or other information that is exempt from disclosure under applicable law. Any use, dissemination, distribution or copying of this communication by anyone other than the named recipients is strictly prohibited. If you have received this communication in error, please immediately notify us by calling (407) 828-4250. Thank you." [cid:image001.gif@01CCB65C.1A36D7B0]Please consider your environmental responsibility before printing this e-mail [cid:image001.gif@01CCB65C.1A36D7B0] Think Environmentality! Reduce! Reuse! Recycle!

2 3

How can i get serial number in the generated reports
by tanzeem 09 Dec '11

09 Dec '11

Hi I have generated a report using the guided report option. Since i have deleted some records while entering records i dont have some of the biblionumbers as valid.So i dont get a report arranged in an increasing order of serial number from 1 to the total number of rows in the generated reports . How can I get this. Please help... with thanks in advance -- View this message in context: http://koha.1045719.n5.nabble.com/How-can-i-get-serial-number-in-the-genera… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Re: [Koha] Improving permissions on lists (virtual shelves)
by Adalid Ortiz 08 Dec '11

08 Dec '11

Oh sorry, is not my Koha Opac is an Argentina Koha fork based on version 2.x my opac is 3.4 and is located at http://clavius.tij.uia.mx the funcionality i want is: LISTS Architecture *** History of art I [list of related bibliography] *** Computer Aided Design II [list of related bibliography] * Computer Science *** Calculus I [list of related bibliography] *** Algebra I [list of related bibliography] etc. Administred by one person but all can see it. Saludos, Felipe Adalid Ortiz Anzaldo Bibliotecario de sistemas Universidad Iberoamericana Tijuana Biblioteca Loyola http://clavius.tij.uia.mx Ave. Centro Universitario 2501 Playas de Tijuana 22200, Tijuana, B.C. 0 664 630-1577 Ext. 623 adalid(a)tij.uia.mx

1 0

Re: [Koha] Improving permissions on lists (virtual shelves)
by Adalid Ortiz 08 Dec '11

08 Dec '11

Excellent but I want to add a useful feature, list categories and subcategories like in this Koha fork called "Estantes virtuales": http://biblioteca.exactas.unlp.edu.ar/cgi-bin/koha/opac-shelves.pl?startfro… Saludos, Felipe Adalid Ortiz Anzaldo Bibliotecario de sistemas Universidad Iberoamericana Tijuana Biblioteca Loyola http://clavius.tij.uia.mx Ave. Centro Universitario 2501 Playas de Tijuana 22200, Tijuana, B.C. 0 664 630-1577 Ext. 623 adalid(a)tij.uia.mx "En una jerarquía, el poder lo tiene quien guarda secretos; en una red el poder lo obtiene quien disemina información. -John Perry Barlow-> >Subject: Re: [Koha] Improving permissions on lists (virtual shelves) > From: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl> > Date: Wed, 7 Dec 2011 16:08:58 +0000 > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz>, > "koha-devel(a)lists.koha-community.org" <koha-devel(a)lists.koha-community.org> > >--===============0312935277== >Content-Language: nl-NL >Content-Type: multipart/alternative; > boundary="_000_809BE39CD64BFD4EB9036172EBCCFA3137F0B6SMAIL1Brijksmuseu_" > >--_000_809BE39CD64BFD4EB9036172EBCCFA3137F0B6SMAIL1Brijksmuseu_ >Content-Type: text/plain; charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > >Thanks all for responding to this inquiry. This was very helpful. > > > >I am merging here the results and will be posting them back to report 7310 = >or a wiki page. Feel free to correct me where I made the wrong conclusion. > > > >1 Public lists in OPAC: Currently, a user should be logged in to create a l= >ist. I would strongly recommend to keep that restriction. A new preference = >is added that allows opac users to create public lists or does not allow th= >at. > >Additionally, I would add the restriction that another opac user cannot cha= >nge the list type of a public list to private list or change the list permi= >ssions when he did not create it (currently possible); the owner can do tha= >t or a staff member with permissions in the staff client. > > > >2 Three new permissions per list: Add items, Delete own items, Delete other= > items. This makes the Open list type obsolete. > > > >3 Share private lists with another patron (as described before). Can be tur= >ned on/off with a preference. > > > >4 Staff client features: add an option under Tools to moderate inappropriat= >e list names for public lists and shared private lists. (A library is free = >to use it or not.) Add staff list permission: allow to manage lists (virtua= >l shelves). With that permission a staff member can moderate the list names= > as mentioned and access the staff Lists module. (He can change list type a= >nd permissions. He can take ownership of a public list if the owner has bee= >n deleted.) > >

2 1

Problem in Indexing Koha 3.06.01
by Prajeesh 08 Dec '11

08 Dec '11

I have a system installed with Koha 3.06.01 adding a record and its item done successfully. While searching the record its item is not showing . We can find the item by clicking on the title. Same problems is existed in OPAC. Every time I need to index the zebra, but the zebra is already running. Please tell me what is the problem. -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560

2 1

Check out my photos on Shtyle.fm
by KAMLESH KUMAR SHUKLA 08 Dec '11

08 Dec '11

1 0

Removing Authorized Lists
by Lenora Oftedahl 07 Dec '11

07 Dec '11

Version 3.00.00.107 Yeah, yeah, old version. We're working on upgrading. Anyway, how do I remove empty Authorized Values lists? And, I've tried to add a new one, but when I add entries, nothing shows. I don't find anything in the 3.0 manual on koha-community. Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission

1 0

KohaCon13
by MJ Ray 07 Dec '11

07 Dec '11

Hi all. Sorry if the subject line got your hopes up. I should be mailing out more news of KohaCon12 in a few days, but apparently it falls to me as the host of KohaCon12 to start this ball rolling: Who might be interested in hosting KohaCon13? This is just an initial expression of interest and doesn't commit you to anything at this point. We'd just like to know who's interested and we'll email you when the time comes to send in actual proposals if it looks like you may have missed the call. Of course, personally, I'd love it if we can decide before KohaCon12 next June, formally pass the baton over and then try to start the process for '14, to make it a bit easier for everyone to budget (both as attendees and hosts!). Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and LMS developer, statistician. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha

1 0