Re: [Koha] Issue with renewals
Chris You are an angel and I am an idiot (for not checking something so simple before sending out an e-mail!) Thank you! Regards Lisa Lisa Peel Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.p...@ritz.edu http://www.ritz.edu/ - http://www.culinaryarts.ch/ +++ 25 Years César Ritz Colleges Switzerland +++ From: Chris Cormack [ch...@bigballofwax.co.nz] Sent: 19 July 2011 10:35 To: Peel Lisa Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Issue with renewals 2011/7/19 Peel Lisa lisa.p...@ritz.edu: Hello We upgraded to 3.4 at the end of June. Yesterday I was doing some staff training and noticed that if I issue a book to a patron and on the same day renew it, the date keeps rolling forward instead of renewing to the same date. For example, I issued a 1 week loan to a patron yesterday, original due date 25th July. I renewed it yesterday the first time, instead of the due date remaining the 25th, it was now 1st August. Second time, 8th August. Third time 15th August. Is there anything in the circ rules (or anywhere else for that matter!) to stop this happening? If any of our students realise it will do this I can envisage them renewing their items several times immediately to get longer loans before other students can place holds. Hi Lisa Yes there is, in system preferences, you can choose whether a renewal acts on todays date, or on the due date. It sounds to me like you have it set to use the existing due date to calculate the new due date. Hope this helps Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Issue with renewals
On 19 July 2011 20:48, Peel Lisa lisa.p...@ritz.edu wrote: Chris You are an angel and I am an idiot (for not checking something so simple before sending out an e-mail!) Can I get you to write that for my next performance review at work? :) And don't feel bad, your question may well save someone else a bunch of time at some later date. The only silly question is the one never asked :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Installation problem
Hi Abdulltef, On 19 July 2011 17:20, abdulllatef ibnsaad...@gmail.com wrote: # mysqladmin -uroot -ppassword create kohadata it stated here: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' Do you know the mysql root password? Try this: #mysql mysql You may be asked for a password. It is the root mysql password. If you can get in, then $quit; and retry the failing command, but replace password with the password you just used. If you were not asked for a password, but went straight to a mysql prompt, then $quit; and retry the failing command omitting -p password If you don't know the mysql root password, then I'm afraid I don't know how to overcome that problem cheers nigel ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to extract tag 050 data only in marcxml field from biblioitems table
If you have the right version of MySQL you can use the MarcExtract in your query to grab the 050 - some tips here: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC Nicole On Tue, Jul 19, 2011 at 10:22 AM, Yohannes Mulugeta yohannesm...@gmail.com wrote: Dear folks, I'm using Koha ver 3.2. I want to extract the Title, Author, itemcallnumber, (LC call no.), barcode, holdingbranch directly from mySQL tables. But the itemcallnumber field is empty. The call number is available in the marcxml and marc field in biblioitems table. After migrating the bibliographic records from verion 2.4 to the Koha 2.9 and then Koha 3.2, the classification field which we used to store our call number is not available in the current biblioitems table. So, is there a way to select the call number data (tag 050) only from marcxml or marc field in the biblioitem table. Becuase most of our call number were stored in the older version of Koha, classification.biblioitems, are not available in Koha version 3.2. As a result the itemcallnumber field is almost empty. Any help please. Yohannes Mulugeta Addis Ababa University Libraries ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] es.koha-community.org available
Dear Koha Community We are pleased to announce the availability of the spanish-speaking community's Koha portal. You will find in it the translated official announcements and several resources and news related to the spanish-speaking Koha community. We hope to get your feedback and suport to make this site full of relevant information for the community. The address: http://es.koha-community.org Martín Longo Miguel Angel Calvo Tomás Cohen Arazi Bernardo González Kriegel Alejandro Tiraboschi = Estimada comunidad de Koha. Estamos orgullosos de anunciar la puesta en linea del nuevo portal de la comunidad hispanohablante de Koha. En él podrán encontrar los anuncios oficiales en español, como así también como recursos y noticias vinculadas con la comunidad hispanohablante de Koha. Esperamos sus comentarios y aportes para hacer de este un portal útil y rico en información para la comunidad. Para acceder, dirigirse a: http://es.koha-community.org Martín Longo Miguel Angel Calvo Tomás Cohen Arazi Bernardo González Kriegel Alejandro Tiraboschi ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha and Computer Management Systems
Userful (userful.com) also works with koha using the SIP interface. If you have any specific questions let me know. Kyle was working on a completely new version of libki, but I haven't checked on the status of that project recently. --- On 07/19/2011 08:39 AM, Melissa Parker wrote: Good Morning All, My system is looking into computer management systems for our library. We need one that interfaces with KOHA. Currently we have been looking at cybrarian and libki, but are there any others that you recommend that are work well AND interfaces with KOHA? Thanks for your help in this search Melissa Parker SEKLS ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Greg Lawson Rolling Hills Consolidated Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha and Computer Management Systems
PC Reservation interfaces with Koha. I would definitely look at that. Lori =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant The Galecia Group // www.galecia.com (707) 763-6869 // lori.a...@galecia.com lori.a...@galecia.comSpecializing in open source ILS solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 2011/7/19 Melissa Parker mpar...@sekls.org Good Morning All, My system is looking into computer management systems for our library. We need one that interfaces with KOHA. Currently we have been looking at cybrarian and libki, but are there any others that you recommend that are work well AND interfaces with KOHA? Thanks for your help in this search Melissa Parker SEKLS ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha and Computer Management Systems
Melissa, For clarity...Envisionware makes PC Reservation. They aren't two different products. ;) =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant The Galecia Group // www.galecia.com (707) 763-6869 // lori.a...@galecia.com lori.a...@galecia.comSpecializing in open source ILS solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 2011/7/19 James Ghiorzi jghio...@lib.co.san-benito.ca.us EnvisionWare and Cassie will work with the SIP interface as well. With Cassie you can opt to have a separate server for wireless connections which is called - Spot, both have a printing management option as well. Cassie will require self install, EnvisionWare can install for you or you can self install. Hope that helps :) Respectfully, James Ghiorzi Library Assistant II San Benito County Free Library 470 Fifth St. Hollister, CA 95023 (831) 636-4107 -- *From:* koha-boun...@lists.katipo.co.nz [koha-boun...@lists.katipo.co.nz] On Behalf Of G. Laws [glaw...@rhcl.org] *Sent:* Tuesday, July 19, 2011 8:02 AM *To:* koha@lists.katipo.co.nz *Subject:* Re: [Koha] Koha and Computer Management Systems Userful (userful.com) also works with koha using the SIP interface. If you have any specific questions let me know. Kyle was working on a completely new version of libki, but I haven't checked on the status of that project recently. --- On 07/19/2011 08:39 AM, Melissa Parker wrote: Good Morning All, My system is looking into computer management systems for our library. We need one that interfaces with KOHA. Currently we have been looking at cybrarian and libki, but are there any others that you recommend that are work well AND interfaces with KOHA? Thanks for your help in this search Melissa Parker SEKLS ___ Koha mailing list http://koha-community.orgk...@lists.katipo.co.nzhttp://lists.katipo.co.nz/mailman/listinfo/koha -- Greg Lawson Rolling Hills Consolidated Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha and Computer Management Systems
Sorry about that, I had sent my message after I saw yours go through :). If you go with PC Reservation, start off with the older version to see how you like the interface, the newest version has a great interface but has little quirks here and there. Respectfully, James Ghiorzi Library Assistant II San Benito County Free Library 470 Fifth St. Hollister, CA 95023 (831) 636-4107 From: loria...@gmail.com [loria...@gmail.com] On Behalf Of Lori Bowen Ayre [lori.a...@galecia.com] Sent: Tuesday, July 19, 2011 11:24 AM To: James Ghiorzi Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha and Computer Management Systems Melissa, For clarity...Envisionware makes PC Reservation. They aren't two different products. ;) =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant The Galecia Group // www.galecia.comhttp://www.galecia.com/ (707) 763-6869 // lori.a...@galecia.commailto:lori.a...@galecia.com mailto:lori.a...@galecia.comSpecializing in open source ILS solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 2011/7/19 James Ghiorzi jghio...@lib.co.san-benito.ca.usmailto:jghio...@lib.co.san-benito.ca.us EnvisionWare and Cassie will work with the SIP interface as well. With Cassie you can opt to have a separate server for wireless connections which is called - Spot, both have a printing management option as well. Cassie will require self install, EnvisionWare can install for you or you can self install. Hope that helps :) Respectfully, James Ghiorzi Library Assistant II San Benito County Free Library 470 Fifth St. Hollister, CA 95023 (831) 636-4107tel:%28831%29%20636-4107 From: koha-boun...@lists.katipo.co.nzmailto:koha-boun...@lists.katipo.co.nz [koha-boun...@lists.katipo.co.nzmailto:koha-boun...@lists.katipo.co.nz] On Behalf Of G. Laws [glaw...@rhcl.orgmailto:glaw...@rhcl.org] Sent: Tuesday, July 19, 2011 8:02 AM To: koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: Re: [Koha] Koha and Computer Management Systems Userful (userful.comhttp://userful.com) also works with koha using the SIP interface. If you have any specific questions let me know. Kyle was working on a completely new version of libki, but I haven't checked on the status of that project recently. --- On 07/19/2011 08:39 AM, Melissa Parker wrote: Good Morning All, My system is looking into computer management systems for our library. We need one that interfaces with KOHA. Currently we have been looking at cybrarian and libki, but are there any others that you recommend that are work well AND interfaces with KOHA? Thanks for your help in this search Melissa Parker SEKLS ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Greg Lawson Rolling Hills Consolidated Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Searching problem after import marc
I m using Koha 3.4.2 version at ubuntu 10.04. i hve imported data from a csv file by converting records into marc using marcedit. After import complete (1340 biblios). I rebuild zebra with the following command: ./rebuild_zebra.pl -b -a -r -v I got the following output: 22:24:39-19/07 zebraidx(5448) [log] add grs.marcxml.record /tmp/HkeqHyxF2u/biblio/exported_records 1389993 22:24:39-19/07 zebraidx(5448) [log] add grs.marcxml.record /tmp/HkeqHyxF2u/biblio/exported_records 1391237 22:24:39-19/07 zebraidx(5448) [log] add grs.marcxml.record /tmp/HkeqHyxF2u/biblio/exported_records 1392183 22:24:39-19/07 zebraidx(5448) [log] add grs.marcxml.record /tmp/HkeqHyxF2u/biblio/exported_records 1393781 22:24:39-19/07 zebraidx(5448) [log] Records: 1000 i/u/d 1000/0/0 22:24:39-19/07 zebraidx(5448) [log] More than 1000 file log entries. Omitting rest *** stack smashing detected ***: zebraidx terminated === Backtrace: = /lib/tls/i686/cmov/libc.so.6(__fortify_fail+0x50)[0x536390] /lib/tls/i686/cmov/libc.so.6(+0xe233a)[0x53633a] /usr/lib/libidzebra-2.0.so.0(+0x71fd4)[0xceafd4] /usr/lib/libidzebra-2.0.so.0(+0x17b45)[0xc90b45] [0x0] === Memory map: 0011-001cd000 r-xp 08:06 1098635/usr/lib/libyaz.so.3.0.0 001cd000-001ce000 r--p 000bd000 08:06 1098635/usr/lib/libyaz.so.3.0.0 001ce000-0026f000 rw-p 000be000 08:06 1098635/usr/lib/libyaz.so.3.0.0 0026f000-00276000 r-xp 08:06 588872 /lib/libwrap.so.0.7.6 00276000-00277000 r--p 6000 08:06 588872 /lib/libwrap.so.0.7.6 00277000-00278000 rw-p 7000 08:06 588872 /lib/libwrap.so.0.7.6 00278000-00295000 r-xp 08:06 588757 /lib/libgcc_s.so.1 00295000-00296000 r--p 0001c000 08:06 588757 /lib/libgcc_s.so.1 00296000-00297000 rw-p 0001d000 08:06 588757 /lib/libgcc_s.so.1 00297000-0029a000 r-xp 08:06 588769 /lib/libgpg-error.so.0.4.0 0029a000-0029b000 r--p 2000 08:06 588769 /lib/libgpg-error.so.0.4.0 0029b000-0029c000 rw-p 3000 08:06 588769 /lib/libgpg-error.so.0.4.0 0029c000-0029d000 r-xp 08:06 1138335 /usr/lib/idzebra-2.0/modules/mod-text.so 0029d000-0029e000 r--p 1000 08:06 1138335 /usr/lib/idzebra-2.0/modules/mod-text.so 0029e000-0029f000 rw-p 2000 08:06 1138335 /usr/lib/idzebra-2.0/modules/mod-text.so 0029f000-002a2000 r-xp 08:06 1138334 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 002a2000-002a3000 r--p 2000 08:06 1138334 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 002a3000-002a4000 rw-p 3000 08:06 1138334 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 002a4000-002a8000 r-xp 08:06 1138332 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 002a8000-002a9000 r--p 4000 08:06 1138332 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 002a9000-002aa000 rw-p 5000 08:06 1138332 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 002aa000-002ad000 r-xp 08:06 1138330 /usr/lib/idzebra-2.0/modules/mod-alvis.so 002ad000-002ae000 r--p 2000 08:06 1138330 /usr/lib/idzebra-2.0/modules/mod-alvis.so 002ae000-002af000 rw-p 3000 08:06 1138330 /usr/lib/idzebra-2.0/modules/mod-alvis.so 002b4000-002b5000 r-xp 00:00 0 [vdso] 002b5000-003d9000 r-xp 08:06 1098626/usr/lib/libxml2.so.2.7.6 003d9000-003da000 ---p 00124000 08:06 1098626/usr/lib/libxml2.so.2.7.6 003da000-003de000 r--p 00124000 08:06 1098626/usr/lib/libxml2.so.2.7.6 003de000-003df000 rw-p 00128000 08:06 1098626/usr/lib/libxml2.so.2.7.6 003df000-003e rw-p 00:00 0 003e-0045 r-xp 08:06 588762 /lib/libgcrypt.so.11.5.2 0045-00451000 r--p 0007 08:06 588762 /lib/libgcrypt.so.11.5.2 00451000-00453000 rw-p 00071000 08:06 588762 /lib/libgcrypt.so.11.5.2 00454000-005a7000 r-xp 08:06 613951 /lib/tls/i686/cmov/ libc-2.11.1.so 005a7000-005a8000 ---p 00153000 08:06 613951 /lib/tls/i686/cmov/ libc-2.11.1.so 005a8000-005aa000 r--p 00153000 08:06 613951 /lib/tls/i686/cmov/ libc-2.11.1.so 005aa000-005ab000 rw-p 00155000 08:06 613951 /lib/tls/i686/cmov/ libc-2.11.1.so 005ab000-005ae000 rw-p 00:00 0 005ae000-005d2000 r-xp 08:06 588750 /lib/libexpat.so.1.5.2 005d2000-005d4000 r--p 00024000 08:06 588750 /lib/libexpat.so.1.5.2 005d4000-005d5000 rw-p 00026000 08:06 588750 /lib/libexpat.so.1.5.2 005d5000-005da000 r-xp 08:06 1138331 /usr/lib/idzebra-2.0/modules/mod-dom.so 005da000-005db000 r--p 4000 08:06 1138331 /usr/lib/idzebra-2.0/modules/mod-dom.so 005db000-005dc000 rw-p 5000 08:06 1138331 /usr/lib/idzebra-2.0/modules/mod-dom.so 005dc000-005e2000 r-xp 08:06 1138333 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 005e2000-005e3000 r--p 5000 08:06 1138333 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 005e3000-005e4000 rw-p 6000 08:06 1138333 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 005ef000-005f8000 r-xp 08:06 613955 /lib/tls/i686/cmov/ libcrypt-2.11.1.so 005f8000-005f9000 r--p 8000 08:06 613955
[Koha] Need with suppression report
I am trying to do a report of all items in a certain
location that is NOT suppressed.
I went to the SQL report library and found the report by Chris Hobbs
called Bibs Suppressed in OPAC. I figure if I can get
that to work I can probably tweak it for the
rest.However, I can't get this report to run, as is.
I've tried some minor changes, but I keep getting an error message that
says
The following error was encountered:
The database returned the following error:
1
Please check the log for further details.
I don't have access to the log, as far as I know.
Here is the report, please let me know if there is something wrong with
it. We are now using Community Koha.
SELECT concat( 'a
href=""
biblio.biblionumber, '', biblio.title, '/a' ) AS title,
biblio.author
FROM biblioitems
JOIN biblio ON ( biblioitems.biblionumber = biblio.biblionumber )
WHERE ExtractValue( marcxml,
'//datafield[@tag=942]/subfield[@code=n]' )
IN ('Y', '1')
Kathy
Kathleen D. Rippel
Dept. Head/Consultant--Resource Access and Sharing
Central Kansas Library System
1409 Williams
Great Bend, KS 67530
(620-792-4865) phone
(800-362-2642) toll-free, KS
(620-792-5495) fax
k...@ckls.org
I'm currently reading: The game of
kings, by Dorothy Dunnett.
I'm currently listening to: The astonishing life of Octavian Nothing.
Vol. 2, The kingdom on the waves, by M. T. Anderson.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need with suppression report
Thanks all, we'll check with Bywater, I guess. I don't know
what mysql version they have us on.
Kathy
At 06:01 PM 7/19/2011, Chris Cormack wrote:
2011/7/20 Kathy Rippel
k...@ckls.org:
I am trying to do a report of all items in a certain location that
is NOT
suppressed.
I went to the SQL report library and found the report by Chris Hobbs
called
Bibs Suppressed in OPAC. I figure if I can get that to work I can
probably
tweak it for the rest.
However, I can't get this report to run, as is. I've tried some
minor
changes, but I keep getting an error message that says
The following error was encountered:
The database returned the following error:
1
Please check the log for further details.
I don't have access to the log, as far as I know.
Here is the report, please let me know if there is something wrong
with it.
We are now using Community Koha.
 SELECT concat( 'a
href="">
biblio.biblionumber, '', biblio.title, '/a' ) AS
title,
biblio.author
 FROM biblioitems
 JOIN biblio ON ( biblioitems.biblionumber =
biblio.biblionumber )
 WHERE ExtractValue( marcxml,
'//datafield[@tag=942]/subfield[@code=n]'
)
 IN ('Y', '1')
Hi Kathy
That seems to work fine for me, one possibility is that the mysql
server is not new enough to support ExtractValue, you would need to
get your support company to check this out for you though.
Since you are running official Koha, I'm sure they will be able to
do
this for you nice and fast ;)
Chris
Kathleen D. Rippel
Dept. Head/Consultant--Resource Access and Sharing
Central Kansas Library System
1409 Williams
Great Bend, KS 67530
(620-792-4865) phone
(800-362-2642) toll-free, KS
(620-792-5495) fax
k...@ckls.org
I'm currently reading: The game of
kings, by Dorothy Dunnett.
I'm currently listening to: The astonishing life of Octavian Nothing.
Vol. 2, The kingdom on the waves, by M. T. Anderson.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need with suppression report
Hi Kathy -
I just checked and this report should run perfectly... Actually I just tested
it on your system.
When you see an error like that - usually that means there was a space in-front
of the 'SELECT'. That will throw that error.
I've added it to your system it's report id #1085.
-Brendan
On Jul 19, 2011, at 2:04 PM, Kathy Rippel wrote:
I am trying to do a report of all items in a certain location that is NOT
suppressed.
I went to the SQL report library and found the report by Chris Hobbs called
Bibs Suppressed in OPAC. I figure if I can get that to work I can probably
tweak it for the rest.
However, I can't get this report to run, as is. I've tried some minor
changes, but I keep getting an error message that says
The following error was encountered:
The database returned the following error:
1
Please check the log for further details.
I don't have access to the log, as far as I know.
Here is the report, please let me know if there is something wrong with it.
We are now using Community Koha.
SELECT concat( 'a
href=/cgi-bin/koha/catalogue/detail.pl?biblionumber=',
biblio.biblionumber, '', biblio.title, '/a' ) AS title,
biblio.author
FROM biblioitems
JOIN biblio ON ( biblioitems.biblionumber = biblio.biblionumber )
WHERE ExtractValue( marcxml,
'//datafield[@tag=942]/subfield[@code=n]' )
IN ('Y', '1')
Kathy
Kathleen D. Rippel
Dept. Head/Consultant--Resource Access and Sharing
Central Kansas Library System
1409 Williams
Great Bend, KS 67530
(620-792-4865) phone
(800-362-2642) toll-free, KS
(620-792-5495) fax
k...@ckls.org
I'm currently reading: The game of kings, by Dorothy Dunnett.
I'm currently listening to: The astonishing life of Octavian Nothing. Vol. 2,
The kingdom on the waves, by M. T. Anderson.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Installation problem
abdulllatef ibnsaad...@gmail.com writes: # mysqladmin -uroot -ppassword create kohadata it stated here: . The root in -uroot means the root user on mysql; not the system root user. password in -ppassword is the password for the mysql root user on mysql. root is obviously unchanged; what changes is the password. The password would be set up at install time. On debian, the installer asks to set up the root user's password while installing the mysql-server package. This may be different for other distros / OSes. You are expected to use that password here. -- Mahesh T. Pai || DICTIONARY, n. A malevolent literary device for cramping the growth of a language and making it hard and inelastic. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
