- Koha - lists.katipo.co.nz

ERROR 500
by stuart.mvula＠sjog.mw 19 Aug '09

19 Aug '09

2 1

re missing fields in koha
by Carmel Young 18 Aug '09

18 Aug '09

Using koha 3.00.01 on debian lenny. After installing, there are some fields that are 'greyed out' and therefore do not allow the input of data. 100a field 440a field 600a, 610a, etc i.e. all 'a' fields in the 600s, and all 'a' fields in the 700s and 800s. Thanks in advance for any suggestions, Carmel Young Malawi

3 2

Due date "YYYY-MM-DD" is invalid error when checking out books
by Suchetha Wijenayake 18 Aug '09

18 Aug '09

I am still setting up the library system, and now that they finally feel ready to start lending books, I find that I get the error in the subject whenever they try to lend a book. Red faces doth abound. I've tried setting the dates. I've even reset the dates. where am I screwing up? All the best Suchetha -- Check my photo album: http://picasaweb.google.com/suchetha Rants Raves and Miscellaneous Musings: http://raramimu.blogspot.com Why do I smell brimstone? And what am I doing in this hand-basket?

3 5

Monthly ILL report
by Scott Zollars 18 Aug '09

18 Aug '09

Thanks to whoever devised the SQL for my report request. I need to tweak it a little though. This is the current SQL Scotty Zollars Circulation List interlibrary loan materials check out to other libraries, by month SELECT monthname(datesent) month,COUNT(*) FROM branchtransfers where frombranch="MMM" and YEAR(datesent)=YEAR(NOW())-1 GROUP BY month ORDER by month(datesent) We are just one branch . We treat our ILL customers like community patrons and that is our patron type for them. We put ILL as the surname for all of our ILL patrons, for example, Surname: ILL, First Name: Erie Public Library. How should I adapt this to take this into account and to also show the titles. Sorry to be a pain, Scotty Zollars Director of Library Services Labette Community College 200 S. 14th Parsons, KS 67357 620-820-1168 620-421-1469 FAX Four things you can't recover: The stone after the throw, the word after it's said, the occasion after it's missed and the time after it's gone.

1 0

Problems with rebuild_zebra.pl -z
by Stefano Bargioni 18 Aug '09

18 Aug '09

Hi, in my Koha 3.00.3 (a new Debian-Lenny testing installation), everytime I modify or delete a record, the zebraqueue table registers the changes with the "done" field=1. The update of Zebra will be unuseful, since rebuild_zebra.pl -z can't select records. Is there something wrong in my Zebra config? Or this is a bug? Thanks. Stefano

2 2

Re: [Koha] MySQL Problem
by Erik Lewis 18 Aug '09

18 Aug '09

Okay I'm officially spooked. It's back after restarting mysql again but this is worrisome. On Aug 18, 2009, at 9:15 AM, Erik Lewis wrote: > Okay, plowing around with the MySql gui. Getting a bunch of > "incorrect information in file" on every file > > > On Aug 18, 2009, at 9:05 AM, Erik Lewis wrote: > >> Did the latest updates to my Ubuntu 9.04 machine and restarted. >> >> Went to my Koha Opac and got the maintenance page >> >> That was odd so I checked and MySQL wasn't running. >> >> Went to start it manually >> >> sudo mysql start >> >> and got this: >> >> ERROR 2002 (HY000): Can't connect to local MySQL server through >> socket >> '/var/run/mysqld/mysqld.sock' (2) >> >> hmmm... >> Thought about it for a moment and decided that maybe I should try >> mysqld >> >> That worked but I got this >> >> 090818 8:41:40 [ERROR] mysqld: Incorrect information in file: './ >> koha/ >> systempreferences.frm' >> >> Now, here are the last things I did that would have effected mysql. >> >> Yesterday I was playing with adding Owen's tables for the new items >> php. I have also been playing with the CSS for the Opac, header, >> credits, navigation, etc.. as I work on trying to merge the library >> webpage with the Opac. >> >> Any thoughts? Do I just need to restore my koha database? >> >> _______________________________________________ >> Koha mailing list >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] MySQL Problem
by MJ Ray 18 Aug '09

18 Aug '09

Erik Lewis <elewis(a)ngrl.org> [...] > sudo mysql start > and got this: > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) > > hmmm... > Thought about it for a moment and decided that maybe I should try mysqld > > That worked but [...] Any thoughts? I think running mysqld directly won't start the server with the same parameters as the script /etc/init.d/mysqld does, so it might not find your databases and settings. Try using the init script and if it fails to start with some error message, check the /var/log files for a fuller description of the problem. This is more of a general sysadmin or ubuntu question than a Koha problem, so you might find a local sysadmin or LUG who could explain it more fully. Hope that helps, -- MJ Ray (slef) LMS developer and webmaster at | software www.software.coop http://mjr.towers.org.uk | .... co IMO only: see http://mjr.towers.org.uk/email.html | .... op

1 0

MySQL Problem
by Erik Lewis 18 Aug '09

18 Aug '09

Did the latest updates to my Ubuntu 9.04 machine and restarted. Went to my Koha Opac and got the maintenance page That was odd so I checked and MySQL wasn't running. Went to start it manually sudo mysql start and got this: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) hmmm... Thought about it for a moment and decided that maybe I should try mysqld That worked but I got this 090818 8:41:40 [ERROR] mysqld: Incorrect information in file: './koha/ systempreferences.frm' Now, here are the last things I did that would have effected mysql. Yesterday I was playing with adding Owen's tables for the new items php. I have also been playing with the CSS for the Opac, header, credits, navigation, etc.. as I work on trying to merge the library webpage with the Opac. Any thoughts? Do I just need to restore my koha database?

1 0

Invalid Login on SIP2 Server... why?
by Luigi Ipsa 18 Aug '09

18 Aug '09

Hi, now i have corrected start SIP2Server but when i try to login, server reply me invalid login: telnet localhost 8023 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. login: sipterm1 password: term1 Invalid login login: password: Invalid login login: password: Invalid login Login OK. Initiating SIP 9300CNsipterm1|COterm1|CPMAIN 940 Connection closed by foreign host. but my SIPServer.xml is the same to this on: https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/A… https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/A… What is the possible problem? Thanks -- View this message in context: http://www.nabble.com/Invalid-Login-on-SIP2-Server...-why--tp21951242p21951… Sent from the Koha - Discuss mailing list archive at Nabble.com.

6 9

110 (corporate author) doesn't show on OPAC normal view
by PasiK 17 Aug '09

17 Aug '09

How can I make the field 110a show as author in OPAC "normal view" in Koha3? -- View this message in context: http://www.nabble.com/110-%28corporate-author%29-doesn%27t-show-on-OPAC-nor… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0