Re: [Koha-devel] stocknumber and invertory books in Koha

2012-01-17 Thread Chris Cormack
Hi Dobrica I think Zeno didn't mean technically impossible to provide uniqueness at the DB level, just that lots of libraries do not want unique stock numbers, so enforcing it at db level (with a unique constraint isn't possible in Koha). Enforcing it in the code, as you have done, with the cavea

[Koha-devel] 3.6.3 Update

2012-01-17 Thread Chris Nighswonger
Hi all, Just an update here on the status of 3.6.3. My schedule has been extremely busy since I returned to work the first of the month. As a result, I have been working in fits and starts to get commits picked out of master and into 3.6.x in preparation for the release of 3.6.3. After finally ge

Re: [Koha-devel] stocknumber and invertory books in Koha

2012-01-17 Thread Dobrica Pavlinusic
On Tue, Jan 17, 2012 at 04:42:38PM +0100, Zeno Tajoli wrote: > Hi Dobrica, > > Il 17/01/2012 16:32, Dobrica Pavlinusic ha scritto: > > I need help from people who use stocknumbers in their Koha's installs. > [..] > > For a start, why is index defined on items.stocknumber non-unique? > > I would as

[Koha-devel] Call for News for the January Newsletter

2012-01-17 Thread Daniel Grobani
Dear Koha Kommunitarians, I'm harvesting news for the January newsletter. Please send me by the 25th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two about wha

Re: [Koha-devel] Tables from InnoDB to MYISAM

2012-01-17 Thread Galen Charlton
Hi, On 01/17/2012 11:54 AM, Paul Poulain wrote: * innoDB has a *big* problem with deletion, and space is not retrived. so those tables, that have temporary data only are good candidates to be myISAM Although as long as one uses the innodb_file_per_table option, recovering space from InnoDB sc

Re: [Koha-devel] Tables from InnoDB to MYISAM

2012-01-17 Thread Paul Poulain
Le 17/01/2012 15:19, Zeno Tajoli a écrit : > Hi to all, > > to mantain a good Koha system is import to use the cron job > 'cleanup_database.pl'. > > This script delete lines from tables > > message_queue > need_merge_authorities > sessions > zebraqueue I'm for it: * innoDB has a *big* problem wi

Re: [Koha-devel] Tables from InnoDB to MYISAM

2012-01-17 Thread Colin Campbell
On Tue, Jan 17, 2012 at 03:19:13PM +0100, Zeno Tajoli wrote: > Hi to all, > > to mantain a good Koha system is import to use the cron job > 'cleanup_database.pl'. > > This script delete lines from tables > > message_queue > need_merge_authorities > sessions > zebraqueue > > The engine of those

[Koha-devel] On memcached/memoize

2012-01-17 Thread Tomas Cohen Arazi
We are using memcached in two different ways accross Koha code: 1) The traditional way, explicitly using memcached inside the method/function code (just a mock): sub get_key { my $data; if (C4::Context->ismemcached) { $data = C4::Context->memcached->get('key'); } $data = slow_rou

Re: [Koha-devel] stocknumber and invertory books in Koha

2012-01-17 Thread Zeno Tajoli
Hi Dobrica, Il 17/01/2012 16:32, Dobrica Pavlinusic ha scritto: > I need help from people who use stocknumbers in their Koha's installs. [..] > For a start, why is index defined on items.stocknumber non-unique? > I would assume that it has to be unique like barcode is (at least that's > our legal

[Koha-devel] stocknumber and invertory books in Koha

2012-01-17 Thread Dobrica Pavlinusic
I need help from people who use stocknumbers in their Koha's installs. I assume this is mostly Europe-specific since we are required by low to keep invetory books with each item in our library but I hope that other people might have similar legal requirements. For a start, why is index defined on

[Koha-devel] Tables from InnoDB to MYISAM

2012-01-17 Thread Zeno Tajoli
Hi to all, to mantain a good Koha system is import to use the cron job 'cleanup_database.pl'. This script delete lines from tables message_queue need_merge_authorities sessions zebraqueue The engine of those tables is InnoDB. What do you think about change the engine to MYISAM ? I think that M

Re: [Koha-devel] I need to enter through a WebService data users who enroll in the University

2012-01-17 Thread Fridolyn SOMERS
Hie, We have develop a webservice connexion from Koha to another server. We used SOAP-Lite lib : http://search.cpan.org/dist/SOAP-Lite/ Be carefull when you modify users, password is encrypted, it cant be recreated. Good luke. 2012/1/16 Christian Calle Jahuira > Dear Friends > > Congratulatio

[Koha-devel] Hackfest in Europe in march (reminder)

2012-01-17 Thread Paul Poulain
Hello everybody, A reminder about the hackfest BibLibre organize in Marseille in March. It's in 2 months, it's time to book your flights/trains/car/horse/boat, and tell us if you're coming. We already have 6 ppl (+ all BibLibre, of course) that should come, from 4 different countries (France, Germ

Re: [Koha-devel] Bugzilla

2012-01-17 Thread Paul Poulain
Le 16/01/2012 19:09, Galen Charlton a écrit : > Hi Paul, > > On 01/16/2012 12:53 PM, Paul Poulain wrote: >> we don't speak of bug display page, but of result list after a search. >> (before reaching bug display page then) > > Thanks for clarifying. I've increased the width of that column; please