[Koha] Internal Server Error after upgrading to Koha 20.05

[Fadhili Ngalawa]

Hello everyone,

First off all I would like to congratulate everyone involved in the
development of Koha up to this point of new release of version 20.05.

This morning I upgraded our office Koha production server from Koha 19.11.6
to the newly released version Koha 20.05.

After the upgrade, I managed to access the OPAC but failed to access staff
login page with “Internal Server Error” message.

I tried to do different options like restarting apache, upgrading schema
and rebuilding zebra even reboot the PC but all failed to solve the problem.

I kindly requesting for your assistance.

Regards,

Fadhili
From Tanzania
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] OPACXSLTResultsDisplay problem

[yeung yc]

Dear all,

I have a problem about changing the searching result page layout. I would
like to include all the marc framework information. However, I failed to
change from default to xslt stylesheet url. The searching result has no
material info at all.

I also tried to export the stylesheet and changed the name, then put it
back to the opac xslt directory. It doesnt work as well. I wonder is there
something I have missed after changing the code/file?

Thanks guys. Any help would be appreciated.
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Internal Server Error after upgrading to Koha 20.05

[Tomas Cohen Arazi]

Hi, can you give us more information?
- Operating system
- Any errors during the upgrade process (in the command line)
- Anything in the plack-error.log file?

Thanks

El sáb., 6 jun. 2020 a las 5:20, Fadhili Ngalawa ()
escribió:

> Hello everyone,
>
> First off all I would like to congratulate everyone involved in the
> development of Koha up to this point of new release of version 20.05.
>
> This morning I upgraded our office Koha production server from Koha 19.11.6
> to the newly released version Koha 20.05.
>
> After the upgrade, I managed to access the OPAC but failed to access staff
> login page with “Internal Server Error” message.
>
> I tried to do different options like restarting apache, upgrading schema
> and rebuilding zebra even reboot the PC but all failed to solve the
> problem.
>
> I kindly requesting for your assistance.
>
> Regards,
>
> Fadhili
> From Tanzania
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Error accessing "About Koha" after the upgrade. 20.5

[Victor Barroso Oliveira]

Good Morning,

Error accessing "About Koha" after the upgrade. 19.11.06 to 20.5

Software error:
Can't locate object method "structured_requirements_for_module" via package
"CPAN::Meta::Requirements" at
/usr/share/koha/lib/C4/Installer/PerlModules.pm line 66.

Can someone help me?
Thank you
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error accessing "About Koha" after the upgrade. 20.5

[Tomas Cohen Arazi]

In what OS?

El sáb., 6 jun. 2020 a las 9:05, Victor Barroso Oliveira (<
vbovic...@gmail.com>) escribió:

> Good Morning,
>
> Error accessing "About Koha" after the upgrade. 19.11.06 to 20.5
>
> Software error:
> Can't locate object method "structured_requirements_for_module" via package
> "CPAN::Meta::Requirements" at
> /usr/share/koha/lib/C4/Installer/PerlModules.pm line 66.
>
> Can someone help me?
> Thank you
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Internal Server Error after upgrading to Koha 20.05

[Fadhili Ngalawa]

Thanks, Tomas for your reply,

Operating System: Ubuntu 20.04
Errors during upgrade: None
plack-errors log file:
Use of uninitialized value in hash element at
/usr/share/koha/opac/cgi-bin/opac/opac-detail.pl line 689.
item-level_itypes set but no itemtype set for item (19879) at
/usr/share/koha/lib/Koha/Schema/Result/Item.pm line 770.
Use of uninitialized value in string comparison (cmp) at
/usr/share/koha/lib/C4/Items.pm line 760.
Use of uninitialized value $times in subtraction (-) at
/usr/share/koha/lib/C4/Search.pm line 1763.
Use of uninitialized value in concatenation (.) or string at
/usr/share/koha/opac/cgi-bin/opac/opac-MARCdetail.pl line 312.
Use of uninitialized value in concatenation (.) or string at
/usr/share/koha/opac/cgi-bin/opac/opac-MARCdetail.pl line 312.

I hope this will give an idea of what's wrong.

Regards,
Fadhili


On Sat, 6 Jun 2020 at 14:56, Tomas Cohen Arazi  wrote:

> Hi, can you give us more information?
> - Operating system
> - Any errors during the upgrade process (in the command line)
> - Anything in the plack-error.log file?
>
> Thanks
>
> El sáb., 6 jun. 2020 a las 5:20, Fadhili Ngalawa ()
> escribió:
>
>> Hello everyone,
>>
>> First off all I would like to congratulate everyone involved in the
>> development of Koha up to this point of new release of version 20.05.
>>
>> This morning I upgraded our office Koha production server from Koha
>> 19.11.6
>> to the newly released version Koha 20.05.
>>
>> After the upgrade, I managed to access the OPAC but failed to access staff
>> login page with “Internal Server Error” message.
>>
>> I tried to do different options like restarting apache, upgrading schema
>> and rebuilding zebra even reboot the PC but all failed to solve the
>> problem.
>>
>> I kindly requesting for your assistance.
>>
>> Regards,
>>
>> Fadhili
>> From Tanzania
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
> --
> Tomás Cohen Arazi
> Theke Solutions (http://theke.io)
> ✆ +54 9351 3513384
> GPG: B2F3C15F
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Internal Server Error after upgrading to Koha 20.05

[Tomas Cohen Arazi]

You need to do:

tail -f /var/log/koha//plack-error.log

and generate the Internal server error, then information about the internal
server error will show on the log. Those you pasted are normal warnings
about data not being 'perfect' on your MARC.



El sáb., 6 jun. 2020 a las 9:30, Fadhili Ngalawa ()
escribió:

> Thanks, Tomas for your reply,
>
> Operating System: Ubuntu 20.04
> Errors during upgrade: None
> plack-errors log file:
> Use of uninitialized value in hash element at
> /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl line 689.
> item-level_itypes set but no itemtype set for item (19879) at
> /usr/share/koha/lib/Koha/Schema/Result/Item.pm line 770.
> Use of uninitialized value in string comparison (cmp) at
> /usr/share/koha/lib/C4/Items.pm line 760.
> Use of uninitialized value $times in subtraction (-) at
> /usr/share/koha/lib/C4/Search.pm line 1763.
> Use of uninitialized value in concatenation (.) or string at
> /usr/share/koha/opac/cgi-bin/opac/opac-MARCdetail.pl line 312.
> Use of uninitialized value in concatenation (.) or string at
> /usr/share/koha/opac/cgi-bin/opac/opac-MARCdetail.pl line 312.
>
> I hope this will give an idea of what's wrong.
>
> Regards,
> Fadhili
>
>
> On Sat, 6 Jun 2020 at 14:56, Tomas Cohen Arazi 
> wrote:
>
>> Hi, can you give us more information?
>> - Operating system
>> - Any errors during the upgrade process (in the command line)
>> - Anything in the plack-error.log file?
>>
>> Thanks
>>
>> El sáb., 6 jun. 2020 a las 5:20, Fadhili Ngalawa ()
>> escribió:
>>
>>> Hello everyone,
>>>
>>> First off all I would like to congratulate everyone involved in the
>>> development of Koha up to this point of new release of version 20.05.
>>>
>>> This morning I upgraded our office Koha production server from Koha
>>> 19.11.6
>>> to the newly released version Koha 20.05.
>>>
>>> After the upgrade, I managed to access the OPAC but failed to access
>>> staff
>>> login page with “Internal Server Error” message.
>>>
>>> I tried to do different options like restarting apache, upgrading schema
>>> and rebuilding zebra even reboot the PC but all failed to solve the
>>> problem.
>>>
>>> I kindly requesting for your assistance.
>>>
>>> Regards,
>>>
>>> Fadhili
>>> From Tanzania
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>>
>> --
>> Tomás Cohen Arazi
>> Theke Solutions (http://theke.io)
>> ✆ +54 9351 3513384
>> GPG: B2F3C15F
>>
>

-- 
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error accessing "About Koha" after the upgrade. 20.5

[Mason James]

hi Victor,
try running the following commands...

sudo apt install libcpan-meta-requirements-perl
sudo koha-plack --restart


does this fix the problem?

cheers, Mason



On 7/06/20 12:04 am, Victor Barroso Oliveira wrote:

Good Morning,

Error accessing "About Koha" after the upgrade. 19.11.06 to 20.5

Software error:
Can't locate object method "structured_requirements_for_module" via package
"CPAN::Meta::Requirements" at
/usr/share/koha/lib/C4/Installer/PerlModules.pm line 66.

Can someone help me?
Thank you
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error accessing "About Koha" after the upgrade. 20.5

[Tomas Cohen Arazi]

He is on Ubuntu 16.

El sáb., 6 jun. 2020 a las 10:04, Mason James ()
escribió:

> hi Victor,
> try running the following commands...
>
> sudo apt install libcpan-meta-requirements-perl
> sudo koha-plack --restart
>
>
> does this fix the problem?
>
> cheers, Mason
>
>
>
> On 7/06/20 12:04 am, Victor Barroso Oliveira wrote:
> > Good Morning,
> >
> > Error accessing "About Koha" after the upgrade. 19.11.06 to 20.5
> >
> > Software error:
> > Can't locate object method "structured_requirements_for_module" via
> package
> > "CPAN::Meta::Requirements" at
> > /usr/share/koha/lib/C4/Installer/PerlModules.pm line 66.
> >
> > Can someone help me?
> > Thank you
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Unable to save

[Raphael Meyer]

I was going to add bar codes at 6 am this morning but got this error instead.
I had just upgraded to 20.05.



Can't open /var/log/koha/library/opac-error.log (Permission denied) at 
/usr/share/perl5/Log/Log4perl/Appender/File.pm line 151.

For help, please send mail to the webmaster ([no address 
given]), giving this error message and the 
time and date of the error.




What can I do?

Br Raphael
Prince of Peace Abbey
Oceanside CA
Sent from Mail for Windows 10

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How do Koha package updates work?

[Katrin Fischer]

Hi Dawson,

maybe some information on this page is helpful for you:

https://wiki.koha-community.org/wiki/Koha_on_Debian

I found no specific information on updates, but maybe someone else could
chime in?

Katrin

On 03.06.20 04:44, Dawson Weber wrote:

Hello All,

I have a Koha library for a personal collection and created the database in
March 2019 starting with, I believe, 18.5. I am not much of a tech person
but I was able to set up my library on Debian with Digital Ocean and did
the installation with packages.

Since then, it has updated to 18.11.03. I was curious if someone could
direct me to information about how the updates work and the timing of them
in relation to new releases and/or if I need to be facilitating the updates
manually.

Any information that could be shared would be appreciated.

Thank you for your help!
best regards,
Dawson Weber
Los Angeles
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unable to save

[Alvaro Cornejo]

Hi

You should give read/wite permissions to  your koha user to the mentioned
fiile. Even better, to the whole directory since koha will write all logs
to that folder

/var/log/koha/library/

Note that "library" is the instance name of your library.

Regards,

Alvaro
||
 Stay safe / Cuídate/  Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le sam. 6 juin 2020 à 08:14, Raphael Meyer  a écrit :

>
> I was going to add bar codes at 6 am this morning but got this error
> instead.
> I had just upgraded to 20.05.
>
>
>
> Can't open /var/log/koha/library/opac-error.log (Permission denied) at
> /usr/share/perl5/Log/Log4perl/Appender/File.pm line 151.
>
> For help, please send mail to the webmaster ([no address 
> given]),
> giving this error message and the time and date of the error.
>
>
>
>
> What can I do?
>
> Br Raphael
> Prince of Peace Abbey
> Oceanside CA
> Sent from Mail for
> Windows 10
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Software error:DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.library_groups' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 130

[Alvaro Cornejo]

Hi Francis

Take a  look onto this:

http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html

I used it a couple of monthns before to migrate from 17 to 19 version.

Also, try to always cc koha list so others can benefit from mail exchange
and also others can add ideas to your issue.

Regards

Alvaro
||
 Stay safe / Cuídate/  Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le ven. 5 juin 2020 à 21:33, Ashok Francis  a
écrit :

> Thanks for your reply Alvaro. Actually my hardisk crashed last two month
> before. I have taken a sql backup. When I tried to restore my old backup to
> new koha version. I got this error. I don't have idea of how to check the
> log details? Can you guide me?
> Thanks once again for your help
> Ashok.
>
> On Sat, 6 Jun 2020, 1:19 am Alvaro Cornejo, 
> wrote:
>
>> Hi Francis
>>
>> Do you have the log of the koha-upgrade-shema or the one from the
>> upgrade? There might be a tip on the cause of the error.
>>
>> Regards,
>>
>> Alvaro
>>
>> ||
>>  Stay safe / Cuídate/  Reste sécurisé
>> *7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et
>> à mesure.
>>  *q *Recycle always / Recicla siempre / Recyclez toujours
>>  P Print only if absolutely necessary / Imprime solo si es necesario /
>> Imprimez seulement si nécessaire
>>
>>
>> Le ven. 5 juin 2020 à 13:13, Ashok Francis 
>> a écrit :
>>
>>> Dear Professionals,
>>>
>>> I am new to koha. I was using koha17.05 on ubuntu mysql version 5.5.14.
>>> When I tried to update koha from 17.05 to 19.05, I got the following
>>> error
>>> message. I have updated  koha-upgrade-schema library also. But same error
>>> is appearing on the opac.
>>> Software error:
>>>
>>> DBIx::Class::Storage::DBI::_dbh_execute(): Table
>>> 'koha_library.library_groups' doesn't exist at
>>> /usr/share/koha/lib/Koha/Objects.pm line 130
>>>
>>> For help, please send mail to the webmaster ([no address given]), giving
>>> this error message and the time and date of the error.
>>>  I am in need of your help. I really appreciate your reply.
>>> Thanks,
>>> Ashok
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] OPACXSLTResultsDisplay problem

[Katrin Fischer]

Hi,

it's a little hard to tell what might have gone wrong there.

How did the URL look like that you tried? Where you able to access/see
the file entering that URL into your browser?

When you copied and renamed the file, what did you enter into the system
preferences? The file name alone will not work I think, at least we have
been using a path there although the file is in the same directory.

Paths will be different depending on how you installed. Did you use
packages?

Katrin

On 06.06.20 10:56, yeung yc wrote:

Dear all,

I have a problem about changing the searching result page layout. I would
like to include all the marc framework information. However, I failed to
change from default to xslt stylesheet url. The searching result has no
material info at all.

I also tried to export the stylesheet and changed the name, then put it
back to the opac xslt directory. It doesnt work as well. I wonder is there
something I have missed after changing the code/file?

Thanks guys. Any help would be appreciated.
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unable to save

[Dawson Weber]

Hi Alvaro,

Is it common to have to reset read/write permissions after an upgrade?

Thanks. best, Dawson

On Sat, Jun 6, 2020 at 12:33 PM Alvaro Cornejo 
wrote:

> Hi
>
> You should give read/wite permissions to  your koha user to the mentioned
> fiile. Even better, to the whole directory since koha will write all logs
> to that folder
>
> /var/log/koha/library/
>
> Note that "library" is the instance name of your library.
>
> Regards,
>
> Alvaro
>
> ||
>  Stay safe / Cuídate/  Reste sécurisé
> *7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
> mesure.
>  *q *Recycle always / Recicla siempre / Recyclez toujours
>  P Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le sam. 6 juin 2020 à 08:14, Raphael Meyer  a écrit :
>
> >
> > I was going to add bar codes at 6 am this morning but got this error
> > instead.
> > I had just upgraded to 20.05.
> >
> >
> >
> > Can't open /var/log/koha/library/opac-error.log (Permission denied) at
> > /usr/share/perl5/Log/Log4perl/Appender/File.pm line 151.
> >
> > For help, please send mail to the webmaster ([no address given] %5Bno%20address%20given%5D>),
> > giving this error message and the time and date of the error.
> >
> >
> >
> >
> > What can I do?
> >
> > Br Raphael
> > Prince of Peace Abbey
> > Oceanside CA
> > Sent from Mail for
> > Windows 10
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Coverflow installation problems

[Quỳnh Vũ Đỗ]

Hello everyone,
I am using a test database of our Library on Koha 19.11.06 (just
auto-upgraded from 19.11.05) on Ubuntu 16.04.6 LTS.
In the process of customizing the OPAC and installing the COverflow plugin
as described at:
https://bywatersolutions.com/education/coverflow-blog-post-update
I have created the sql report by copying and paste the described content on
that page:

Report SQL:

SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ‘ ‘, 1) AS isbn, b.title

FROM items i

LEFT JOIN biblioitems m USING (biblioitemnumber)

LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)

WHERE DATE_SUB(CURDATE(),INTERVAL 180 DAY) <= i.dateaccessioned AND
m.isbn IS NOT NULL AND m.isbn != ”

ORDER BY rand()

LIMIT 7


The only modification I have brought to the original code was to change the
INTERVAL from 30 DAY to 180 DAY as the last operation made on that database
was made on 25th February 2020.
On running the report I got the following error message:
"The database returned the following error:
Incorrect parameters in the call to native function 'substring_index'
Please check the log for further details"

So I checked the log at /var/log/koha/library/intranet-error.log which
indicated:

[Sun Jun 07 08:21:27.385286 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl: \r:
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.385426 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl:
LIMIT ?, ?" with ParamValues: 0=0, 1=7] at
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 1001.:
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.385605 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl:
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() [for
Statement "SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, \xe2\x80\x98
\xe2\x80\x98, 1) AS isbn, b.title\r:
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.385660 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl:
FROM items i\r: /usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl,
referer: http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.385745 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl:
LEFT JOIN biblioitems m USING (biblioitemnumber)\r:
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.385834 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl:
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)\r:
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.385966 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl:
WHERE DATE_SUB(CURDATE(),INTERVAL 180 DAY) <= i.dateaccessioned AND m.isbn
IS NOT NULL AND m.isbn != \xe2\x80\x9d\r:
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.386024 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl:
ORDER BY rand()\r: /usr/share/koha/intranet/cgi-bin/reports/
guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.386072 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl: \r:
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl
[Sun Jun 07 08:21:27.386321 2020] [cgi:error] [pid 30474] [client
127.0.0.1:39572] AH01215: [Sun Jun  7 08:21:27 2020] guided_reports.pl:
LIMIT ?, ?" with ParamValues: 0=0, 1=7] at
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 839.:
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl, referer:
http://localhost:8080/cgi-bin/koha/reports/guided_reports.pl

As I have limited knowledge in SQL coding, I am unsure of what to do (I
remember to have tested that SQL code with Koha 16.05 and it worked then).

Does anyone have met that problem and possibly have a hint for resolution?
Thanks
=
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération