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

Adding support for PostgreSQL, no new MySQLisms, please
by Marc Balmer 24 Mar '12

24 Mar '12

Dear Koha-Devels, during the Marseille Hackfest 2012 I started together with Stephane and Christophe from BibLibre to add support for the PostgreSQL database. The ultimate goal of this work is that Koha can run on a PostgreSQL server as as good as it does now on a MySQL server. This mostly boils down to removing the MySQLisms in the current code, which I am currently doing. The collect-all-activity bug for this is 7365, it holds dependencies to the individual bugs like 7802, 7806 etc. (more to come, obviously). There is also a wiki page wiki.koha-community/wiki/PostgreSQL which I update frequently. This work also means that you must not add new MySQLisms in new code. Especially don't use backuotes in column names, write INSERT INTO foo (bar) VALUES (42); instead of INSERT INTO foo(`bar`) VALUES (42); For more idioms, consult above mentioned Wiki page, and if in doubt you can contact me, I am always willing to help with database issues. And please be advised that adding MySQLisms in new code will fail in QA. Thanks for your cooperation! If all goes well, this work should be concluded in a few months (but we are not in a hurry). - Marc Balmer

8 16

Next week is Global Bug Squashing Week!
by Magnus Enger 24 Mar '12

24 Mar '12

Dear Community, The deadlines for getting stuff into version 3.8 are drawing near: http://wiki.koha-community.org/wiki/Roadmap_to_3.8 As most of you are probably aware now, there will be a super cool hackfest in Marseille next week: http://drupal.biblibre.com/en/blog/entry/2012-hackfest-in-europe For those of us who can't be there in person, it's still possible to contribute to the fun, by joining the Global bug squashing week: http://wiki.koha-community.org/wiki/2012-03-19_Global_bug_squashing_week As far as I can tell, the beginning of this week will be the last chance for having new features signed off with any hope of getting them into 3.8. And there are bugfixes and minor improvements to look after. Not sure how you can help? Jump on the IRC channel ( http://koha-community.org/get-involved/irc/ ) and we will help you get started! And with the sandboxes provided by BibLibre all you need in order to join the fun is a web browser! http://wiki.koha-community.org/wiki/2012-03-19_Global_bug_squashing_week See you there! Magnus Enger

6 6

Hackfest 2012 in Marseille feedback
by Paul Poulain 23 Mar '12

23 Mar '12

Hello, If you want to know what we made during the hackfest i've written an entry in koha-community.org : http://koha-community.org/marseille-hackfest-2012-feedback/ Happy reading & thanks to all of those who came ! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Hourly loans -bug 5549- pushed, please test
by Paul Poulain 22 Mar '12

22 Mar '12

Hello, I just pushed a large patch that is related to hourly loans. It has been tested by a lot of ppl (including at the hackfest), but it's worth more tests, so feel free to update your git repositories and report the result of your tests here ! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

For those running master
by Paul Poulain 22 Mar '12

22 Mar '12

Hello koha-devel, if any of you is running master, I pushed a large patch with a DB revision mistake yesterday. The 3.07.00.032 DBrev won't apply correctly. If you've already updated and have applied this DBrev, I suggest you run the following SQL commands: ALTER TABLE virtualshelves MODIFY COLUMN owner int; UPDATE virtualshelves vi LEFT JOIN borrowers bo ON bo.borrowernumber=vi.owner SET vi.owner=NULL where bo.borrowernumber IS NULL; DELETE FROM virtualshelves WHERE owner IS NULL and category=1; ALTER TABLE virtualshelves ADD COLUMN allow_add tinyint(1) DEFAULT 0, ADD COLUMN allow_delete_own tinyint(1) DEFAULT 1, ADD COLUMN allow_delete_other tinyint(1) DEFAULT 0, ADD CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL; UPDATE virtualshelves SET allow_add=0, allow_delete_own=1, allow_delete_other=0 WHERE category=1; UPDATE virtualshelves SET allow_add=0, allow_delete_own=1, allow_delete_other=0 WHERE category=2; UPDATE virtualshelves SET allow_add=1, allow_delete_own=1, allow_delete_other=1 WHERE category=3; UPDATE virtualshelves SET category=2 WHERE category=3; ALTER TABLE virtualshelfcontents ADD COLUMN borrowernumber int, ADD CONSTRAINT `shelfcontents_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL; UPDATE virtualshelfcontents co LEFT JOIN virtualshelves sh USING (shelfnumber) SET co.borrowernumber=sh.owner; CREATE TABLE virtualshelfshares (id int AUTO_INCREMENT PRIMARY KEY, shelfnumber int NOT NULL, borrowernumber int, invitekey varchar(10), sharedate datetime, CONSTRAINT `virtualshelfshares_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `virtualshelfshares_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacAllowPublicListCreation',1,'If set, allows opac users to create public lists',NULL,'YesNo'); INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacAllowSharingPrivateLists',0,'If set, allows opac users to share private lists with other patrons',NULL,'YesNo'); If you haven't updated between yesterday and now, you have nothing to do, i've pushed a fix that will make your update work smoothly -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 1

Koha patron import
by ZUULU COOPER 22 Mar '12

22 Mar '12

Can anyone send me a copy a patron import file for me to try. I have run out of options. I recently installed Koha 3.06.04 Live DVD and I am getting errors the surname, borrowernumber, branchcode and categorycode. I do not know what I am doing wrong. I installed the Koha GSDL and I get the same error. I enter the some of sample data from the GSDL version into the LIVE DVD and I still get the same error. -- Zuulu Cooper Founder & Executive Director Libraries for Liberia Foundation 5919 Dakar Road West Suite 100 Westerville, OH 43081 614 270 3464 Skype: Shaka_zu00 website : http://librariesforliberiafoundation.com email: info(a)librariesforliberiafoundation.com *“Cause change and lead, accept change and survive, resist change and die.” * Ray Noorda - 1924-2006, technology pioneer, Novell Corporation CEO.

1 0

koha / installation
by Samuel desseaux 22 Mar '12

22 Mar '12

Hi, My question is very short and easy: what sort of installation of koha could you advice? By git or by the tarball? I work on a migration of our ILS for koha. Best regards samuel

2 1

Translation question
by Marcel de Rooy 22 Mar '12

22 Mar '12

Hi all, Sorry for cross-posting ;) Something in between.. Does anyone of you foresee problems with translating a construction like this one just as in the sysprefs? Allow/Do not allow (in combo) -- followed by text like: -- anyone to delete items from the list See screenshot: http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8467 Thanks for your attention. Marcel

1 0

Call for News for the March Newsletter
by Daniel Grobani 21 Mar '12

21 Mar '12

Dear Koha Kommunitarians, I'm harvesting news for the March 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 what you're currently working on for publication in the gossip/society column. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

2 1

4 patches i'll push tomorrow...
by Paul Poulain 20 Mar '12

20 Mar '12

Hello koha-devel, There are a few patches that are waiting for too long in my "passed QA" list: * 7144 Floating collection * 7092 Complete-subfield searches TraceCompleteSubfields syspref not working correctly * 7310 Improving permissions on lists (virtual shelves) * 6831 Enhanced Workflow for adding analytical records For those 4 patches, I couldn't test them successfully: * I took time trying to test them * I could not made the feature work (for 7144/7092/6831), maybe it's because of something i'm doing wrong or I can't reproduce correctly or my database doesn't have a needed configuration (MARC21 ?) I think it's unfair to block those patches because *I* can't test them properly. Other ppl have signed them off already, all of them have been examined in details. What annoys me is also that the feature freeze is close, so I want to push as many things as possible before. SO = i'll push them tomorrow, asking for more tests after pushing ! Note = don't think i'll do that frequently ;-) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0