- Koha-devel - lists.koha-community.org

New Mac OS X installation guide
by Dorian Meid 05 Mar '07

05 Mar '07

Hello, I posted a new installation guide for Koha on Mac OS X to the wiki. If someone wants to take the action and put it on kohadocs, please feel free. Dorian Meid

1 0

2.2.7-installer problems
by Dorian Meid 03 Mar '07

03 Mar '07

I just downloaded 2.2.7 from the website and tried to install on OSX. First the INSTALL-File is outdated, it requires the wrong modules. Then after having finished the installation of all the modules I ran the installer and came across this errors: In the routine for missing Perl-modules the warnings are correct up to the PDF-stuff, but then I get warnings, which I can understand, but the suggestions are wrong. Creating the MySQL database for Koha... 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 DBD::mysql::db do failed: Table 'koha.categoryitem' doesn't exist at scripts/updater/updatedatabase line 1600. DBD::mysql::db do failed: Table 'koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1601. DBD::mysql::db do failed: Table 'koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1602. DBD::mysql::db do failed: Table 'koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1603. DBD::mysql::st execute failed: Table 'koha.statistics' doesn't exist at scripts/updater/updatedatabase line 1615. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1617. DBD::mysql::st execute failed: Table 'koha.statistics' doesn't exist at scripts/updater/updatedatabase line 1632. **Error : DBI::st=HASH(0x18de730)->errstr DBD::mysql::st execute failed: Table 'koha.itemtypes' doesn't exist at scripts/updater/updatedatabase line 1615. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1617. DBD::mysql::st execute failed: Table 'koha.itemtypes' doesn't exist at scripts/updater/updatedatabase line 1632. **Error : DBI::st=HASH(0x17408)->errstr DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 1615. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1617. DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 1632. **Error : DBI::st=HASH(0x172b8)->errstr DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 1632. **Error : DBI::st=HASH(0x173a8)->errstr DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 1632. **Error : DBI::st=HASH(0x1724c)->errstr DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at scripts/updater/updatedatabase line 1615. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1617. DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at scripts/updater/updatedatabase line 1632. **Error : DBI::st=HASH(0x18dc048)->errstr DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at scripts/updater/updatedatabase line 1632. **Error : DBI::st=HASH(0x16e20)->errstr DBD::mysql::st execute failed: Table 'koha.printers' doesn't exist at scripts/updater/updatedatabase line 1644. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1646. DBD::mysql::st execute failed: Table 'koha.printers' doesn't exist at scripts/updater/updatedatabase line 1705. DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1705. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1705. DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at scripts/updater/updatedatabase line 1746. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1747. DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at scripts/updater/updatedatabase line 1761. DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at scripts/updater/updatedatabase line 1769. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1770. DBD::mysql::db do failed: Table 'koha.items' doesn't exist at scripts/ updater/updatedatabase line 1785. DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at scripts/updater/updatedatabase line 1930. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1931. DBD::mysql::st execute failed: Table 'koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1974. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 1976. DBD::mysql::db do failed: Table 'koha.issuingrules' doesn't exist at scripts/updater/updatedatabase line 1990. synch'ing borrowers creating column textmessaging creating column password creating column flags creating column userid creating column homezipcode creating column zipcode creating column sort1 creating column sort2 synch'ing items DBD::mysql::st execute failed: Table 'koha.items' doesn't exist at scripts/updater/updatedatabase line 2047. DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/ updater/updatedatabase line 2049. synch'ing biblio synch'ing biblioitems creating column place DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 2130. DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 2138. DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 2138. (Last three lines repeating a few dozen times) Later: Choose MARC definition [1]: 3 ERROR 1048 (23000) at line 165: Column 'frameworkcode' cannot be null Later: Which language do you choose? en ERROR 1146 (42S02) at line 1: Table 'koha.systempreferences' doesn't exist BTW: I'm using MySQL 5.0.27 Dorian Meid

2 2

ER Diagrammer for the Koha Database
by Rick Welykochy 02 Mar '07

02 Mar '07

Hi all, I am doing a bit of development work on a local install of Koha and am constantly using MySQL to refer to the schema for the database. Enquiries with Katipo and elsewhere show that there is no overall ER diagram for the database. I am prepared to construct one from what I find, but wonder this: Are there any tools the list might know of that can connect to MySQL and produce an ER diagram of the schema? cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Blessed are the cracked for they let in the light. -- Spike Milligan

4 4

Security with MySQL and PHP
by Pascale Nalon 02 Mar '07

02 Mar '07

Hello, As RespInfo for my library branch, I often receive mails for security warning (like this : http://www.php-security.org/index.html) on MySQL DB and PHP. What's your mind about these problems ? What're the risks with Koha ? yours -- Pascale Nalon Bibliothèque de l'Ecole des Mines de Paris 35, rue St Honoré 77300 Fontainebleau Tel : 01 64 69 48 79

2 1

Koha Devel
by Russel Garlick 01 Mar '07

01 Mar '07

Koha-devel(a)nongnu.org -- Russel Garlick Operations Manager Katipo Communications Ph: +64 4 934 1285 Fax: +64 4 934 1286 Mob: +64 27 537 1377 Skype: russelgarlick Web http://www.katipo.co.nz

1 0

private new
by Paul POULAIN 28 Feb '07

28 Feb '07

Hello, as most of you already know, Matthieu Poulain is born on sunday, feb 25, at 11:26AM. He was 3.530kg, 52cm. The mother and the baby are fine. The father is tired :-D They were back home today. You can see some picture if you're interested at http://www.paulpoulain.com/matthieu/ i'll mostly be away in march... -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

1 0

Reverting to previous versions in CVS
by Joshua M. Ferraro 28 Feb '07

28 Feb '07

Hey gang, I recently had a heck of a time working with Savannah's CVS to get it to allow me to revert a version of a file to a previous one. Here's how I eventually got it to work: $ cvs update -j 1.3.2.14 -j 1.3.2.15 search.pl $ mv search.pl search.pl.new $ cvs update -A search.pl $ mv search.pl.new search.pl $ cvs commit -m "reverting to previous version" search.pl Ahem ... we need a new revisioning system :-) Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

6 5

koha rss
by long_sam.tw 27 Feb '07

27 Feb '07

koha rss summary: how to configure rss on koha. Credit: Originally written by Pat Eyler (pate(a)eylerfamily.org) suggestions, advice, and help came from 'Content Syndication with RSS', Chris Cormack, Mike Hansen, Steve Tonnesen and a variety of folks on #koha at irc.katipo.co.nz. 1. environment koha 2.2.5 & koha 2.2.7 (templete for npl) 2. cvs mkdir cvs cd cvs cvs -z3 -d:pserver:anonymous@cvs.savannah.nongnu.org:/sources/koha co koha cd koha and copy -R rss/ /your-koha/intranet/modules/C4/ 3. lastAcquired-2.0.conf lastAcquire.conf books ------------------------------- channel title=Recent Koha Acquisitions link=http://www.koha.org desc=The 15 most recent acquisitions lang=en image title=Koha, the worlds best Open Source Library System url=http://www.koha.org/images/foo.jpg link=http://www.koha.org width=88 height=31 config tmpl=/opt/koha/intranet/modules/C4/rss/lastAcquired-2.0.tmpl output=/opt/koha/intranet/modules/C4/rss/lastAcquired-2.0.xml query=select biblio.title as title, biblio.author as author, biblio.biblionumber as bibid, biblio.notes as notes, biblioitems.place as place, biblioitems.publishercode as publishercode, biblioitems.publicationyear as publicationyear, biblioitems.pages as pages, biblioitems.illus as illus, biblioitems.size as size from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.issues desc 4. lastAcquired.tmpl <?xml version="1.0" encoding="utf8"?> <rss version="2.0"> <channel> <title></title> <link></link> <description></description> <language></language> <lastBuildDate></lastBuildDate> http://blogs.law.harvard.edu/tech/rss <generator>Koha</generator> <image> <title></title> <url></url> <link></link> <width></width> <height></height> <description></description> </image>  <item> <title>Title：  Author：  </title> http://www.koha.org/cgi-bin/koha/opac-detail.pl?bib= <description><![CDATA[Title：  Author：          ">Details | ">Reserve | &resultsperpage=20&orderby=biblio.title&op=do_search">other works ]]></description> </item>  </channel> </rss> 5. navigation.inc # add http://www.w3.org/People/Ishida/images/rdf_flyer-small.gif> http://lit145.lacc.fju.edu.tw/koha/rss/lastAcquired-2.0.xml>The 15 most recent acquisitions 6. crontab crontab -e 0 8,17 * * * /opt/koha/intranet/modules/C4/rss/rss.pl /opt/koha/intranet/modules/C4/rss/lastAcquired-2.0.conf 7. koha-httpd.conf www.koha.org:80> ServerAdmin long_sam.tw(a)yahoo.com.tw DocumentRoot /opt/koha/opac/htdocs ServerName www.koha.org ScriptAlias /cgi-bin/koha/ /opt/koha/opac/cgi-bin/ Redirect permanent index.html http://www.koha.org:80/cgi-bin/koha/opac-main.pl ----------------------------------------------------------------------------------- # add Alias Alias /koha/rss/lastAcquired-2.0.xml "/opt/koha/intranet/modules/C4/rss/lastAcquired-2.0.xml" </VirtualHost> restart apache 8. use google reader http://farm1.static.flickr.com/186/404542415_d0b27b3e67_o.png you can use firefox 2.0 9. demo site http://lit145.lacc.fju.edu.tw http://koha.nkes.ntct.edu.tw http://koha.jente.edu.tw 10. chinese information http://koha.wikispaces.com/rss laxendion ___________________________________________________ 您的生活即時通－溝通、娛樂、生活、工作一次搞定！ http://messenger.yahoo.com.tw/

1 0

Re: [Koha-devel] koha 3.0 & zebra
by Henri-Damien LAURENT 27 Feb '07

27 Feb '07

long_sam.tw a écrit : > hi,henri-damien lautent > > thanks. > > i change KOHA_CONF to koha.xml. > > opac-main.pl for prog > > http://farm1.static.flickr.com/165/404367800_68bb7694af_o.png > > but can't search > > http://farm1.static.flickr.com/137/404367801_e55ac3f46b_o.png > > error log > > > Error : > > Can't call method "size" on an undefined value at /usr/local/koha/intranet/modules/C4/Search.pm line 327. > > Would you mind sending a bigger part of logs ? rel_3_0 is still unstable. Maybe, You must try and create some zebra configuration files. If you did, maybe you could send some records in an iso2709 file + your zebra configuration files. To answer an other question : Zebra CAN Actually manage multiple formats in one base. But Koha is not using those features at the moment. > serach result is null. i run yaz-client @:2100/biblios, > i can find records. > > Z> find @attr 1=1016 perl > Sent searchRequest. > Received SearchResponse. > Search was a success. > Number of hits: 1, setno 1 > SearchResult-1: term=perl cnt=1 > records returned: 0 > Elapsed: 0.130322 > ----------------------------------------------- > zebraserv log > 15:01:11-27/02 zebrasrv(1) [request] Search biblios OK 1 1 1+0 RPN @attrset Bib-1 @attr 1=1016 perl > ------------------------------------------------ > i use koha search. > zebraserv log > 15:19:32-27/02 zebrasrv(4) [session] Session - OK 4 tcp:::1 5978 > 15:19:32-27/02 zebrasrv(4) [request] Auth none > 15:19:32-27/02 zebrasrv(4) [request] Init OK - ID:81/81 Name:ZOOM-C/YAZ Version:1.108/2.1.46 > 15:19:33-27/02 zebrasrv(4) [session] Connection closed by client > -------------------------------------------------------------- > Regards. -- Henri-Damien LAURENT

1 0

New Koha Languages Module
by Joshua M. Ferraro 21 Feb '07

21 Feb '07

Hi gang, On IRC today, hdl, paul and I discussed how we represent lists of languages in Koha. At the moment we have three places where lists are represented, and all three use a different method of obtaining the list: 1. language switcher for OPAC and Intranet, and directory names for the language options (use two letter codes based on the ISO 639-1 standard ). 2. search interface (limiting by langauge like on: http://search.athenscounty.lib.oh.us/search?expanded_options=1 ( use three letter codes based on ISO 639-2, language names in the language's script, and English langauge names all hardcoded in Koha.pm). 3. hdl's new web installer, where the librarian picks her language as a step in the install process (uses two letter codes based on ISO 639-1, hardcoded). There are other places where lists of langauges will need to be represented shortly (on that I can think of off the top of my head is the new translation site that is currently in beta). I'd like to propose that we create a new Language.pm module for managing the list of languages with the aim to provide the following elements for every list of langauges: 1. two or three letter codes for the language based on ISO 639-2, which is maintained by the LOC and is inclusive of ISO 639-1: http://www.loc.gov/standards/iso639-2/ http://www.loc.gov/marc/languages/ 2. the language name in the script of the language. So for instance, 中文 for Chinese, Français for French, etc. 3. the langauge name in the language of the user, based on the template language choice ( so that if you are logged in as a French speaker, you'd see Perse (French spelling), not Persian (English spelling). To acomplish this, I propose we create a Language.pm module in Koha that provides a set of functions for finding lists in various contexts. We could utilize the existing lists around ISO-630-2 to create the initial list, perhaps stored as a flat file, or in SQL ... and we will need to create a new language_list.tmpl file to store language name translations (at least some of which can probably be automated using available translations). So, ideas, questions? Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

1 1