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

for Chris
by paul POULAIN 03 Dec '03

03 Dec '03

Hi chris, In the DB schema (see previous post), i've listed 10 tables that are not used, or almost not used in Koha. Could you check the list & confirm deletion (look at branchcategories & branchrelations specifically) Note : i'll drop tables only in 2.0.x branch, not in 2.0.0 one (to avoid last-minut bugs) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

DB schema
by paul POULAIN 03 Dec '03

03 Dec '03

Hi guys, An uptodate DB schema is avaible :-) Many people asked for this schema. I've done it. Look at Koha wiki (www.koha.org/wiki) Developper link chapter. The 2 pages schema is avaible in 3 formats : jpg (2 images), PDF and OpenOffice.org (original format) HTH -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Many DBI updates going through as part of bug 662 fix
by MJ Ray 03 Dec '03

03 Dec '03

I'm reviewing nearly all DBI calls in koha after finding non-placeholder use of user values. They could leave koha open to SQL insertion attacks, possible from users. I really don't want that to happen. I'm about 10% done. The main changes I'm making are: 1. Rephrasing anything like $sth = $dbh->prepare("select * from borrowers where borrowernum=$bornum"); $sth->execute(); into $sth = $dbh->prepare("select * from borrowers where borrowernum=?"); $sth->execute($bornum); 2. Rephrasing $query = "some string"; $sth = $dbh->prepare($query); into $sth = $dbh->prepare("some string"); 3. Removing suggestions about using $dbh->do("select * from foo where id=$bar") from comments. I'm trying to be really careful about this, but the sheer number of calls may mean that I introduce a new bug. The various search pages are the most likely to show symptoms, so I'll try to test those before the next release. If any maintainers want to warn me off their code and make these changes themselves, please email me. I'm still wandering around C4/Circulation and working in roughly alphabetical order. -- MJR/slef My Opinion Only and possibly not of any group I know. Please http://remember.to/edit_messages on lists to be sure I read http://mjr.towers.org.uk/ gopher://g.towers.org.uk/ slef(a)jabber.at Creative copyleft computing services via http://www.ttllp.co.uk/

1 0

polish version in 2.0.0RC1
by paul POULAIN 03 Dec '03

03 Dec '03

Hi benedikt & al, do you think the polish version is stable enough to be included as an option during the installation of Koha ? A new version 2.0.0RC1 will be released before end of week. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Add member process does not check for duplicate barcode
by JAVIER RICARDO MEJIA C. 23 Nov '03

23 Nov '03

Hi i have a bug the version WIN32 PRE5 2.000 in the Add member process does not check for duplicate barcode if you disable the checkdigit katipo in the preferences menu. How can i corect these without wait to the new release. thanks. Javier

2 1

cvs howto
by paul POULAIN 21 Nov '03

21 Nov '03

Hi, for another project, i'm cvs admin :-) I want to create a mail when a commit is done, like in koha-cvs ml. How to do that ? I've found "cvs watch", is it the right way ? could someone give me some explanations ? -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

2 1

Adding Memmbers Help Me!!!
by JAVIER RICARDO MEJIA C. 21 Nov '03

21 Nov '03

Hi everybody, i want report and error on Koha 2.0.0 pre 5 Win32-R2 and is when you add a memmber to the example batabase the memember is added but you can´t called these memmeber for issues. And when you try add a other user the process is complete but the user is not added to the database. What can i do for correct this little misstake. Javier ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ Koha-win32 mailing list Koha-win32(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-win32

1 0

Upgrading from 1.2.3 I need MARC help
by Chris Cormack 19 Nov '03

19 Nov '03

Hi Guys Im testing upgrading from a 1.2.3 koha install to a 2.0 pre5 one. Everything has worked really well so far, but now i need to go set up all the MARC mappings. Has someone got a list of whta maps to what that i can use? Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz

2 1

Re: [Koha-devel] bugs and translations
by Owen Leonard 19 Nov '03

19 Nov '03

> > should I make the same correction in the other > > language templates? > If it's supposedly the same style template (eg > "default"), can it hurt anything to make the same fix? I would think not, but I noticed, for instance, that the German translation of the default template was significantly altered from the English version, leading me to wonder if translators felt some particular 'ownership' of them. I guess if anyone is bugged by my corrections they can always change it back! -- Owen

1 0

bugs and translations
by Owen Leonard 19 Nov '03

19 Nov '03

Maybe there are some template-translators that have an opinion on this, so I'll ask the question here: if a bug is reported concerning a template file (like an error in HTML), and I'm making a correction to the english template, should I make the same correction in the other language templates? Or do translators prefer to maintain their own templates? -- Owen ---- Nelsonville Public Library Koha 2.0.0-pre-x (CVS)

2 1