- Koha - lists.katipo.co.nz

[first installation]Problem updating database..
by Thibaud Hulin 04 Jan '07

04 Jan '07

Hello and happy new year ! The help of Jogiraju has partially solve my problem with php5, but I can't always install koha. Now, I have his error after enter the root password : Creating the MySQL database for Koha... 0 Start tag expected, '<' not found at /usr/lib/perl5/XML/LibXML/SAX.pm line 64 at /usr/share/perl5/XML/Simple.pm line 287 BEGIN failed--compilation aborted at scripts/updater/updatedatabase line 21. Problem updating database.. Thanks for help, Thibaud. Jogiraju TALLAPRAG a écrit : > hi, > > 'return' is a reserved word in mysql5 which is not so for mysql5. You > have to edit the file koha.mysql file found in the koha installation > directory ( same directory where installer.pl file is found) and put > keyword return in backticks like this `return` and proceed with the > installation: > perl inataller.pl > It is always good to put all the fieldnames of the table definitions in > back ticks. > > Regards, > > > T. Jogi Raju > Librarian, Malla Reddy Engieering College, Hyderabad, India > > */Thibaud Hulin <hulin.thibaud(a)wanadoo.fr>/* wrote: > > Yes, I'm using mysql Ver 14.12 Distrib 5.0.30, for pc-linux-gnu (i486) > using readline 5.2 > Can I use mysql 4 and 5 ? Or must I uninstall mysql5 and install > mysql 4 ? > > Kochin Chang a écrit : > > Are you using MySQL 5.x? The current version of Koha is not > compatible > > with MySQL 5.x. > > > > Kochin > > > > Thibaud Hulin wrote: > >> Hi ! > >> I'm trying Koha on a Debian sarge testing, but I have an error after > >> launching install.pl and enter my sql password. This is the error > >> message : > >> CREATING DATABASE > >> > >> Creating the MySQL database for Koha... > >> 0 > >> ERROR 1064 (42000) at line 772: You have an error in your SQL > syntax; > >> check the manual that corresponds to your MySQL server version > for the > >> right syntax to use near 'return char(4) default NULL, > >> renewals tinyint(4) default NULL, > >> timestamp tim' at line 9 > >> > >> Start tag expected, '<' not found > >> at /usr/lib/perl5/XML/LibXML/SAX.pm line 64 > >> at /usr/share/perl5/XML/Simple.pm line 287 > >> BEGIN failed--compilation a > >> > >> I'm a beginner with sql. > >> > >> Thanks for help, > >> Thibaud. > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com >

1 0

rebuilding the MARC
by Keith LaBumbard 03 Jan '07

03 Jan '07

Hi, I'm having a problem when running the rebuildnonmarc.pl. The following is the text that appears when I run it. Can't locate C4/Context.pm in @INC (@INC contains: /usr/lib/perl5/5.8.3/i386-lin ux-thread-multi /usr/lib/perl5/5.8.3 /usr/lib/perl5/site_perl/5.8.3/i386-linux-t hread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl 5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-li nux-thread-multi /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 / usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site _perl /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/ve ndor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-li nux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/l ib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendo r_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at r ebuildnonmarc.pl line 10. BEGIN failed--compilation aborted at rebuildnonmarc.pl line 10. [root@localhost misc]# Can someone tell me what I can do to make this work please? Thanks Keith

2 1

Arabic Translation of Koha (again)
by Han, Yan 03 Jan '07

03 Jan '07

Hello, Mohammed posted a message in Aug 2006, but I did not find an answer. I would like to know anyone replied (or know) that if there is an Arabic interface (OPAC?) for Koha. Thanks, Yan Han >>>>>>>>>>>>>>>>>>>>>>>>> Mohammed Gamal f2c2001 at yahoo.com <mailto:koha%40lists.katipo.co.nz?Subject=%5BKoha%5D%20Arabic%20Translat ion%20of%20Koha&In-Reply-To=> Sun Aug 27 04:10:04 NZST 2006 Hello everyone, I've been recently working on translating Koha to Arabic, however I can across this article on Wikipedia (http://en.wikipedia.org/wiki/Koha_(software <http://en.wikipedia.org/wiki/Koha_%28software> ) ) that says that Koha was already translated to Arabic. I didn't see any arabic PO files in the main Koha distribution though. So I just want to know if Koha was translated to Arabic or not, and if it was translated then where is the Arabic PO file. Best Regards, Mohammed

2 1

defining the MARC tag structure
by Simon Joseph ENGITU 03 Jan '07

03 Jan '07

Koha Management; I am trying out Koha and at the stage of defining the MARC tag structure. However, iam a bit confused. Do I have to adopt the tag structure that I see already defined or I make my own. Do you have a manual that I can follow so as i can define my own structure. I have been using WINISIS, but when I got hold of KOHA, I felt it is quite useful and I want to try it out. I shall be grateful for your kind and quick response o this problem. Simon Joseph ENGITU Asstt Director; Library Services Sec. to Assoc. of Parliamentary Libs. in Eastern and Southern Africa (APLESA) Parliament of Uganda P.O. Box 7178 Kampala- Uganda EAST AFRICA Mobile 256 (772) 488937 Ph. 256 (41) 4377242 ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/

2 1

getting mysql...admin.exe to be found by the koha install
by Koha Lover 03 Jan '07

03 Jan '07

We have downloaded the following: apache_2.0.59-win32-x86-no_ssl.msi mysql-4.1.22-win32.zip ActivePerl-5.8.8.817-MSWin32-x86-257965.msi Perl5.8.xModulesForKohaR3.EXE Koha2.2.6-W32-R1.EXE Koha2.2.7-W32-R1.EXE We ran through the install (not installing the Perl5.8 package and installing Koha2.2.7 in preference to Koha 2.2.6), putting the files in the proper directories as far as we know. At the end of the install Koha gave a message that it could not find Mysql...admin.exe. Moreover, although the Apache icon (not a feather) was in the systray, we did not have the mysql icon in the systray at all. Please note that the www.koha.org page recommends an earlier version of Mysql (4.0.something), but we could not find this at the mysql site given. The closest we could find was mysql 4.1.22, avoiding as recommended mysql 5. Upon installation of mysql, we encountered screens that are not anticipated in the installation notes, particularly as concerns the configuration. There are three options, no configuration, typical configuration and full configuration. On the install we are describing we did the typical configuration. However, as pointed out above we didn't have any success with getting koha to work since it couldn't find mysql...admin.exe. We did execute 'mysql' under run, and we did get something, but we clearly are ignorant how to set up mysql to work with koha. In other respects the Koha install runs to completion. We tried a second installation telling mysql not to configure, running the separate Perl koha modules package and again installing Koha, but we got the same problem with mysql...admin.exe. Can someone coach us what to do? Koha Lover __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 2

Just to be clear...for indexing
by Lenora Oftedahl 02 Jan '07

02 Jan '07

I'm running Server information Koha version2.2.5 OS version ('uname -a')Linux maple 2.4.27-2-386 #1 Wed Aug 17 09:33:35 UTC 2005 i686 GNU/Linux Perl version5.008004 MySQL versionmysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386) Apache version However, my indexing seems to be lost as I can pull up lists of items with the Item Type or Branch search, but not any of the other searches. Do I still need the Zebra plug-in? My tech support is not clear on what needs to be done. ARGH! Just one more reason that I want the server in my office, not upstairs & inaccessible to me. -- *************************************** Lenora A. Oftedahl, MLS MEPM StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission 729 NE Oregon St, Ste 190 Portland, OR 97232 503-736-3581 / ARIEL: 207.173.155.8 503-731-1260 FAX OFTL(a)critfc.org http://www.fishlib.org ************************************* "One by one, the penguins are stealing my sanity" ************************************** "Don't worry about the world coming to an end today. It's already tomorrow in Australia." --(Charles Schultz) ************************************** "The problem with adults is that they are contaminated by experience." --Kumi Naidoo, General Secretary and CEO of CIVICUS **************************************

2 1

Fwd: Re: [Koha] getting mysql...admin.exe to be found by the koha install
by Koha Lover 02 Jan '07

02 Jan '07

Sorry! Newbies, wrong email address. --- Koha Lover <koha_lover(a)yahoo.com> wrote: > From Koha Lover Tue Jan 2 06:51:25 2007 > Received: from [195.167.121.13] by > web58903.mail.re1.yahoo.com via HTTP; Tue, 02 Jan > 2007 06:51:26 PST > Date: Tue, 2 Jan 2007 06:51:25 -0800 (PST) > From: Koha Lover <koha_lover(a)yahoo.com> > Subject: Fwd: Re: [Koha] getting mysql...admin.exe > to be found by the koha install > To: koha(a)katipo.co.nz > MIME-Version: 1.0 > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > Content-Length: 2227 > > For the list: > > Evidently we were not clear about what the problem > is. > We did the install as given below and as given in > the > koha directions. The problem is that we do not know > how to install mysql given that we have a slightly > different version before us with different screens > for > configuration from what the installation notes leads > us to expect. The result is that we get a message > from Koha on install that it can't find > mysql...admin.exe. The problem is not the > installation folder, which is correctly defined. > The > problem is elsewhere, but we do not know where. > Anyone know how to solve this problem? > > Thanks very much, > > Koha Lover > --- Koha Lover <koha_lover(a)yahoo.com> wrote: > > > From Koha Lover Tue Jan 2 06:46:12 2007 > > Received: from [195.167.121.13] by > > web58915.mail.re1.yahoo.com via HTTP; Tue, 02 Jan > > 2007 06:46:13 PST > > Date: Tue, 2 Jan 2007 06:46:12 -0800 (PST) > > From: Koha Lover <koha_lover(a)yahoo.com> > > Subject: Re: [Koha] getting mysql...admin.exe to > be > > found by the koha install > > To: arnab <arnabsadhukhan(a)kolkatacdac.in> > > In-Reply-To: <8123137.post(a)talk.nabble.com> > > MIME-Version: 1.0 > > Content-Type: text/plain; charset=iso-8859-1 > > Content-Transfer-Encoding: 8bit > > Content-Length: 1568 > > > > Dear Arnab: > > > > We did all of this. The problem is with the > > installation of mysql. For some reason with the > > 4.1.22 version of mysql, we are not able to > install > > it > > properly so that following the list of installs > that > > you give we end up in such a way that Koha can > find > > mysql...admin.exe. That is missing when we have > > finished. We don't know what to do. > > > > Koha Lover > > --- arnab <arnabsadhukhan(a)kolkatacdac.in> wrote: > > > > > > > > Hi, > > > > > > First of all install Apache server under > > "c:\program > > > files\". Apache server > > > will be installed under the name c:\program > > > files\Apache Group\Apache2 > > > > > > then install mysql under "c:\mysql" > > > then perl under "c:\usr" > > > > > > and lastly run "Koha2.2.7-W32-R1.EXE" > > > > > > Hope this will solve the problem. > > > > > > Arnab > > > > > > > > > > > > Koha Lover wrote: > > > > > > > > We have downloaded the following: > > > > > > > > apache_2.0.59-win32-x86-no_ssl.msi > > > > > > > > mysql-4.1.22-win32.zip > > > > > > > > ActivePerl-5.8.8.817-MSWin32-x86-257965.msi > > > > > > > > Perl5.8.xModulesForKohaR3.EXE > > > > > > > > Koha2.2.6-W32-R1.EXE > > > > > > > > Koha2.2.7-W32-R1.EXE > > > > > > > > We ran through the install (not installing the > > > Perl5.8 > > > > package and installing Koha2.2.7 in preference > > to > > > Koha > > > > 2.2.6), putting the files in the proper > > > directories as > > > > far as we know. > > > > > > > > At the end of the install Koha gave a message > > that > > > it > > > > could not find Mysql...admin.exe. Moreover, > > > although > > > > the Apache icon (not a feather) was in the > > > systray, we > > > > did not have the mysql icon in the systray at > > all. > > > > > > > > Please note that the www.koha.org page > > recommends > > > an > > > > earlier version of Mysql (4.0.something), but > we > > > could > > > > not find this at the mysql site given. The > > > closest we > > > > could find was mysql 4.1.22, avoiding as > > > recommended > > > > mysql 5. Upon installation of mysql, we > > > encountered > > > > screens that are not anticipated in the > > > installation > > > > notes, particularly as concerns the > > configuration. > > > > > > > There are three options, no configuration, > > typical > > > > configuration and full configuration. On the > > > install > > > > we are describing we did the typical > > > configuration. > > > > However, as pointed out above we didn't have > any > > > > success with getting koha to work since it > > > couldn't > > > > find mysql...admin.exe. We did execute > 'mysql' > > > under > > > > run, and we did get something, but we clearly > > are > > > > ignorant how to set up mysql to work with > koha. > > > > > > > > In other respects the Koha install runs to > > > completion. > > > > > > > > We tried a second installation telling mysql > not > > > to > > > > configure, running the separate Perl koha > > modules > > > > package and again installing Koha, but we got > > the > > > same > > > > problem with mysql...admin.exe. > > > > > > > > Can someone coach us what to do? > > > > > > > > Koha Lover > > > > > > > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Tired of spam? Yahoo! Mail has the best spam > > > protection around > > > > http://mail.yahoo.com > > > > > _______________________________________________ > > > > Koha mailing list > > > > Koha(a)lists.katipo.co.nz > > > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > > > > > -- > > > View this message in context: > > > > > > http://www.nabble.com/getting-mysql...admin.exe-to-be-found-by-the-koha-ins… > > > Sent from the Koha - Discuss mailing list > archive > > at > > > Nabble.com. > > > > > > _______________________________________________ > > > Koha mailing list > > > Koha(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > > protection around > > http://mail.yahoo.com > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

Fwd: Re: [Koha] getting mysql...admin.exe to be found by the koha install
by Koha Lover 02 Jan '07

02 Jan '07

For the list: Evidently we were not clear about what the problem is. We did the install as given below and as given in the koha directions. The problem is that we do not know how to install mysql given that we have a slightly different version before us with different screens for configuration from what the installation notes leads us to expect. The result is that we get a message from Koha on install that it can't find mysql...admin.exe. The problem is not the installation folder, which is correctly defined. The problem is elsewhere, but we do not know where. Anyone know how to solve this problem? Thanks very much, Koha Lover --- Koha Lover <koha_lover(a)yahoo.com> wrote: > From Koha Lover Tue Jan 2 06:46:12 2007 > Received: from [195.167.121.13] by > web58915.mail.re1.yahoo.com via HTTP; Tue, 02 Jan > 2007 06:46:13 PST > Date: Tue, 2 Jan 2007 06:46:12 -0800 (PST) > From: Koha Lover <koha_lover(a)yahoo.com> > Subject: Re: [Koha] getting mysql...admin.exe to be > found by the koha install > To: arnab <arnabsadhukhan(a)kolkatacdac.in> > In-Reply-To: <8123137.post(a)talk.nabble.com> > MIME-Version: 1.0 > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > Content-Length: 1568 > > Dear Arnab: > > We did all of this. The problem is with the > installation of mysql. For some reason with the > 4.1.22 version of mysql, we are not able to install > it > properly so that following the list of installs that > you give we end up in such a way that Koha can find > mysql...admin.exe. That is missing when we have > finished. We don't know what to do. > > Koha Lover > --- arnab <arnabsadhukhan(a)kolkatacdac.in> wrote: > > > > > Hi, > > > > First of all install Apache server under > "c:\program > > files\". Apache server > > will be installed under the name c:\program > > files\Apache Group\Apache2 > > > > then install mysql under "c:\mysql" > > then perl under "c:\usr" > > > > and lastly run "Koha2.2.7-W32-R1.EXE" > > > > Hope this will solve the problem. > > > > Arnab > > > > > > > > Koha Lover wrote: > > > > > > We have downloaded the following: > > > > > > apache_2.0.59-win32-x86-no_ssl.msi > > > > > > mysql-4.1.22-win32.zip > > > > > > ActivePerl-5.8.8.817-MSWin32-x86-257965.msi > > > > > > Perl5.8.xModulesForKohaR3.EXE > > > > > > Koha2.2.6-W32-R1.EXE > > > > > > Koha2.2.7-W32-R1.EXE > > > > > > We ran through the install (not installing the > > Perl5.8 > > > package and installing Koha2.2.7 in preference > to > > Koha > > > 2.2.6), putting the files in the proper > > directories as > > > far as we know. > > > > > > At the end of the install Koha gave a message > that > > it > > > could not find Mysql...admin.exe. Moreover, > > although > > > the Apache icon (not a feather) was in the > > systray, we > > > did not have the mysql icon in the systray at > all. > > > > > > Please note that the www.koha.org page > recommends > > an > > > earlier version of Mysql (4.0.something), but we > > could > > > not find this at the mysql site given. The > > closest we > > > could find was mysql 4.1.22, avoiding as > > recommended > > > mysql 5. Upon installation of mysql, we > > encountered > > > screens that are not anticipated in the > > installation > > > notes, particularly as concerns the > configuration. > > > > > There are three options, no configuration, > typical > > > configuration and full configuration. On the > > install > > > we are describing we did the typical > > configuration. > > > However, as pointed out above we didn't have any > > > success with getting koha to work since it > > couldn't > > > find mysql...admin.exe. We did execute 'mysql' > > under > > > run, and we did get something, but we clearly > are > > > ignorant how to set up mysql to work with koha. > > > > > > In other respects the Koha install runs to > > completion. > > > > > > We tried a second installation telling mysql not > > to > > > configure, running the separate Perl koha > modules > > > package and again installing Koha, but we got > the > > same > > > problem with mysql...admin.exe. > > > > > > Can someone coach us what to do? > > > > > > Koha Lover > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam > > protection around > > > http://mail.yahoo.com > > > _______________________________________________ > > > Koha mailing list > > > Koha(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > -- > > View this message in context: > > > http://www.nabble.com/getting-mysql...admin.exe-to-be-found-by-the-koha-ins… > > Sent from the Koha - Discuss mailing list archive > at > > Nabble.com. > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

koha.org Domain Renewal ?
by R Hariram Aatreya 29 Dec '06

29 Dec '06

hi All, When accessing http://koha.org/ a page is displayed which includes the message: koha.org expired on 12/23/2006 and is pending renewal or deletion. Anyone following it up ? hari.

4 3

Koha Users Around the World
by 毛慶禎 29 Dec '06

29 Dec '06

Hi, This wiki have been locked. I coul not edit it. http://wiki.koha.org/doku.php?id=kohausers Please add fellowing Koha users: Country = Taiwan Location = Taipei County Library Type = Elemmentary School Library Name = Bitou Elemmentary School Library, http://koha.pitoues.tpc.edu.tw Contact Name = Mr. Light Wind, lightwind02(a)hotmail.com Notes Country = Taiwan Location = Yilan County Library Type = Elemmentary School Library Name = Long Tang Elemmentary School Library, http://koha.ltes.ilc.edu.tw Contact Name = Mr. John Lin, *q38408(a)gmail.com* Notes Country = Taiwan Location = Nantou County Library Type = Elemmentary School Library Name = Nangan Elemmentary School Library, http://163.22.123.200 Contact Name = Notes Country = Taiwan Location = Nantou County Library Type = Elemmentary School Library Name = Gongsie Elemmentary School Library, http://koha.khps.ntct.edu.tw Contact Name Notes Country = Taiwan Location = Taipei County Library Type = Demo Site Library Name = Fu-Jen Catholic Library, http://lit145.lacc.fju.edu.tw/ Contact Name = Anthony Mao, mao(a)lins.fju.edu.tw Notes -- Best regards 毛慶禎, Anthony Mao, mao at mail. ntl dot edu.tw National Taiwan Library 85, Jhong-an St., Jhonghe City, Taipei County 235, Taiwan(R.O.C.) TEL +886 2 29266888 ext 3600 FAX +886 2 29268670

1 1