[Koha] Report coming up short?

?biblionumber=',biblionumber,'\',title,'/a') AS Title FROM biblio ORDER BY biblionumber Thanks, Paul Tired old sys-admin ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report coming up short?

At 01:29 PM 4/21/2011 -0500, Liz Rea wrote: Paul, Try adding a LIMIT some number way over the top of what you expect for reults to the end of that report, and see if it works. Thank you Liz and Ian -- now functional Best regards - Paul Liz Rea NEKLS On Apr 21, 2011, at 12:57 PM, Paul wrote

Re: [Koha] Tag 041

, Paul Tired old sys-admin ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] perl modue Graphics::Magick not found

... = Installation results === make install-am make[1]: Entering directory `/home/paul/graphicsmagick1.3.5/GraphicsMagick-1.3.5' ( rm -f PerlMagick/PerlMagick ; cd PerlMagick make CC='gcc -std=gnu99' PerlMagick ; make CC='gcc -std=gnu99' PerlMagick ) make[2

Re: [Koha] perl modue Graphics::Magick not found

the outcome is - but it will probably be a day or two as I'm looking to install 3.4 concurrently with 3.2. Thanks - Paul --Mizst On Fri, Apr 29, 2011 at 10:08 PM, Paul mailto:pau...@aandc.orgpau...@aandc.org wrote: At 05:40 PM 4/28/2011 -0400, Chris Nighswonger wrote: Try GraphicsMagick-perl

[Koha] memc missing

During checks prior to installing 3.4, I found: paul@server2:~/koha3.4/koha-3.04.00.000$ ./koha_perl_deps.pl -u -m Module Name Current Version Required Version Module Required - CGI::Session::Driver::memc

Re: [Koha] memc missing

At 04:53 AM 4/30/2011 +0700, Mizst Audens wrote: The name is actually CGI::Session::Driver::memcached. The text is cut off when displayed by the utility. Thanks - and yes indeed - that's why I wrote below that I suspected libcache-memcached-perl, but that we're apparently up-to-date: paul

Re: [Koha] An entertaining article about libraries and librarians

At 09:03 PM 5/2/2011 +0700, hans...@gmail.com wrote: Check out the bit about being sure to wake up sleeping patrons - in case they're dead!! http://www.guardian.co.uk/books/2011/may/01/the-secret-life-of-librarie Unfortunately the url got snipped; it should be:

Re: [Koha] Why are there 2 versions?

security alerts. Given our satisfaction with Koha, I'll definitely be keeping an eye on future versions; but in the meanwhile, I respectfully beg to differ with the statement that everyone will be expected to get themselves upgraded. Regards - Paul Tired old sys-admin. --- Archives

Re: [Koha] Truncating the nozebra table in koha DB

Paul --- Tired old sys-admin ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Truncating the nozebra table in koha DB

try and wrap my head around this, but do you know of a detailed description of how zebra is *supposed* to work, vice how it *actually* works, particularly with Koha. [the myisam vice innodb is complex but well documented, but not wrt zebra.] tnx - p. Chris On 3 Sep 2011 12:53, Paul

[Koha] 3.6.1 updatedatabase.pl [was: Checkout fails]

::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3998. A quick verification showed no loss of functionality, but I haven't yet had time to look at what privacy means|does. Paul At 08:35 PM 12/16/2011 +0800

[Koha] Authorities lost during upgrade to 3.6.1

as staff is concerned. For example, when a cataloguer attempts to enter another title by Abbass, D.K. (the authority I quote above), she cannot find it in the drop-down for 100a I'm sure there's a simple fix, but at the moment I'm tearing my hair out -- thanks in advance. Paul

Re: [Koha] Authorities lost during upgrade to 3.6.1

At 02:56 AM 1/5/2012 +1300, Mason James wrote: On 2012-01-3, at 10:09 AM, Paul wrote: Hoping someone can help, please. We recently upgraded from 3.2 to 3.6.1 and nearly everything went well during import of ~15,000 biblios, but something has happened to the authorities -- only newly

Re: [Koha] Authorities lost during upgrade to 3.6.1

? And is there a way in staff-client to find the record matching (presumably biblio #, but I can't find it even in advanced search) 12,836? [Or is it easier to work directly from the mysql?] Again, many thanks - Paul ___ Koha mailing list http

Re: [Koha] Authorities lost during upgrade to 3.6.1

? Entering without quotes biblionumber: 12836 (no comma delimiter for thousands) is the way to go.] Again, many thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Authorities lost during upgrade to 3.6.1

/0/0 09:58:57-05/01 zebraidx(3048) [log] Records: 12835 i/u/d 12835/0/0 Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Deduplicate authorities

-v -x) -- no joy. Is there a way to deduplicate? Thanks and regards - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] US-Centric question - SOPA/PIPA protest blackout on k-c.org tomorrow (US time)?

did write to you off list on this subject but have not yet heard back. For the record, we are in Canada and would prefer not to be involved in USA politics. Thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http

Re: [Koha] Install for Dummies

At 08:27 PM 1/21/2012 -0500, Bruce A Metcalf wrote: Paul wrote: [snip] koha@nelson:/usr/share/koha$ KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib ./bin/migration_tools/rebuild_zebra.pl -a -r -v koha@nelson:/usr/share/koha$ KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share

Re: [Koha] OPAC MARC View display not working well

as I can see, there is no intrinsic problem with 3.06.01.000 Best -- Paul eg: http://eso.koha-ptfs.eu/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=17503 and http://eso.koha-ptfs.eu/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=17069 (which incidentally also shows the 942 tag in labelled MARC view

[Koha] Z39.50 pop-up box

and file a bug + fix. Thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Z39.50 pop-up box

[apologies for delay, I first sent this from a wrong email address] At 01:07 PM 2/4/2012 -0500, Chris Nighswonger wrote: On Sat, Feb 4, 2012 at 12:14 PM, Paul mailto:pau...@aandc.orgpau...@aandc.org wrote: We have added a couple of additional Z39.50 sources and now, when we open (under

Re: [Koha] Z39.50 pop-up box

a marvelously formatted list of eight possible sources with no *apparent* actions to be taken or buttons to click. Again, not a big thing -- it's just for the beauty of Koha. tnx and br - paul ___ Koha mailing list http://koha-community.org Koha

Re: [Koha] Z39.50 pop-up box

thus far, Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha search [was: Koha Digest, Vol 76, Issue 32]

Preferences -- Searching and verify on the first line that you have |Use| the Zebra search engine enabled. I that fails, you may want to look for errors in /var/log/koha -- you should find specific error logs for both Koha and zebra. Paul misc/migration_tools/rebuild_zebra.pl -b -a -v -r Zebra

Re: [Koha] How to include 952$x in a report

At 10:24 AM 2/21/2012 +1300, Chris Cormack wrote: On 21 February 2012 10:17, Paul pau...@aandc.org wrote: Help requested please from an expert in MySQL reports. Â The code below works perfectly, but I want to add 952$x (a text string for the condition of our holdings as in good/fair or fine

Re: [Koha] 3.6.2 - System preferences cannot be updated

an authorized value for shelving location; to avoid editing LOC, I set up a new set of values as LOC2, edited the framework, but LOC2 came up entirely blank until I rebooted. Best - Paul ___ Koha mailing list http://koha-community.org Koha

Re: [Koha] Windows or browser failure on certain Koha functions

. Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] ISBN 13 to 10

(i.e. with 978 at the beginning and correct check sum) for the same book finds it instantly. At some point in the past, someone must have considered this a desirable feature -- I'm intrigued as to the reasons. Thanks - Paul ___ Koha mailing list

Re: [Koha] Deleting Records

How often does your cronjob reindex zebra? So how do you delete unwanted records?? Your error message probably confirms that it is in fact deleted from the mysql tables. Paul ___ Koha mailing list http://koha-community.org Koha

Re: [Koha] Subtitles

Navy. Our Keyword to MARC Mapping shows 245$b as mapped to 'Subtitle', so I am just looking for a simple way (we can concatenate later if needed) to get the value of the field into the report. Best - Paul Nicole On Sat, Mar 31, 2012 at 12:17 PM, Paul pau...@aandc.org wrote: Could some kind

Re: [Koha] Merging several books under one biblio

different publisher, edition date, edition statement, whatever ... you will lose that data. Our cataloguers only use it for exact duplicate biblios taht have been entered in error. hth - paul ___ Koha mailing list http://koha-community.org Koha

Re: [Koha] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

.) Lessons: you never have too many backups and innodb can be sensitive to insipid HD failure - consider a RAIDed setup. Also note that this email is not technical advice, and I take no responsibility whatsoever for success or failure. Paul On Mon, Apr 30, 2012 at 12:35 PM, Robin Sheat ro

Re: [Koha] Right To Left in Arabic KOHA

causes the pages to look very strange for right-to-left readers. [snip] A long shot perhaps, I've not had time to look into detail, but the latest (12.0) version of Firefox has introduced CSS text-align-last; see https://developer.mozilla.org/en/CSS/text-align-last Best - Paul

Re: [Koha] Problem in importing Patron Records

regarding patron import. Please help me. The .csv file is attached. The file was not attached. Did you use the default Koha format for dates as -MM-DD? From the errors, you appear to be using DD/MM/ (but this could just be your sys pref for output.) Paul Import Patrons Import results

Re: [Koha] command line export biblio

script ;={ So could someone pls fill me in? Thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 3.8.1 'zebra searching' failure

to liblimes's http://koha.org, not *this* open-source Koha -- are you sure your Tech Support has installed 3.8.1? Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Spell-check/ Did you mean

) finds 1637 ... weird. Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Excel to MARC - Marcedit 5.8

joining the list at http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L. As an aside, has anyone managed to get MarcEdit to function on a Linux box? We have failed miserably. Best - Paul Regards Amit Bondwal On Tue, Jun 26, 2012 at 1:40 AM, Stacy Pober [via Koha] ml-node+s1045719n571771...@n5

[Koha] Serials framework

cataloguers have to remember to change it? Even after setting 942$c to serials, the m keeps appearing in the leader. Thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Serials framework

that by them they would be pretty clean. Again, thanks for your assistance, Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] RLIN

it be searched? Example: the default 730 for serials/continuing resources shows only a single input line 9 (RLIN) - obviously, I can add $a to get a searchable UNIF_TITLE, but there must be some reason for the default to hide this option. Thanks - Paul

Re: [Koha] RLIN

At 09:45 AM 7/17/2012 -0400, Nicole Engard wrote: Paul, There is no more RLIN (although I now the references are still there in the frameworks). In 2006 RLIN was merged with OCLC. http://en.wikipedia.org/wiki/Research_Libraries_Group Thanks Nicole. Good background (shame that our budget

Re: [Koha] Error while installing koha on development mode

-community.org/wiki/Koha_3.8_on_Debian_Squeeze Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] zebra not rebuilding

a plain, single positive, Use the Zebra search engine. Muchas gracias por su interés en este tema, y tener una buena noche. Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Completeness of records for importing

(for a full discussion of 260$c and 260$g, see http://www.loc.gov/marc/bibliographic/bd260.html.) Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 3.8.4 search on barcode

to have continued through the versions; CAVEAT: 3.6.7 and 3.8.4 were new installs on different servers using an sql dump/restore from our production 3.6.1, and were not upgrades in the sense of overwriting a previous install. HTH and br - Paul ___ Koha

Re: [Koha] Zebra not updating biblios automatically in koha 3.8

the following two lines: export PERL5LIB=/usr/share/koha/lib export KOHA_CONF=/etc/koha/koha-conf.xml :x then reboot your server. This in itself cannot do any harm, and could well cure your problem. Best - Paul Elaine Bradtke On Fri, Aug 31, 2012 at 12:05 PM, sunil sharma koha.sunil...@gmail.com

Re: [Koha] Zebra not updating biblios automatically in koha 3.8

or Zebra. Our sandbox is tied up at the moment, but tomorrow I should be able to get some time to do a detailed comparison of 3.6 with 3.8. However if I'm not correct in my assumption, maybe someone would be kind enough to avoid my going on a wild goose chase. Thanks - Paul [1] -- I understand

Re: [Koha] Zebra not updating biblios automatically in koha 3.8

@ DLC 005 - DATE AND TIME OF LATEST TRANSACTION @ 20110813090406.0 008 - FIXED-LENGTH DATA ELEMENTS @ 110310|||a|| | ||| d 040 ## - CATALOGING SOURCE a Original cataloging DLC c Transcribing agency OPIACS Best - Paul ___ Koha mailing list

Re: [Koha] Zebra not updating biblios au tomatically in koha 3.8

the cron to: paul@server:/etc/cron.d$ cat koha # KOHA_CONF=/etc/koha/koha-conf.xml # KOHAPATH=/usr/share/koha # PERL5LIB=$KOHAPATH/lib */1 * * * *koha$KOHAPATH/bin/migration_tools/rebuild_zebra.pl -a -b -z /dev/null Works perfectly QED *nix != windoze Not sure it's relevant

Re: [Koha] Zebra not updating biblios au tomatically in koha 3.8

At 01:06 PM 9/4/2012 -0300, Tomas Cohen Arazi wrote: On Tue, Sep 4, 2012 at 1:01 PM, Paul pau...@aandc.org wrote: [snip] KOHA_CONF=/etc/koha/koha-conf.xml KOHAPATH=/usr/share/koha PERL5LIB=$KOHAPATH/lib */1 * * * *koha$KOHAPATH/bin/migration_tools/rebuild_zebra.pl -a -b -z /dev

[Koha] 3.8.4 staff main page

be found. I had a quick, unsuccessful, look around with firebug, so it would be most helpful if someone could point me towards the relevant perl or template file. Many thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

Re: [Koha] Browse by hierarchy - Links not working

locate C4 messages. If this does not help, at least it narrows down other possibilities. Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Installtion problem

+ two blank lines to the end of the file; verify line count = 16 :x Verify that the /usr/share... copy has been updated identically. $ ./misc/sax_parser_print.pl [must now report Looks good.] HTH - Paul ___ Koha mailing list http://koha

[Koha] OPAC display double vision

thanks -- and for Canadians, Happy Thanksgiving Day. Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] OPAC display double vision

At 09:40 PM 10/8/2012 +0200, Fischer, Katrin wrote: Hi Paul, I think your problem could be related to a 6xx field without $a. The label Subject(s) is showing up, but there is no link after it. I think there is an open anchor tag that doesn't close breaking your display here. Hi Katrin

Re: [Koha] OPAC display double vision

At 11:37 AM 10/9/2012 +0200, Fischer, Katrin wrote: Hi Paul, This seems to do the trick for me: Hi Katrin -- and for me :=) Found one more floating RLIN in the 600$a fields and also ran it for all other 6xx without further errors showing up. Many thanks for a great start to my day. Paul

Re: [Koha] Migration of Multiple copies (Ruth Bavousett)

who develops the software (Terry Reece) is quite brilliant and extremely helpful. HTH - Paul [1] we did try a few years ago to install MarcEdit with Wine on a Ubuntu 10.04 box; maybe it worked, but it was so slow that we got nowhere with it. --- Maritime heritage and history, preservation

Re: [Koha] rebuild_zebra: Biblios aren't displayed anymore

-x Best - Paul [1] You can verify this in mysql with: SELECT GROUP_CONCAT(biblionumber SEPARATOR ', ') AS biblionumbers, EXTRACTVALUE(marcxml,'//controlfield[@tag=001]') AS id FROM biblioitems GROUP BY id HAVING count(id) 1 ___ Koha mailing list

Re: [Koha] Addition to Koha Web Page as a Koha Support Provider / Ozgur Yazilim A.S.

Do you really provide PostgreSQL and Solr support? Best - Paul At 07:26 PM 11/2/2012 +0200, Doruk Fisek wrote: Hi, As per the web page here, I'm sending e-mail to this list (hope I'm not doing anything wrong) : http://koha-community.org/support/paid-support/how-to-get-listed/ We would

Re: [Koha] Addition to Koha Web Page as a Koha Support Provider / Ozgur Yazilim A.S.

At 08:13 AM 11/3/2012 +1300, you wrote: On 2012-11-3, at 7:41 AM, Paul wrote: Do you really provide PostgreSQL and Solr support? Best - Paul does it really say they do? no... Yup ... (apologies for not getting the proper accent on the 'g') Teknik Altyap1: * Barkod okuyucu destegi

Re: [Koha] Addition to Koha Web Page as a Koha Support Provider / Ozgur Yazilim A.S.

At 08:13 AM 11/3/2012 +1300, you wrote: On 2012-11-3, at 7:41 AM, Paul wrote: Do you really provide PostgreSQL and Solr support? Best - Paul does it really say they do? no... Yup ... (apologies for not getting the proper accent on the 'g') Teknik Altyap1: * Barkod okuyucu destegi

[Koha] Biblios not deleting in Zebra [was: (no subject)]

and Intranet)? This is a known problem; I am about to upgrade it to a bug. In the meanwhile, in a terminal: su koha #or whatever name you set up for zebra indexing cd usr/share/koha ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x Best - Paul

[Koha] MySQL to update dateaccessioned

OK, 0 rows affected (0.04 sec) Rows matched: 1302 Changed: 0 Warnings: 0 Help really appreciated ... Many thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] MySQL and year published

reports purely 1974 ... so where is the text saved? Many thanks and best regards, Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] bug in Acquisition module, regarding VAT management ?

we certainly do in this context), then it's 'prix de vente au détail' or 'prix de vente public.' Bonnes fêtes de fin d'année a+ Paul ___ Koha-devel mailing list koha-de...@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman

Re: [Koha] Urgent assistance on physical items for this record and zebraqueue queries

, Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Punctuation in Koha

team member's eyes on it? I can confirm that it is fully functional and does not appear to break anything on 3.8.5 (sandbox.) Best - Paul Regards, Jared -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web

[Koha] Koha reports, include cataloguer

ON biblio.biblionumber = items.biblionumber WHERE whatever but need a JOIN clause for action_logs (could be RIGHT? timestamp? = ?) Without the third line the report is fully functional. Could someone kindly assist? Thanks and best regards, Paul ___ Koha mailing

Re: [Koha] Changing OPAC Item Status

/opac/htdocs/opac-tmpl/prog/en/modules/opac-results.tt line 455 edit 'Copies available' == 'On shelf' Staff: /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/catalogue/results.tt near end of line 547 edit 'Available' == 'On shelf' Best - Paul

Re: [Koha] [Koha-devel] Call for news for the January newsletter

At 12:34 PM 1/11/2013 -0800, Daniel Grobani wrote: Dear Koha kommunitarians, I'm harvesting news for this month's newsletter. Please send me by the 20th anything you think your fellow community members might like to know about. Based on our news release, 11 January 2013

Re: [Koha] A general query about UI customization

in this list could briefly describe their production upgrade policy. Best regards, Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. http://NavalMarineArchive.com and http://UltraMarine.ca

Re: [Koha] Z39.50 issues

) times out 80% of the time in our experience, so we hardly ever use it. Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Ubuntu 11.04

. As a matter of netiquette, might I suggest that you do not cross post to the users *and* the devel lists? Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] A Little Help with Perl/CPAN

. For ubuntu/debian the module you need is libbusiness-isbn-data-perl and an 'apt-get install' type of instruction will work fine. For redhat|fedora|opensuse see http://rpm.pbone.net/index.php3/stat/3/srodzaj/1/search/perl%28Business%3A%3AISBN%29 Paul

Re: [Koha] A Little Help with Perl/CPAN

) is available at http://ftp.slackware.com/pub/CPAN/authors/id/BDFOY/. It's the same version as used by Koha 3.8. Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Deleted records are appearing in the staff client /OPAC

*The record you requested does not exist. *Kindly assist me how to remove the same.* su koha (or whatever user you set up during installation) cd usr/share/koha ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x This should read your records (100 at a time on screen), then clean them. Best - Paul

Re: [Koha] why do i get a Duplicate Record suspected message while adding records while there is no similariyty between the books in content or name or author or copy number

HAVING count(id) 1; Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] FW: OPAC files not secured ---

restart This is fairly basic www server management (we've had it in place ever since we went public) -- please try it at http://opac.navalmarinearchive.com/opac-tmpl/prog/en/css/ which gives the desired 403 page. Best - Paul ___ Koha mailing list

Re: [Koha] Please advice how to improve our search issue

) running Koha on Ubuntu, with MemCache: $ free -m total used free sharedbuffers cached Mem: 2379463 1916 0 82178 -/+ buffers/cache:202 2177 Swap: 3999 0 3999 Best - Paul

Re: [Koha] Please advice how to improve our search issue

At 11:19 AM 4/10/2013 +1200, Robin Sheat wrote: Paul schreef op di 09-04-2013 om 18:27 [-0400]: That looks like a very busy, if not overloaded, server. You need (at least) to increase the size of your swap to at least double what it is currently set at (either resize partition or add

Re: [Koha] Weird textboxes in koha 3.10.4

in a kiosk environment) for Koha 3.8.x Do you have a live example of a 3.10 server that I could look at? Many thanks - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] search problem in koha 3.10.4

this every 15 minutes while our cataloguers are working, otherwise duplicate/unwanted biblios creep in and can get very confusing for non-techies. Best - Paul On Wed, Apr 17, 2013 at 10:36 AM, Mohamed Megahed mr_mega...@hotmail.comwrote: Hi all I have installed koha 3.10.4 on ubuntu

[Koha] Mysql query

, but lists only biblionumber=1 and the total value of everything we have ever catalogued ;={ Maybe it's not possible and a Perl script is required? Many thanks for any suggestions. Paul ___ Koha mailing list http://koha-community.org Koha

Re: [Koha] Marc framework errors

allows you to make this into a CRON job as soon as you're happy it works to your liking :} Best regards, Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Cataloguing: Fields not working

$ is notorious for retention, the others are not far behind. Best - Paul Good luck. Ian On 12/05/2013 13:05, Joel Harbottle wrote: Hi All, I have added some extra fields into a couple of our cataloguing MARC templates which are for local use, but have come across a tiny problem with them. These fields

Re: [Koha] Zebra Indexing problem with upgrade

rebuild in two stages: first 'rebuild_zebra.pl -b -r -v -x', then 'rebuild_zebra.pl -a -r -v' Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How frequently to run zebra rebuild and what switches

users see is what the cataloguers intended. Hence the need to run -r fairly promptly. The search function down-time, while zebra is cleaning, is only a couple of seconds, particularly if you clean the logs, sessions, imports and zebraqueue every 24 hours. Best - Paul

Re: [Koha] Querry related to Deletion in KOHA.

to the new one prior to rebuilding Zebra -b -r. I have been able to reproduce this, but not systematically ... (this happens more often with serials than books, but it's not framework dependant.) Best - Paul Regards Mayank On Fri, Aug 23, 2013 at 4:59 PM, Tomas Cohen Arazi tomasco

Re: [Koha] Report on Titles in the collection

: 21 List of shipping / 19 Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Query for report on items catalogue in a date.

AS Author, items.barcode AS Barcode FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE DATE(items.dateaccessioned) BETWEEN Accessioned BETWEEN (-mm-dd) AND and (-mm-dd); Best - Paul --- Maritime heritage and history, preservation and conservation, research

Re: [Koha] Query for report on items catalogue in a date.

At 08:17 PM 8/27/2013 +, Gay Richards wrote: Paul This is great. I was looking for this too. Unfortunately the html doesn't seem to work when downloaded to csv but I guess I could remove that. Without the html, it is a little shorter: SELECT biblio.title AS Title, biblio.author AS Author

Re: [Koha] Zebra rebuild error

-b -r -v -x We've been running a totally stable 3.8.5 in production for about a year now (so might just be able to help) but your environment looks very, very different. Paul I tried to reindex the zebra server using following commands. export KOHA_CONF=/path to .xml file export PERL5LIB

Re: [Koha] Import MARC record error: utf8 \xE0

.) Best - Paul I checked the imported file, and it seem to look fine to me. The MARCXML in the database look ok too. But if I save the MARC BLOB and use marcdump on it, I got the same error. The imported file is here: https://www.dropbox.com/s/u25mf4dqk69wtgx/error.mrc The saved MARC BLOB

Re: [Koha] Koha Backup

At 09:17 PM 9/21/2013 -0700, chandru1782 wrote: Dear Paul, I have done the same thing earlier and what happened is the following. I lost data and settings in X and got all data and settings of Y. Your original request was: I want to restore the data from Y to X without any change to the data

Re: [Koha] Koha as a journal citation catalog

the same goals? [1] the only Windows boxes I have left are 98SE, which will not, unsurprisingly, accommodate MarcEdit. Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo

Re: [Koha] RDA questions WAS: Re: Flippin' Yanks

not broken is normally an expensive pipe-dream. Best - Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Zebra not indexing

103180 5284 ?SJan29 0:59 /usr/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml Also, FYI we're using Zebra 2.0.44 with ICU Good luck - Paul My install of Koha was from the tarball. For Zebra, I used the CentOS rpm's. This is all on RHEL6. Tomorrow I'll try

  1   2   3   4   5   >