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

Koha 3.0 + apache2 problem
by Zico 08 Mar '09

08 Mar '09

I am trying to install Koha 3.0 in Debian 4.0 r0. Everything went well... perl dependencies configuration, cpan configuration, mysql configuration, koha and zebra. But, at last, when i tries to open my server with http://koha:8080/ then nothing comes. Plus, if i tries to restart my apache2 then, this error comes: *debian:~# /etc/init.d/apache2 restart Forcing reload of web server (apache2)...[Mon Mar 09 07:26:12 2009] [error] (EAI 2)Name or service not known: Could not resolve host name __WEBSERVER_IP__:__WEB SERVER_PORT__ -- ignoring! Warning: DocumentRoot [/etc/apache2/__OPAC_WWW_DIR__] does not exist [Mon Mar 09 07:26:13 2009] [error] (EAI 2)Name or service not known: Could not r esolve host name __WEBSERVER_IP__:__WEBSERVER_PORT_LIBRARIAN__ -- ignoring! Warning: DocumentRoot [/etc/apache2/__INTRANET_WWW_DIR__] does not exist Syntax error on line 45 of /etc/apache2/sites-enabled/koha: The port number "__WEBSERVER_HOST__:__WEBSERVER_PORT_LIBRARIAN__" is outside the appropriate range (i.e., 1..65535). failed! * Can you please help me? -- Best, Zico

2 2

Mass updating a field
by Roche III, Edward 08 Mar '09

08 Mar '09

Good Afternoon All I posted on the Koha users list as well but figured I would try here as to. I am in need of a SQL statement to update my barcode field in the items table. When we exported our catalog from Follett it removed a space that was in out barcodes so now when we try to scan an item it is not being found because the barcode field in Koha is missing the space. What I have done so far: 1) Export from the items table: itemnumber and barcode 2) Added the space back into the barcode field 3) Created a temp table in the koha db 4) Imported the data into the temp table I now need to move the data from the temp table over to the items table to update the barcode field. Any thoughts? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

2 4

items.notforloan and holds
by Owen Leonard 05 Mar '09

05 Mar '09

I've been trying to figure out why my patrons can't place holds on on-order items (items.notforloan = -1) from the OPAC. If found this in opac-reserve.pl (line 138): if (!$itm->{'notforloan'} && !($itm->{'itemnotforloan'} > 0)){ $forloan=1; } Trying to find out what the difference was between $itm->{'notforloan'} and $itm->{'itemnotforloan'} I checked GetItemsInfo() in Items.pm. GetItemsInfo() SELECTs both "items.*" and "items.notforloan as itemnotforloan." So $itm->{'notforloan'} and $itm->{'itemnotforloan'} are the same thing? Changing line 138 of opac-reserve.pl to if ($itm->{'notforloan'} <1){ $forloan=1; } ...would be correct wouldn't it? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 1

Re: [Koha-devel] Coverity - creating OS software maps - (automated defect detection)
by Colin Campbell 05 Mar '09

05 Mar '09

It's a static analysis tool which works on projects in C, C++ and Java. It was originally developed to analyse the linux kernel codebase. As such the Koha code is not a candidate, but many of the projects Koha relies on (Perl, Apache) are already using it Cheers Colin

2 1

Sorting Authority Headings
by Eric Bégin 05 Mar '09

05 Mar '09

Hi, Is there a way to sort the result of the authorities headings and subheadings? Let's say we have the following geographic locations/sublocations Canada » Quebec Canada » Ontario Caanda » British Columbia United States » Maine United States » California United States » New York The location are sorted, but not the sublocations. Any clue how we could make the sort correctly? Thanks, Eric _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel

3 3

Converting to Koha
by Dale Copps 04 Mar '09

04 Mar '09

I am looking into converting my ILS from EOSi GLAS (Cat, Circ, Serials) to Koha and am seeking a consultant with whom I could discuss issues such as data conversion, importation, setup, etc. I have subscribed to this list but have not had the subscription confirmed, so please respond to me off list. Thanks. -Dale ----------------------------------------------- Dale Copps, Library Manager Creare Inc., 16 Great Hollow Road Hanover, NH 03755 603 640-2384 fax: 603 643-4657 dgc(a)creare.com www.creare.com -----------------------------------------------

1 0

zebraqueue in daemon mode
by Eric Bégin 04 Mar '09

04 Mar '09

Hi (again), I'm wondering which tasks the zebraqueue.pl script should perform. I initially though that running it in daemon mode was replace the need to call rebuild_zebra script. It seems to work fine when we are adding biblios or authorities, but it looks like it doesn't remove a biblio (didn't try the authority yet) from the zebra index when we delete it from Koha's catalogue. I find this weird since the corresponding 'recordDelete' entry of zebraqueue table has its 'done' value to 1. Is this a bug or the normal behavior? If this is a problem on my setup, where should I look cause I don't have anything in the log files (koha-zebraqueue.err and koha-zebraqueue-output.log) Thanks, Eric

1 0

Additional Logins
by Roche III, Edward 03 Mar '09

03 Mar '09

How do you add additional login for the staff side (librarians)? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel

3 3

Copy Information
by Roche III, Edward 03 Mar '09

03 Mar '09

I was spot checking a couple of my imported records and came across one that said it had no copies. I then double check our current application and found that there is (1) copy of the book. Does anyone know which field/s holds this information? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel

1 0

Coverity - creating OS software maps - (automated defect detection)
by Irma Birchall 01 Mar '09

01 Mar '09

Hi, This is not exactly what a librarian spends her time reading about, but the article caught my attention... The article: "A Better Grip on Open Source Projects?" http://www.internetnews.com/dev-news/article.php/3803471/A+Better+Grip+on+Op en+Source+Projects.htm New effort by vendor Coverity promises to map over 2,500 open source apps. http://scan.coverity.com/arch/ >From their homepage: "ACCELERATING OPEN SOURCE QUALITY" "In collaboration with Stanford University, Coverity <http://www.coverity.com/> is establishing a new baseline for software quality and security in open source. Under a contract with the Department of Homeland Security, we apply the latest innovations in automated defect detection to uncover some of the most critical types of bugs found in software." " Coverity Architecture Analyzer. The tool uses information gathered during the build of a codebase to create a comprehensive list of interdependencies in the code. These dependencies can be investigated interactively with the Architecture Analyzer desktop application. It can also be used to generate diagrams..." I wonder if adding Koha's code is of any interest to the Koha Project/developers and the rationale for the decision? An invitation to add additional projects is included: use the 'Submit a Request' <http://scan.coverity.com/arch/> link. Does anyone know more about this code analyser? Just curious.. Regards, Irma CALYX information essentials

1 0