Re: [Koha] Installation problem

Hi guys! I'm Abdullatef. I'm installing KOHA 3.4.02 following the same instruction on the wiki and I'm stuck at: 7 - Create MySQL Database and grant all privileges to the koha database to the specified user # mysqladmin -uroot -ppassword create kohadata it stated here:

[Koha] Issue with renewals

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, ori

Re: [Koha] Issue with renewals

2011/7/19 Peel Lisa : > 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 l

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 htt

Re: [Koha] Issue with renewals

On 19 July 2011 20:48, Peel Lisa 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 b

Re: [Koha] Installation problem

Hi Abdulltef, On 19 July 2011 17:20, abdulllatef 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

Re: [Koha] Installation problem

Hi Nigel! Thanks for your guide. Actually, before you reply, I asked a friend of mine on whether the MySQL is ready or not. He give me this command: #myslqd and I got this: 110719 15:41:36 [Warning] Can't create test file /var/lib/mysql/abdullatef-VirtualBox.lower-test 110719 15:41:36 [Warning

Re: [Koha] Installation problem

I tried #mysql mysql I got this: abdullatef@abdullatef-VirtualBox:~/koha-latest/koha-3.4.02$ mysql mysql ERROR 1045 (28000): Access denied for user 'abdullatef'@'localhost' (using password: NO) -- View this message in context: http://koha.1045719.n5.nabble.com/Installation-problem-tp4449146p

Re: [Koha] Installation problem

On 19 July 2011 18:27, abdulllatef wrote: > I tried > #mysql mysql > > I got this: > > abdullatef@abdullatef-VirtualBox:~/koha-latest/koha-3.4.02$ mysql mysql > ERROR 1045 (28000): Access denied for user 'abdullatef'@'localhost' (using > password: NO) > this means mysql is running, to answer your

Re: [Koha] Found field in reserves table

Thank you very much. Nicole On Tue, Jul 19, 2011 at 8:55 AM, Zeno Tajoli wrote: > Hi Nicole, > > Il 16/07/2011 16:04, Nicole Engard ha scritto: >> I'm wondering what codes may appear in the 'found' field in the reserves >> table and what they each mean? >> >> I have these FAQs in the manual for

Re: [Koha] Found field in reserves table

Hi Nicole, Il 16/07/2011 16:04, Nicole Engard ha scritto: > I'm wondering what codes may appear in the 'found' field in the reserves > table and what they each mean? > > I have these FAQs in the manual for other tables: > and > want to add one for the reserves table. do you speak about the table

[Koha] Koha - order of subject fields

Has anyone found an easy way to change the order of subject fields? In other words, if you have multiple 6XX fields and want to change their order in which they appear - according to importance. Is there a way in Koha to do that? Thanks. -- Linda Culberson lcul...@mdah.state.ms.us Archi

Re: [Koha] Koha - order of subject fields

And -- while I sure hope someone has a positive answer for this because even when I import records from OCLC, after carefully ordering 6XX fields, our Koha sorts them around into numerical order -- I'd like to be able to sort some 5XX notes fields rather than having them automatically sort thems

[Koha] Koha and Computer Management Systems

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

[Koha] Searches problems (acqdate and callnumber)

Hi there. I'm using Koha 3.2.6 with UNIMARC and i'm facing two problems with Koha searches. First i'm having a problem with acquisition date search. For example if i search for "2011-06-30" are returned the record that have items with that acquisition date bu also records that items are loaned or

[Koha] How to extract tag 050 data only in marcxml field from biblioitems table

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 bi

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 wrote: > Dear folks, > > I'm using Koha ver 3.2. I want

[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

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

Re: [Koha] Koha - order of subject fields

Linda Culberson wrote: > Has anyone found an easy way to change the order of subject fields? In > other words, if you have multiple 6XX fields and want to change their > order in which they appear - according to importance. Is there a way > in Koha to do that? Wouldn't switching OPAC Display

Re: [Koha] Koha and Computer Management Systems

One of our partner libraries uses Powerline ( http://code.google.com/p/powerline/), but they may have some custom connectors written to get the data to sync with Koha (they're self-hosted, and have customized their systems a fair bit). But, another possibility to consider! -Ian 2011/7/19 G. Law

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 Specializing in open source ILS soluti

Re: [Koha] Koha and Computer Management Systems

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 sel

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 Specializing in

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 Assist

[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 zebraid

Re: [Koha] Ldap + Active Directory

Greetings, With the help of sekjal in IRC I've been directed to the bottom portion of the "Auth_with_ldap.pm" file where the required mapping fields are listed. It says I can find them by checking the "borrowers" table, so I did this: # mysql -e "use koha; show COLUMNS from borrowers;" | grep N

[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 ru

Re: [Koha] Need with suppression report

2011/7/20 Kathy Rippel : > 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.

Re: [Koha] Searching problem after import marc

Abdul Vali schreef op wo 20-07-2011 om 00:39 [+0500]: > 22:24:39-19/07 zebraidx(5448) [log] More than 1000 file log entries. > Omitting rest > *** stack smashing detected ***: zebraidx terminated You're hitting a bug in zebra. Make sure that you're using the current version, use the indexdata rep

Re: [Koha] Need with suppression report

Do you know which version of mysql you are using? ExtractValue requires a minimum of mysql 5.1.5 to be used. I wonder if this is what is causing the error? Chris -- Chris Hobbs Director, Technology New Haven Unified School District 2011/7/19 Kathy Rippel > I am trying to do a report of all

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 : > 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

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. -Brenda

Re: [Koha] Need with suppression report

Brendan A. Gallagher schreef op di 19-07-2011 om 17:23 [-0700]: > When you see an error like that - usually that means there was a space > in-front of the 'SELECT'. That will throw that error. That sounds like a very easy bug to fix in Koha proper :) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803

Re: [Koha] Need with suppression report

2011/7/20 Robin Sheat : > Brendan A. Gallagher schreef op di 19-07-2011 om 17:23 [-0700]: >> When you see an error like that - usually that means there was a space >> in-front of the 'SELECT'.  That will throw that error. > > That sounds like a very easy bug to fix in Koha proper :) > That sounds l

Re: [Koha] Installation problem

abdulllatef 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;