date:20200607

Re: [Koha] Coverflow installation problems

2020-06-07 Thread Alvaro Cornejo

Hi Quỳnh,

There were a couple of errors in your query.

Try this:

-
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
--

I´ve tried in my system (19.11) system and it works now.

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 à 20:51, Quỳnh Vũ Đỗ  a
écrit :

> 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

Re: [Koha] Unable to save

2020-06-07 Thread Alvaro Cornejo

Hi Dawson,

I´m not expert in koha, and can´t confirm you this. Personally, is the
first time I see this.

As is a brand new version, it might be a bug in the upgrade process.

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 à 19:04, Dawson Weber  a écrit :

> 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

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

2020-06-07 Thread Ashok Francis

Thanks for your information, Alvaro.
Ashok.

On Sun, Jun 7, 2020 at 1:05 AM Alvaro Cornejo 
wrote:

> 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] Coverflow installation problems

Re: [Koha] Unable to save

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

3 matches

Site Navigation

Mail list logo

Footer information