- Koha - lists.katipo.co.nz

Re: [Koha] Checkout fails
by Muhammad Abdullah 16 Dec '11

16 Dec '11

I encountered exactly those same errors on my Koha 3.6.1. It seems the errors only appear when you upgrade the db from a previous version (3.2, in my case) of Koha to 3.6. I also got these errors when Koha is updating the database through the web installer: -- [Fri Dec 09 04:52:16 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 3997. [Fri Dec 09 04:52:16 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 3998. [Fri Dec 09 04:52:18 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'need_merge_authorities' already exists at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 4535. -- Chris C.(Koha's developer) said they are safe to ignore, though.( http://koha.1045719.n5.nabble.com/3-4-4-gt-3-6-1-upgrade-td5068580.html) And Kyle Hall(Koha Virtual Appliance's creator) has these to say about them: "I think it's probably safe to ignore those errors. The script is attempting to create fields that are already in the tables, so I doubt you will see any problems." On Thu, Dec 15, 2011 at 3:22 AM, Perch <jp(a)pk.dy.fi> wrote: > Upon trying to check items out to a patron this message appears: > > -- > Software error: > > Can't call method "subfield" on an undefined value at > /usr/share/koha/lib/C4/Biblio.pm line 3008. > > For help, please send mail to the webmaster (webmaster@vps185), giving this > error message and the time and date of the error. > -- > > The item gets checked out (i.e. it appears in the list of items checked out > to the client when you go return to the checkout page). The same happens > with check in. The items get checked in, but Koha stops at the error > message. > > Similar error message appears when trying to add a new issue to an existing > subscription. I think the problem might be related to error I received when > updating the database to new Koha version > (http://koha.1045719.n5.nabble.com/Database-update-errors-td5068234.html) > > Any help here? We really really need to get this working. > > -- > View this message in context: http://koha.1045719.n5.nabble.com/Checkout-fails-tp5075418p5075418.html > Sent from the Koha-general mailing list archive at Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Accession No. and Barcode filed mapping
by imageologist 16 Dec '11

16 Dec '11

Hi all, I have mapped 952$p with unique serial of barcode for circulation (e.g. LIB1000101, LIB1000102, LIB1000102)... I also have Accession no. (e.g. 254123, 19982, 05241) please guide me what field I'll use for accession no. mapping (as i already have a 952$p for serial barcode) Kind regards, Syed

1 0

Re: [Koha] Data Migration
by Rafael Saad 16 Dec '11

16 Dec '11

1 0

Re: [Koha] Change background color (was Koha Digest, Vol 74, Issue 30)
by Owen Leonard 15 Dec '11

15 Dec '11

On Wed, Dec 14, 2011 at 11:48 PM, Jagadish jagadish mn <jmn.jagadish(a)gmail.com> wrote: > how to change bakgrowand colour in Koha There are several ways to customize the appearance of Koha using CSS (Cascading Style Sheets). This overview might be a good place to start: http://www.myacpl.org/koha/?p=160 >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of Koha digest..." ... and please don't quote the entire digest, thanks. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

Re: [Koha] Koha Digest, Vol 74, Issue 25
by Randall Rowe 15 Dec '11

15 Dec '11

-----Original Message----- From: "Indranil Das Gupta" <indradg(a)gmail.com> Sent 12/15/2011 2:14:19 AM To: "Thippeswamy G.N" <thippesh(a)gmit.info> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Digest, Vol 74, Issue 25 Hi, 2011/12/15 Thippeswamy G.N <thippesh(a)gmit.info> Sir, How can i take dataBack and restore the database. Even I took Data Backup from PHPmyAdmin, but when i try to restore that, it showing the Back file is too big, because through PHPMYADMIN we can restore max(2MB) file. Please give me the proper solution for this. Thank you <snipped> You are obviously new to the mailing list etiquette and culture and specifically to the Koha maling list, so here are a couple of pointers to help you get started. 1. Please snip your posts / replies of unnecessary quotes. 2. We are not a sexist, solely male-dominated community, so a "Sir"-addressed mail may not get you all the help you are looking for. 3. PhpMyAdmin is not a part of the Koha software stack, hence the question is Off-Topic or OT on this forum. You are likely to be better served by asking this on on https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users However, since you asked, try saving the db dump file as a BZipped file (it will get you better compression, Zip is known to break) and then try to restore from the .bz2 file. I'm assuming that you are dumping a .sql file hope that helps -idg -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org Actually your best bet would be to edit your php.ini file and look for the following setting ; Maximum allowed size for uploaded files. ; http://php.net/upload-max-filesize upload_max_filesize = 2M Change that to the file size that you need and restart Apache. Randy Rowe Lincoln City Libraries I.T. _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Data Migration
by Zewar Khan 15 Dec '11

15 Dec '11

Dear Colleagues, I am using Koha 341(Fedora) on trail bases and planning to import my Access data to koha with the help of MarcEdit. I have mapped all data except the repeatable fields such as Keywords etc. I wonder if any one can help me how a repeatable field is mapped using MarcEdit software. Thank you for your time and consideration Zewar Khan

2 1

KOHA for windows
by Chauhan 15 Dec '11

15 Dec '11

Hi Professionals, Do we have any latest version of Koha for Windows around? Hope to hear you soon. Regards, Suresh K chauhan

2 1

Re: [Koha] Koha Digest, Vol 74, Issue 25
by Thippeswamy G.N 15 Dec '11

15 Dec '11

Sir, How can i take dataBack and restore the database. Even I took Data Backup from PHPmyAdmin, but when i try to restore that, it showing the Back file is too big, because through PHPMYADMIN we can restore max(2MB) file. Please give me the proper solution for this. Thank you On Mon, Dec 12, 2011 at 4:30 AM, <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Please shutdown the site of Koha Windows version (Vimal Kumar) > 2. Re: Please shutdown the site of Koha Windows version (Mirko) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 11 Dec 2011 21:19:03 +0530 > From: Vimal Kumar <vimal0212(a)gmail.com> > To: Koha-List <koha(a)lists.katipo.co.nz> > Subject: [Koha] Please shutdown the site of Koha Windows version > Message-ID: > <CAEaJrwV8gcRfvTn6WOneAuDmc2VZ7Jw8wTLuHumHkv5QxVwH4w(a)mail.gmail.com > > > Content-Type: text/plain; charset="utf-8" > > Dear Friends, > Many people are downloading Koha Windows version from > www.koha.rwjr.comsite and installed in their library and send many > query regarding about it. > They are newbies to Koha and don't know windows version is obsoleted one. > My humble request to Koha Windows version developer is that either shut > down the site or give proper message to visitors that development of > Windows version is stopped. > Installation of Koha in Windows is troublesome and can break anytime. > Many librarians entered their whole data in Koha Windows version and after > that they know that the version is not updated. > They feel difficult to convert their data to latest version of Koha. > Windows is not a good platform for Koha production system. > > Regards, > > -- > Vimal Kumar V. > Mahatma Gandhi University Library > Kottayam, Kerala- 686 560 > Web: www.vimalkumar.org > Blog: http://linuxhalwa.blogspot.com > --------------------------------------------------------------------------- > "I forget what I was taught. I only remember what I have learnt" > -Patrick White >

2 1

Re: [Koha] Koha Digest, Vol 74, Issue 30
by Jagadish jagadish mn 15 Dec '11

15 Dec '11

how to change bakgrowand colour in Koha On 12/15/11, koha-request(a)lists.katipo.co.nz <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Re: how can i view all the contents of the libary, Please > make it more clear (Stefano Bargioni) > 2. Error in Guided Report (Vimal Kumar) > 3. Update on link resolver + Koha? (Amy Schuler) > 4. Re: Update on link resolver + Koha? (Owen Leonard) > 5. Checkout fails (Perch) > 6. Call for News for the December Newsletter (Daniel Grobani) > 7. Equinox offering two scholarships for the 2012 Code4Lib > conference (Galen Charlton) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 14 Dec 2011 09:22:00 +0100 > From: Stefano Bargioni <bargioni(a)pusc.it> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] how can i view all the contents of the libary, > Please make it more clear > Message-ID: <21A847B4-4888-4A3C-AA50-E476933F623F(a)pusc.it> > Content-Type: text/plain; charset=us-ascii > > Maybe the select suggested in the wiki > > SELECT > items.price,items.replacementprice,biblio.title,biblio.author,items.itemcallnumber > FROM items > LEFT JOIN biblioitems ON > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.homebranch=<<Home branch|branches>> > ORDER BY items.itemcallnumber ASC > > could be enhanced using the cn_sort field, that cointains the sort form of > itemcallnumber, changing the ORDER BY clause into > ORDER BY items.cn_sort ASC > Stefano > >> There is a report for a complete shelf list on the wiki - >> http://wiki.koha-community.org/wiki/SQL_Reports_Library#Complete_Shelf_list >> >> You should be able to use that as a starting place to get what you're >> looking for. >> >> Liz Rea > > > ------------------------------ > > Message: 2 > Date: Wed, 14 Dec 2011 14:59:02 +0530 > From: Vimal Kumar <vimal0212(a)gmail.com> > To: Koha-List <koha(a)lists.katipo.co.nz> > Subject: [Koha] Error in Guided Report > Message-ID: > <CAEaJrwUCEkcj4Mp3YYC_je_xWin8xDxu9zKLAFCmYgicjD=-pw(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Dear Friends,I got the following message when try to create report from > > Reports > Guided Reports > Build New > > in the second step "Pick a report Type", Tabular. > > My koha version is 3.4.7 > > Software error: > > Undefined subroutine &C4::Reports::Guided::themelanguage called at > /usr/share/koha/lib/C4/Reports/Guided.pm line 714. > > For help, please send mail to the webmaster (webmaster@comp), giving this > error message and the time and date of the error. > > > -- > Vimal Kumar V. > Mahatma Gandhi University Library > Kottayam, Kerala- 686 560 > Web: www.vimalkumar.org > Blog: http://linuxhalwa.blogspot.com > --------------------------------------------------------------------------- > "I forget what I was taught. I only remember what I have learnt" > -Patrick White >

1 0

942 c searching and generating reports
by Chris Cormack 15 Dec '11

15 Dec '11

On 15 December 2011 14:39, Elaine Bradtke <eb(a)efdss.org> wrote: > Nope, that didn't work. How about something that will give me the > biblio number and the contents of the associated 942$c? > I can sort those in a spreadsheet and it might also give me a clue as > to what's going on. > Elaine What didn't work about it? You got no results? or not the right amount? SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM biblioitems Will give you biblionumber and the contents of 942c .. again only if your mysql server its 5.1.5 or greater Chris

1 0