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

new feature : catalogue browsing
by Paul POULAIN 07 Mar '07

07 Mar '07

Hello, I've just commited a new feature, called "catalogue browsing". A new script in misc/cronjobs/build_browser_and_cloud.pl will fill 2 new tables. - One for "tag cloud" searching : the tags are not filled by the users themselves, but from the catalogue. I plan to add later a feature to have a user-level tag system + a p2p system to share tags. for instance the "tag cloud" table will be filled from the catalogue only. - One for "Catalogue browsing" : depending on the parameters you give to build_browser_and_cloud.pl script, you'll fill the browser table, that let the user browse the catalogue. If you have dewey classification in your catalogue, you'll be able to dig the dewey hierarchy (3 => 31 => 311 => 311.2 ...), and define description for the 3, 31, 311... french dewey has been commited & you can see the result at : http://o17.bureau.paulpoulain.com/cgi-bin/koha/opac-browser.pl It should be easy to add english dewey, Loc classification or any other hierarchic classification. TO DO : - improve the build_... script, to have an option to update only last-week bilbio modifications. This can be made easily, but at the price of imprecision in the counters, which is cheap imho. The "complete" calculus can be run once a month anyway. But note that, on my computer, it calculates 50 biblios/seconds - add a screen, in admin section, to let the library define their descriptions for the browser. -- 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

2 2

Koha and OAI
by Paul POULAIN 07 Mar '07

07 Mar '07

Hello world, Just to let you know : I have some contacts that are interested by adding OAI features to Koha. They should do it on Koha 2.2.x branch and, later, on koha 3.x probably. The school that is interested will ask for a student work (5 weeks in april/may) If someone in this list already has investigated such feature, please let me know. Otherwise, just stay tuned, i'll let you know if they decide to do it. -- 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

5 7

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