Re: [Koha] debian upgrade error
To "solve" this issue I downgraded to koha 3.8. That's the best I could do! So, in my opinion if you want to have koha working try the 3.8 version On Mon, Feb 18, 2013 at 8:17 PM, davidlamhauge wrote: > I have the same problem with a fresh koha 3.10.02 installation on my 12.04 > ubuntu server. > I get this "Can't call method "raw" on an undefined value at > /usr/share/koha/lib/C4/Search.pm line 471" error, and I can't get further. > Re-indexing has not helped. > > David > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/debian-upgrade-error-tp5740894p5742897.html > Sent from the Koha-general mailing list archive at Nabble.com. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.12-alpha2
Hello. I have released a second alpha of Koha 3.12. This includes a number of bugfixes, including a high-priority bug fix to the search error problem reported on the list. Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha Help
Dear All, I have previously sent a question about koha 3.10.03 but did not get any feedback. I have installed another version of Koha 3.08.10 maybe this would solve the problems I am having but in vain! I will show one of the problems and I hope I can get a proposed solution for this: 1- When I go to the MARC frameworks page (under Administration--> Marc Frameworks), I get the list of frameworks with the first two columns left empty (Code & Description). 2- If I click on any “Marc Structure” link, I get redirected to the list of fields in the structure but also the columns are empty (Tag, Lib, etc…). But note that the drop down “In framework” found in this page shows the list of frameworks with their names. 3- If I try to create a new catalog (More --> Cataloging --> New Record) and select any of the available frameworks, the page refreshes but does not show the list of fields to be filled. I really would like to know your input regarding these problems. It might be a database problem or a simple missing settings while installing. Your help is very much appreciated. Best Regards, Layale. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Help
Dear Layale, which language do you use during installation ? Which MARC ? Your problem with marc framwork are quite strange. Bye Zeno Tajoli -- Dr. Zeno Tajoli Dipartimento Gestione delle Informazioni e della Conoscenza z.taj...@cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Help
Hello Bassil, it may be a problem of the database. Do you perform a new installation? If yes you can try to delete the database and make a new one, then redo the installation of Koha via the Web Interface, and install all the samples (framework, patron, etc...). Regards Sander -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Help-tp5746880p5746882.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Help
Hello Sander, Well thanks a lot for your reply. You are right, I guess it is a database issue. In fact I got the Koha 3.8 version from this link: http://download.koha-community.org/koha-3.08.10.tar.gz. Someone helped me installing it. Can you please just explain to me how can I delete the database and make a new one and use the Web Interface to redo the installation and from where I can install all the samples? Thanks again. Regards. Layale Bassil Software Engineer – Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649 | M: +961 (03) 929876 E: l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen… Save a Tree... -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Sander898 Sent: Wednesday, March 20, 2013 5:15 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha Help Hello Bassil, it may be a problem of the database. Do you perform a new installation? If yes you can try to delete the database and make a new one, then redo the installation of Koha via the Web Interface, and install all the samples (framework, patron, etc...). Regards Sander -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Help-tp5746880p5746882.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Help
Hello Layale, if you are not familiar with MySQL I suggest you to install PhpMyAdmin to manage the database on the server. http://www.phpmyadmin.net/home_page/downloads.php >From PhpMyAdmin you can see the database for Koha, you can delete and make a new one. You must see the file /etc/koha/koha-conf.xml for the name, and the username and password of the database. Once you have create the new database you have to go to https://domaniname:8080 (login with the usename and the password of the database) and follow the step for the Web Installation, here the wizard ask you to install all the samples. Regards Sander -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Help-tp5746880p5746890.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] SQL runs outside of staff client but not inside it
Hello all, I am working on some SQL to get a report for last month's acquisitions, and worked up the following code to do it: SELECT MONTH(CURDATE()) INTO @curmonth; SELECT MONTH(CURDATE())-1 INTO @lastmonth; SELECT YEAR(CURDATE()) INTO @reportyear; SELECT YEAR(CURDATE())-1 INTO @lastmnthyear; SELECT IF (@curmonth=1, 12, @lastmonth) into @lastmonth; SELECT IF (@curmonth=1, @lastmnthyear, @reportyear) into @reportyear; SELECT CONCAT(@reportyear,"-",@lastmonth,"-01") into @begindate; SELECT LAST_DAY(@begindate) into @enddate; SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') as "Title:", EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="b"]') as subtitle, EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="c"]') as "statement of responsibility", EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="b"]') as Publisher, EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="c"]') as Date, EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="a"]') as "Call Number first part", EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="b"]') as "Call Number second part", items.dateaccessioned as "Date Accessioned" FROM biblioitems LEFT JOIN items on (biblioitems.biblioitemnumber=items.biblioitemnumber) WHERE items.dateaccessioned BETWEEN @begindate and @enddate ORDER BY items.dateaccessioned asc If I put this in a text file on the server, and call it using mysql it runs fine. When I put it into an SQL report on the staff client it fails with this error: "Can't use an undefined value as an ARRAY reference at /usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 766" Looking at that line in guided_reports.pl it is where the column headings are being loaded into an array. The problem definitely lies in the first half of the code where I am loading date information into variables to build the begin and end dates. If that code is removed and actual dates entered for the BETWEEN values the report runs fine in the staff client. If the answer here is that it isn't going to run in the staff client, I can set it up to run on the server and create a cron job to automate it. If that is the case should I open a bug for this, or am I getting outside of the scope of the guided reports tool to begin with? Koha 3.10.0 on Debian Squeeze . Thanks, Doug Dearden Director, IT School for Advanced Research sarweb.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL runs outside of staff client but not inside it
Hi, On Wed, Mar 20, 2013 at 8:50 AM, Doug Dearden wrote: > The problem definitely lies in the first half of the code where I am loading > date information into variables to build the begin and end dates. If that > code is removed and actual dates entered for the BETWEEN values the report > runs fine in the staff client. The guided reports module has support for placeholders, detailed here: http://manual.koha-community.org/3.10/en/reportsfaq.html#runtimefaq In your specific example, if you were always basing the criteria on the current day, you could likely construct expressions for the WHERE clause that had the desired effect without needing variables or parameters. > If the answer here is that it isn't going to run in the staff client, I can > set it up to run on the server and create a cron job to automate it. If that > is the case should I open a bug for this, or am I getting outside of the > scope of the guided reports tool to begin with? It's pushing the scope of the guided reports tool, since one of its design points is attempting to prevent the user from constructing SQL statements that could update, delete, or otherwise damage the database. Multi-line statements would be harder to evaluate. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: g...@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web:http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Help
On Wed, Mar 20, 2013 at 11:34 AM, Sander898 wrote: > From PhpMyAdmin you can see the database for Koha, you can delete and make a > new one. To elaborate, it is being suggested that you drop your Koha database and reinstall it because a missing default framework indicates some kind of problem with the original installation process. It is most definitely not a problem with 3.10.x that will be fixed by downgrading to 3.8.x. If you have just started using Koha and it is safe to start your database over from scratch it might be a good idea. Another option is to import the default framework manually, but if something went wrong with your installation there might be other problems with your database which haven't surfaced. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL runs outside of staff client but not inside it
Doug: You wrote: >I am working on some SQL to get a report for last month's acquisitions, and >worked up the following code to do it: [...snip...] A couple of the SQL Reports posted on the wiki have a WHERE clause that purportedly limits to the previous month. Would something like the following work? SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') as "Title:", EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="b"]') as subtitle, EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="c"]') as "statement of responsibility", EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="b"]') as Publisher, EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="c"]') as Date, EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="a"]') as "Call Number first part", EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="b"]') as "Call Number second part", items.dateaccessioned as "Date Accessioned" FROM biblioitems LEFT JOIN items on (biblioitems.biblioitemnumber=items.biblioitemnumber) WHERE items.dateaccessioned >= concat(date_format(LAST_DAY(now() - interval 1 month),'%Y-%m-'),'01') AND items.dateaccessioned <= LAST_DAY(now() - interval 1 month) ORDER BY items.dateaccessioned asc; --Robert * Robert L. Williams Open Source Services Manager Amigos Library Services, Inc. 14400 Midway Road Dallas, TX 75244-3509 800-843-8482, x2870 972-340-2870 (direct) 972-991-6061 (fax) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL runs outside of staff client but not inside it
Thanks Robert, that did it. A much more elegant solution than mine also. I checked the wiki before I started this but didn't find that report. Best - Doug -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Robert Williams Sent: Wednesday, March 20, 2013 10:19 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] SQL runs outside of staff client but not inside it Doug: You wrote: >I am working on some SQL to get a report for last month's acquisitions, and >worked up the following code to do it: [...snip...] A couple of the SQL Reports posted on the wiki have a WHERE clause that purportedly limits to the previous month. Would something like the following work? SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') as "Title:", EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="b"]') as subtitle, EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="c"]') as "statement of responsibility", EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="b"]') as Publisher, EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="c"]') as Date, EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="a"]') as "Call Number first part", EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="b"]') as "Call Number second part", items.dateaccessioned as "Date Accessioned" FROM biblioitems LEFT JOIN items on (biblioitems.biblioitemnumber=items.biblioitemnumber) WHERE items.dateaccessioned >= concat(date_format(LAST_DAY(now() - interval 1 month),'%Y-%m-'),'01') AND items.dateaccessioned <= LAST_DAY(now() - interval 1 month) ORDER BY items.dateaccessioned asc; --Robert * Robert L. Williams Open Source Services Manager Amigos Library Services, Inc. 14400 Midway Road Dallas, TX 75244-3509 800-843-8482, x2870 972-340-2870 (direct) 972-991-6061 (fax) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Help
Hi Also in your original mail you said you hadn't found the documentation, you had seen http://koha-community.org/documentation/ right? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Error on Author serches after upgrade from 3.8.10 to 3.10.3
Hello im having problems with the authorities search after upgrade. the error is Software error: Can't call method "raw" on an undefined value at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 338. this only happens if the record exists. i just did /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -a -v to rebuild the zebra. -- View this message in context: http://koha.1045719.n5.nabble.com/Error-on-Author-serches-after-upgrade-from-3-8-10-to-3-10-3-tp5746302.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Problem with Koha Catalog search
Hii, I recently installed Koha 3.8.06. I have uploaded some records for testing but when I search for the record in the catalog search bar (staff side) and OPAC search bar, it gives me no results. Regards, Salman ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
