Re: [Koha] invalid marcxml

Bug 21708 fix is not available in this case unless the file is changed manually, or the version upgraded. It's not included in 18.11. On Fri, May 15, 2020 at 3:41 AM Marcel de Rooy wrote: > When you open and save a record again in Koha having patch 21708, the MARC > record will be fixed. > There

[Koha] tiny bit of help needed with report

Hello I apologise for the simplicity of this question but could really use some help. I want to use the Hourly report in the KOHA wiki for ‘Checkouts by Hour in Selected Date Range’ as below SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS Month, DAY(statistics.datetime)

Re: [Koha] tiny bit of help needed with report

Hi Lisa, If you're just looking to use the branch column in statistics you can add it to your select list and then to the group by. So the select line would become something like this: SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS Month, DAY(statistics.datetime) AS Day,

Re: [Koha] tiny bit of help needed with report

Thanks Rogan, that was perfect!! Lisa Mrs Lisa Peel Head of Learning Resources, SEG Services Swiss Education Group Avenue des Alpes 62 CH-1820 Montreux, Switzerland Mobile: +41 (0)79 228 0151 Skype: biblio1897 www.swisseducation.com Facebook

[Koha] Staff login problems after upgrading from Koha 3.18 to 19.11

Hello everyone, Our library has been using a Vietnamized version of Koha 3.18 since mid 2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been made since and the server had a hardware problem (mainboard) last February. In an attempt to restore the Koha 3.18 database (a dump sql

Re: [Koha] tiny bit of help needed with report

Hello Lisa, You may try following: SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS Month, DAY(statistics.datetime) AS Day, HOUR(statistics.datetime) AS Hour, count(*) AS Checkouts FROM statistics left join items on statistics.itemnumber=items.itemnumber WHERE statistics.dat

Re: [Koha] Staff login problems after upgrading from Koha 3.18 to 19.11

Hi, this sounds similar to a problem I ran into recently upgrading a 3.20 database to 19.11. You’ll probably have to do the drop/re-import procedure at least 2 more times to fix this, but doing this should help: Instead of using the web interface, after re-importing the 3.18 database use koha-u

Re: [Koha] Staff login problems after upgrading from Koha 3.18 to 19.11

Hi, Vào Th 6, 15 thg 5, 2020 vào lúc 22:25 Jason Boyer < jbo...@equinoxinitiative.org> đã viết: > Hi, this sounds similar to a problem I ran into recently upgrading a 3.20 > database to 19.11. You’ll probably have to do the drop/re-import procedure > at least 2 more times to fix this, but doin

[Koha] Opac not searchable after upgrading database from Koha 3.18 to 19.11

Hello everyone After upgrading a Koha database from version 3.18 to 19.11, I was not able to log in in the staff/administration of Koha as I obtained a "Software Error" message. However, I was able to get to the OPAC page (at http://localhost:8000/) but any search returned nothing. I checked with

Re: [Koha] Staff login problems after upgrading from Koha 3.18 to 19.11

Replies inline below > On May 15, 2020, at 12:48 PM, Quỳnh Vũ Đỗ wrote: > > Hi, > > > Vào Th 6, 15 thg 5, 2020 vào lúc 22:25 Jason Boyer > mailto:jbo...@equinoxinitiative.org>> đã viết: > Hi, this sounds similar to a problem I ran into recently upgrading a 3.20 > database to 19.11. You’ll