Re: [Koha-devel] How about a different way of handling database updates

2010-02-17 Thread Michael Hafen
I'm still thinking about this. The only thing I've come up with so far is to enclose all the database updates in a subroutine, and put the code from kohaversion.pl into updatedatabase.pl. That would make one less file to edit. And if the few sub's at the end of updatedatabase.pl were moved to th

Re: [Koha-devel] feasibility of external circulation updating Koha items table availability

2010-02-17 Thread Galen Charlton
Hi, On Wed, Feb 17, 2010 at 5:57 PM, Galen Charlton wrote: > Hi, > > 2010/2/17 Christopher Curry : >> First, am I correct that updating the availability status of an item in the >> Koha Opac requires only that we update this field (items.onloan)? > > No, that's not sufficient - it would also be n

Re: [Koha-devel] feasibility of external circulation updating Koha items table availability

2010-02-17 Thread Galen Charlton
Hi, 2010/2/17 Christopher Curry : > First, am I correct that updating the availability status of an item in the > Koha Opac requires only that we update this field (items.onloan)? No, that's not sufficient - it would also be necessary to update the 952 field in the MARC bib record corresponding t

[Koha-devel] feasibility of external circulation updating Koha items table availability

2010-02-17 Thread Christopher Curry
We're implementing Aeon (a paging system that can handle requests for individual manuscript items from EAD finding aids as well as requests for mongraphs/serials) alongside Koha and we want to be able to display item availability in Koha. Since we're not using Koha's circulation system, we'll

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Clay Fouts
Definitely. Even though the session table may in many cases be much smaller than other tables in terms of bytes or rows, the frequency at which it is written to causes it to be heavily fragmented on the disk, which greatly reduces the average throughput during a mysqldump, increasing the backup tim

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Clay Fouts
Sessions are created for every OPAC session, too, even if they're not logged in with a login/password. And consequently there's no way to log those out. On Wed, Feb 17, 2010 at 11:14 AM, Walls, Ian wrote: > Clay, > > > > > Thanks! That sounds like an easy enough enhancement to make. I’ll mak

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Frederic Demians
And since you must backup daily your Koha DB, you should truncate sessions table just before mysqldump-ing in order to backup as few sessions data as possible. -- Frédéric ___ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mail

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Chris Cormack
2010/2/18 Clay Fouts : > It depends, actually. For tables without FK constraints (like Koha's > "sessions"), truncation is instantaneous in MySQL. > Not when they tried it yesterday :-) It does depend, InnoDB can do some strange things. Chris ___ Koha-d

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Clay Fouts
It depends, actually. For tables without FK constraints (like Koha's "sessions"), truncation is instantaneous in MySQL. On Wed, Feb 17, 2010 at 12:02 PM, Chris Cormack wrote: > 2010/2/18 Clay Fouts : > > You can also use "truncate sessions" to do the job if you just want to > clear > > out the c

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Chris Cormack
2010/2/18 Clay Fouts : > You can also use "truncate sessions" to do the job if you just want to clear > out the contents of the table. It's faster and simpler than using mysqldump. > > This issue arises from the fact that the way Koha is written, if a user just > walks away from a session without l

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Galen Charlton
Hi, 2010/2/17 Clay Fouts : > You can also use "truncate sessions" to do the job if you just want to clear > out the contents of the table. It's faster and simpler than using mysqldump. Also, in HEAD there's a little script to truncate sessions as well as get rid of old zebraqueue entries. It's c

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Walls, Ian
Clay, Thanks! That sounds like an easy enough enhancement to make. I'll make it a point to keep an eye on the sessions table until then, and remind my coworkers to logout properly. Cheers, -Ian From: koha-devel-boun...@lists.koha.org [mailto:koha-devel-boun...@lists.koha.org] On Behalf O

Re: [Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Clay Fouts
You can also use "truncate sessions" to do the job if you just want to clear out the contents of the table. It's faster and simpler than using mysqldump. This issue arises from the fact that the way Koha is written, if a user just walks away from a session without logging out, their session data w

[Koha-devel] Koha sessions table is ridiculously huge

2010-02-17 Thread Walls, Ian
Developers, After performing a software upgrade and server reboot, I came across this problem. My koha.sessions table is over 13 million entries. This seems to indicate that entries into the table were never removed, and that may help to explain why my backup mysqldumps are increasing by aro

Re: [Koha-devel] koha 3.0.5 + print slip problem

2010-02-17 Thread Zico
Thanks All! I have sloved it by selecting bottom margin to 0.0!!! :D On Wed, Feb 17, 2010 at 7:55 PM, Tomás wrote: > 2010/2/17 Susan Bennett : > > Hi Zico and group, > > > > In the Firefox page setup make sure that under the Margins and > Header/Footer > > tab that all the footers are set to bla

Re: [Koha-devel] koha 3.0.5 + print slip problem

2010-02-17 Thread Tomás
2010/2/17 Susan Bennett : > Hi Zico and group, > > In the Firefox page setup make sure that under the Margins and Header/Footer > tab that all the footers are set to blanks. We have ours set so that only > the date/time is printed in the upper right. That stops the page at the end > of the printing

Re: [Koha-devel] koha 3.0.5 + print slip problem

2010-02-17 Thread Susan Bennett
Hi Zico and group, In the Firefox page setup make sure that under the Margins and Header/Footer tab that all the footers are set to blanks. We have ours set so that only the date/time is printed in the upper right. That stops the page at the end of the printing. Susan Bennett ILS System Administr

[Koha-devel] Change requested: XSLT syspref changes in 3.0.x

2010-02-17 Thread Galen Charlton
Hi, I would like to request that the following 3.0.x commits be reverted or modified before the release of 3.0.6. 4b04de209aa25816f5d97c05ce71ea9619027484 3057a7afb98c9224d3fd987131ae88956eb513d3 The upshot of these changes are that XSLTDetailsDisplay and XSLTResultsDisplay were changed from a B

[Koha-devel] koha 3.0.5 + print slip problem

2010-02-17 Thread Zico
Hi, i have been trying to print slip from Koha 3.0.5. I am using Star TSP650. But, when the print occurs, it takes a 11.5 inch/A4 size slip; whereas the datas are very little there in that page. I tried to find the page setup from Firefox; but it hasn`t change anything. -- Best, Zico

[Koha-devel] Measuring Koha resource usage

2010-02-17 Thread Charl
Is there a specific tool available to check/record Koha's usage on a server? If not, which processes should be checked/measured? Thanks ___ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel