[Koha] Newbie question concerning system maintenance

2021-01-19 Thread Andreas Tomiak
Hello, I´ve tried to find some information in koha´s documentation, but I failed to find anything usable. Sorry for my question: Does Koha have a common way (script?) to update it to newer versions or do I have to make a new installation of it, configure it and reinstall the previous dumped

Re: [Koha] Newbie question concerning system maintenance

2021-01-19 Thread Magnus Enger
Hi! Den 19.01.2021 09:26, skrev Andreas Tomiak: Hello, I´ve tried to find some information in koha´s documentation, but I failed to find anything usable. Sorry for my question: Does Koha have a common way (script?) to update it to newer versions or do I have to make a new installation of it

Re: [Koha] SQL Report Coding need.

2021-01-19 Thread Martha Fuerst
Assuming you’re running 19.11 or later, accounttype got changed to credit_type_code and debit_type_code. SELECT CONCAT("http://boraccount.pl/?borrowernumber=>", T1.borrowernumber, "\" target=\"_blank\">View Transaction") AS 'Click to view' , DATE_FORMAT(DATE(T1.timestamp), "%d/%m/%Y") AS '