date:20180612

Re: [Koha] EDS Plugin not loading

2018-06-12 Thread Liz Rea

Don't forget to restart apache and stuff after you add this. ;)


On 13/06/18 15:11, Liz Rea wrote:
> I have seen this, make sure you've got all of the apache configs for the
> EDS plugin in your /etc/apache2/sites-available/instance.conf. The ones
> that you're probably looking for are the ones that let you execcgi on
> that plugins directory, something like:
>
>    Alias /plugin/ "/var/lib/koha/instance/plugins/"
>
>    
>   Options ExecCGI
>   AddHandler cgi-script .pl
>   AllowOverride All
>   Require all granted
>    
>
> If you don't have this, the plugin will simply download the .pl over and
> over (and you probably won't notice that for at least 30 minutes or so
> because of the auto-close of that update-data button).
>
> Cheers,
>
> Liz
>
>
> On 08/06/18 07:09, Mohamed Negm wrote:
>> Yes the opacbaseurl filled out, and plugin doesn't return with any error, 
>> loading and not get any data
>>
>>
>>  Original Message 
>> Subject: Re: [Koha] EDS Plugin not loading
>> From: Nick Clemens
>> To: Mohamed Negm
>> CC: koha@lists.katipo.co.nz
>>
>>
>> Are the OPACBaseURL and staffclientbaseurl system preferences filled out?
>>
>> Does the plugin return any info in the settings box to indicate an error?
>>
>> On Fri, Jun 1, 2018 at 9:16 AM Mohamed Negm 
>> mailto:m.n...@live.com>> wrote:
>> Hi
>>
>> I’m trying to configure EBSCO EDS plugin into Koha 17.11, I filled out all 
>> require information in the plugin but when press loading data from EBSCO 
>> admin, nothing change, any suggestions
>>
>> Sent from 
>> Mail>
>>  for Windows 10
>>
>> ___
>> Koha mailing list  
>> http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> --
>> Nick Clemens
>> Sonic Screwdriver (Development Support)
>> ByWater Solutions
>> IRC: kidclamp
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] EDS Plugin not loading

2018-06-12 Thread Liz Rea

I have seen this, make sure you've got all of the apache configs for the
EDS plugin in your /etc/apache2/sites-available/instance.conf. The ones
that you're probably looking for are the ones that let you execcgi on
that plugins directory, something like:

   Alias /plugin/ "/var/lib/koha/instance/plugins/"

   
  Options ExecCGI
  AddHandler cgi-script .pl
  AllowOverride All
  Require all granted
   

If you don't have this, the plugin will simply download the .pl over and
over (and you probably won't notice that for at least 30 minutes or so
because of the auto-close of that update-data button).

Cheers,

Liz


On 08/06/18 07:09, Mohamed Negm wrote:
> Yes the opacbaseurl filled out, and plugin doesn't return with any error, 
> loading and not get any data
>
>
>  Original Message 
> Subject: Re: [Koha] EDS Plugin not loading
> From: Nick Clemens
> To: Mohamed Negm
> CC: koha@lists.katipo.co.nz
>
>
> Are the OPACBaseURL and staffclientbaseurl system preferences filled out?
>
> Does the plugin return any info in the settings box to indicate an error?
>
> On Fri, Jun 1, 2018 at 9:16 AM Mohamed Negm 
> mailto:m.n...@live.com>> wrote:
> Hi
>
> I’m trying to configure EBSCO EDS plugin into Koha 17.11, I filled out all 
> require information in the plugin but when press loading data from EBSCO 
> admin, nothing change, any suggestions
>
> Sent from 
> Mail>
>  for Windows 10
>
> ___
> Koha mailing list  
> http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> --
> Nick Clemens
> Sonic Screwdriver (Development Support)
> ByWater Solutions
> IRC: kidclamp
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

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

Re: [Koha] Plugin Error

2018-06-12 Thread Liz Rea

A few things here:

* do you have the plugin directory defined in koha-conf.xml, a la
/var/lib/koha/instance/plugins

* are the directories listed above owned and grouped into instance-koha
(instance will be the name of your instance)

* are the permissions correct for that directory *and* it's
subdirectories (for plugins, usually 755 is good)

Package installs, except in exceptional and highly non-standard
circumstances, don't use the www-data user. Use the system user
koha-create created for you, as that's what your instance is running
with (you can see the user it's using in
/etc/apache2/sites-available/instance.conf under AssignUserID)

I hope this helps.

Cheers,

Liz


On 13/06/18 08:13, Chris Brown wrote:
> Hi Satish,
>
> What you probably need to do is to change the ownership of the directories
> to be whatever user identity the apache server is running with. You can
> find this with a command like:
>
> # ps -ef  | grep apache
>
> On my Debian system the user is 'www-data'
>
> Then change the ownership of the directories accordingly.
>
> Hope this helps,
>
> Chris Brown
>
>
> On Tue, Jun 12, 2018 at 7:43 PM SATISH  wrote:
>
>> Hi,
>>
>> With Koha 17.11.06.000 On L-Ubuntu 16,04 Desktop from package installation
>> method,
>>
>> I am getting follwoing error while uploading .kpz file at  Home › Tools ›
>> Plugins.
>>
>>
>> *Cannot unpack file to the plugins directory.Please verify that the Apache
>> user can write to the plugins directory.*
>>
>> What is the right permission ??
>> .
>> As a root user, I have created plugins directory
>>
>> drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48
>> gechlibrary
>> drwxr-xr-x 2 root root 4096 Jun 12 17:28 plugins
>>
>> I tried to change,
>> chown -R gechlibrary-koha:gechlibrary-koha /var/lib/koha/plugins/
>>
>> drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48
>> gechlibrary
>> drwxr-xr-x 2 gechlibrary-koha gechlibrary-koha 4096 Jun 12 17:28 plugins
>>
>>
>> Alias /plugin/ "/var/lib/koha/plugins/" is updated in
>> /etc/apache2/sites-available/gechlibrary.conf
>>
>> In both cases, I am not able to to perform upload plugin.
>>
>> Please help.
>>
>> Satish MV
>> Librarian
>> Govt. Engineering College, Hassan
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142
04 803 2265

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7


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

Re: [Koha] SQL Report not populating

2018-06-12 Thread Barry, Michael M

I think I've found the source of the problem, I need to specify a ≥1 limitation 
on 'days overdue' in the box that comes up after running the report, leaving 
the box blank doesn't work.

Thanks again for the assistance.

Kind regards,

Michael Barry.

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Barry, Michael 
M
Sent: Wednesday, 13 June 2018 9:07 AM
To: koha
Subject: Re: [Koha] SQL Report not populating

Hi Mark,

I tried running a different saved report (made with the report wizard, to 
produce a list of patrons by categorycode and sort1 fields) and the results 
downloaded into the CSV and OpenDocument files fine, so I think it might be 
something I'm missing in my SQL code.

I replaced my WHERE line with your simplified version and the problem 
persisted. Opening the CSV file in Notepad yielded the same results: column 
headings were downloaded, the actual report results were not.

Thanks for your help,

Kind regards,
Michael Barry


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Mark Alexander
Sent: Wednesday, 13 June 2018 1:11 AM
To: koha
Subject: Re: [Koha] SQL Report not populating

I tried your query with the WHERE clause slightly simplified to give a 
non-empty result on my test installation of 18.05:

  WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= ''

I was then able to download the CSV file and read it into LibreOffice Calc with 
no problems.

So your query looks good; maybe take a look at the CSV file in an editor to see 
if there's anything strange about it.  Or perhaps you have to tell your CSV 
import tool to use commas, and not semicolons or other delimiters (LibreOffice 
has several options for this).
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha

IMPORTANT - This email and any attachments may be confidential. If received in 
error, please contact us and delete all copies. Before opening or using 
attachments check them for viruses and defects. Regardless of any loss, damage 
or consequence, whether caused by the negligence of the sender or not, 
resulting directly or indirectly from the use of any attached files our 
liability is limited to resupplying any affected attachments. Any 
representations or opinions expressed are those of the individual sender, and 
not necessarily those of the Department of Education and Training.
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha

IMPORTANT - This email and any attachments may be confidential. If received in 
error, please contact us and delete all copies. Before opening or using 
attachments check them for viruses and defects. Regardless of any loss, damage 
or consequence, whether caused by the negligence of the sender or not, 
resulting directly or indirectly from the use of any attached files our 
liability is limited to resupplying any affected attachments. Any 
representations or opinions expressed are those of the individual sender, and 
not necessarily those of the Department of Education and Training.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL Report not populating

2018-06-12 Thread Barry, Michael M

Hi Mark,

I tried running a different saved report (made with the report wizard, to 
produce a list of patrons by categorycode and sort1 fields) and the results 
downloaded into the CSV and OpenDocument files fine, so I think it might be 
something I'm missing in my SQL code.

I replaced my WHERE line with your simplified version and the problem 
persisted. Opening the CSV file in Notepad yielded the same results: column 
headings were downloaded, the actual report results were not.

Thanks for your help,

Kind regards,
Michael Barry


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Mark Alexander
Sent: Wednesday, 13 June 2018 1:11 AM
To: koha
Subject: Re: [Koha] SQL Report not populating

I tried your query with the WHERE clause slightly simplified to give a 
non-empty result on my test installation of 18.05:

  WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= ''

I was then able to download the CSV file and read it into LibreOffice Calc with 
no problems.

So your query looks good; maybe take a look at the CSV file in an editor to see 
if there's anything strange about it.  Or perhaps you have to tell your CSV 
import tool to use commas, and not semicolons or other delimiters (LibreOffice 
has several options for this).
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha

IMPORTANT - This email and any attachments may be confidential. If received in 
error, please contact us and delete all copies. Before opening or using 
attachments check them for viruses and defects. Regardless of any loss, damage 
or consequence, whether caused by the negligence of the sender or not, 
resulting directly or indirectly from the use of any attached files our 
liability is limited to resupplying any affected attachments. Any 
representations or opinions expressed are those of the individual sender, and 
not necessarily those of the Department of Education and Training.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Plugin Error

2018-06-12 Thread Chris Brown

Hi Satish,

What you probably need to do is to change the ownership of the directories
to be whatever user identity the apache server is running with. You can
find this with a command like:

# ps -ef  | grep apache

On my Debian system the user is 'www-data'

Then change the ownership of the directories accordingly.

Hope this helps,

Chris Brown


On Tue, Jun 12, 2018 at 7:43 PM SATISH  wrote:

> Hi,
>
> With Koha 17.11.06.000 On L-Ubuntu 16,04 Desktop from package installation
> method,
>
> I am getting follwoing error while uploading .kpz file at  Home › Tools ›
> Plugins.
>
>
> *Cannot unpack file to the plugins directory.Please verify that the Apache
> user can write to the plugins directory.*
>
> What is the right permission ??
> .
> As a root user, I have created plugins directory
>
> drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48
> gechlibrary
> drwxr-xr-x 2 root root 4096 Jun 12 17:28 plugins
>
> I tried to change,
> chown -R gechlibrary-koha:gechlibrary-koha /var/lib/koha/plugins/
>
> drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48
> gechlibrary
> drwxr-xr-x 2 gechlibrary-koha gechlibrary-koha 4096 Jun 12 17:28 plugins
>
>
> Alias /plugin/ "/var/lib/koha/plugins/" is updated in
> /etc/apache2/sites-available/gechlibrary.conf
>
> In both cases, I am not able to to perform upload plugin.
>
> Please help.
>
> Satish MV
> Librarian
> Govt. Engineering College, Hassan
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha used for asset inventory

2018-06-12 Thread Tim Atwood

Has anyone used Koha for asset inventory purposes?

-- 
Tim Atwood
Computer Systems Technician/
Grant Public Schools
tatw...@grantps.net
231.834.5910 x5398
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Plugin Error

2018-06-12 Thread Doug Dearden

Hi Satish,

What user does Apache run under?  On my Debian system the default is www-data.  
If that is the case on your Ubuntu system then I would do:
su chgrp www-data plugins
su chmod 775 plugins

I think that addresses the indicated problem.

Best,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of SATISH
Sent: Tuesday, June 12, 2018 12:43 PM
To: Koha 
Subject: [Koha] Plugin Error

Hi,

With Koha 17.11.06.000 On L-Ubuntu 16,04 Desktop from package installation
method,

I am getting follwoing error while uploading .kpz file at  Home › Tools ›
Plugins.


*Cannot unpack file to the plugins directory.Please verify that the Apache
user can write to the plugins directory.*

What is the right permission ??
.
As a root user, I have created plugins directory

drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48 gechlibrary
drwxr-xr-x 2 root root 4096 Jun 12 17:28 plugins

I tried to change,
chown -R gechlibrary-koha:gechlibrary-koha /var/lib/koha/plugins/

drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48 gechlibrary
drwxr-xr-x 2 gechlibrary-koha gechlibrary-koha 4096 Jun 12 17:28 plugins


Alias /plugin/ "/var/lib/koha/plugins/" is updated in
/etc/apache2/sites-available/gechlibrary.conf

In both cases, I am not able to to perform upload plugin.

Please help.

Satish MV
Librarian
Govt. Engineering College, Hassan
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Plugin Error

2018-06-12 Thread SATISH

Hi,

With Koha 17.11.06.000 On L-Ubuntu 16,04 Desktop from package installation
method,

I am getting follwoing error while uploading .kpz file at  Home › Tools ›
Plugins.


*Cannot unpack file to the plugins directory.Please verify that the Apache
user can write to the plugins directory.*

What is the right permission ??
.
As a root user, I have created plugins directory

drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48 gechlibrary
drwxr-xr-x 2 root root 4096 Jun 12 17:28 plugins

I tried to change,
chown -R gechlibrary-koha:gechlibrary-koha /var/lib/koha/plugins/

drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48 gechlibrary
drwxr-xr-x 2 gechlibrary-koha gechlibrary-koha 4096 Jun 12 17:28 plugins


Alias /plugin/ "/var/lib/koha/plugins/" is updated in
/etc/apache2/sites-available/gechlibrary.conf

In both cases, I am not able to to perform upload plugin.

Please help.

Satish MV
Librarian
Govt. Engineering College, Hassan
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL report with Comma Delimited Paramater

2018-06-12 Thread Barton Chittenden

Yes, that's the one. Thanks!

On Tue, Jun 12, 2018 at 7:31 AM, Magnus Enger  wrote:

> On 6 June 2018 at 15:17, Barton Chittenden 
> wrote:
> > This is not currently possible, but if you check the bywatersolutions
> > github page, you can find a plugin called 'koha-plugin-reports-plus', or
> > something similar (on mobile, or I'd link to it). That plugin will allow
> > you to add a parameter that lets you enter a list.
>
> Probably this one? https://github.com/bywatersolutions/koha-plugin-
> reports-plus
>
> I have added it to https://wiki.koha-community.org/wiki/Koha_plugins
>
> Best regards,
> Magnus
> Libriotech
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Zebra - less logging

2018-06-12 Thread Andreas Roussos

Hi Tom,

Have a look at the  directive in
/etc/koha/sites//koha-conf.xml
The default value is "none,fatal,warn", but perhaps at some point it was
changed to something more verbose in your installation? (which would
explain the very large log files).

HTH,
Andreas

On 11 June 2018 at 16:24, Tom Hanstra  wrote:

> Does anyone with Zebra knowledge know how to scale back the amount of
> logging which takes place. I'm still running Zebra for indexing with V17.11
> and finding the logs are very large each day. I'd like to scale back
> logging so I only get errors logged.
>
> How might that be done?
>
> Thanks,
> Tom
>
> --
> *Tom Hanstra*
> *Sr. Systems Administrator*
> hans...@nd.edu
>
> 
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL Report not populating

2018-06-12 Thread Mark Alexander

I tried your query with the WHERE clause slightly simplified to
give a non-empty result on my test installation of 18.05:

  WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= ''

I was then able to download the CSV file and read it into LibreOffice
Calc with no problems.

So your query looks good; maybe take a look at the CSV file in
an editor to see if there's anything strange about it.  Or perhaps
you have to tell your CSV import tool to use commas, and not semicolons
or other delimiters (LibreOffice has several options for this).
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration problem

2018-06-12 Thread Przemek Kosiński


Hi Jonathan,
In version 17.11.05 there was no problem when I tried to import the 
base. Everthing was ok.


The problem appeared in 17.11.06. The solution proposed by Jon Turner 
works very well:

Execute two queries in mysql:

CREATE TABLE IF NOT EXISTS club_enrollments (
  id int(11) NOT NULL AUTO_INCREMENT,
  club_id int(11) NOT NULL,
  borrowernumber int(11) NOT NULL,
  date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  date_canceled timestamp NULL DEFAULT NULL,
  date_created timestamp NULL DEFAULT NULL,
  date_updated timestamp NULL DEFAULT NULL,
  branchcode varchar(10) NULL DEFAULT NULL,
  PRIMARY KEY (id),
  KEY club_id (club_id),
  KEY borrowernumber (borrowernumber),
  KEY branchcode (branchcode),
  CONSTRAINT club_enrollments_ibfk_1 FOREIGN KEY (club_id) 
REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT club_enrollments_ibfk_2 FOREIGN KEY 
(borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE 
ON UPDATE CASCADE,
  CONSTRAINT club_enrollments_ibfk_3 FOREIGN KEY (branchcode) 
REFERENCES branches (branchcode) ON DELETE SET NULL ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS club_enrollment_fields (
  id int(11) NOT NULL AUTO_INCREMENT,
   club_enrollment_id int(11) NOT NULL,
   club_template_enrollment_field_id int(11) NOT NULL,
   `value` text NOT NULL,
   PRIMARY KEY (id),
   KEY club_enrollment_id (club_enrollment_id),
   KEY club_template_enrollment_field_id 
(club_template_enrollment_field_id),
   CONSTRAINT club_enrollment_fields_ibfk_1 FOREIGN KEY 
(club_enrollment_id) REFERENCES club_enrollments (id) ON DELETE CASCADE 
ON UPDATE CASCADE,
   CONSTRAINT club_enrollment_fields_ibfk_2 FOREIGN KEY 
(club_template_enrollment_field_id) REFERENCES 
club_template_enrollment_fields (id) ON DELETE CASCADE ON UPDATE CASCADE

 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

With the koha schema update there were no problems or errors.

I have'nt any tables with club*

Migrate was very simple - on old server I dump with koha-dump data from 
database koha 3.20  -> on new server (Ubuntu 16.04) I cerated new 
instance koha and import from file database.sql to new base.
Then I run koha-update-schema and run koha-rebulid-zebra. That's all. In 
koha 17.11.05 work without problems in 17.11.06 two trys and two failed.



Redgards,
Przemek
W dniu 12.06.2018 o 14:52, Jonathan Druart pisze:

Hi,

The table club_enrollments has been added in 16.12.00.027
Do you have other tables with names starting with club_*?

How did you migrate? Are you sure there were no errors during the DB 
upgrade process?


Regards,
Jonathan


On Tue, 12 Jun 2018 at 06:48 Przemek Kosiński 
mailto:p.kosin...@biblioteka24.eu>> wrote:


Hi everyone,

I tried to do a base migration from 3.20 to 17.11.06. The conversion of
the database to the new schema and indexation has gone ok - everything
works except the possibility of a full preview of the patron - after
choosing one they receive such an error:

Template process failed: undef error -
DBIx::Class::Storage::DBI::_dbh_execute(): Table
'koha_biblio-main.club_enrollments' doesn't exist at
/usr/share/koha/lib/Koha/Objects.pm line 269

I did two attempts and this problem appeared every time.

System: Ubuntu 16.04LTS
DataBase: MariaDB 10.0.34
Plack not enabled - when enable plack I get an error: Internal
Server Error

In the version of koha 17.11.05 there was no such error - the earlier
attempt to migrate to this version was successful.

I have a question about what I can do about it.
Alternatively, how to withdrawal to an earlier version 17.11.05 to
check
whether this error can be invoked.

Best regards
Przemek Kosiński

-- 
*

Powiatowa i Miejska Biblioteka
Publiczna w Skarżysku-Kamiennej
www: www.biblioteka24.eu 
mail: p.kosin...@biblioteka24.eu 
*
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha




--
*
Powiatowa i Miejska Biblioteka
Publiczna w Skarżysku-Kamiennej
www: www.biblioteka24.eu
mail: p.kosin...@biblioteka24.eu
*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Software error

2018-06-12 Thread Jonathan Druart

Hi Sahadeo,

This table has been added on 17.12.00.007, did you see any errors during
the DB upgrade?

Regards,
Jonathan

On Sat, 9 Jun 2018 at 08:02 Sahadeo Taware  wrote:

> I am updating koha software from 17.11 to 18.
>
> it gives the error
> 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 129
>
> For help, please send mail to the webmaster ([no address given]), giving
> this error message and the time and date of the error.
>
>
> --
> Sahadeo D. Taware
> Librarian, M.L.I.Sc., NET
> Thakur College of Science and Commerce
> Thakur Village, Kandivli(E), Mumbai 400101
> Mob. No 9324912816
> Office 28870627 Extn. 126
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration problem

2018-06-12 Thread Jonathan Druart

Hi,

The table club_enrollments has been added in 16.12.00.027
Do you have other tables with names starting with club_*?

How did you migrate? Are you sure there were no errors during the DB
upgrade process?

Regards,
Jonathan


On Tue, 12 Jun 2018 at 06:48 Przemek Kosiński 
wrote:

> Hi everyone,
>
> I tried to do a base migration from 3.20 to 17.11.06. The conversion of
> the database to the new schema and indexation has gone ok - everything
> works except the possibility of a full preview of the patron - after
> choosing one they receive such an error:
>
> Template process failed: undef error -
> DBIx::Class::Storage::DBI::_dbh_execute(): Table
> 'koha_biblio-main.club_enrollments' doesn't exist at
> /usr/share/koha/lib/Koha/Objects.pm line 269
>
> I did two attempts and this problem appeared every time.
>
> System: Ubuntu 16.04LTS
> DataBase: MariaDB 10.0.34
> Plack not enabled - when enable plack I get an error: Internal Server Error
>
> In the version of koha 17.11.05 there was no such error - the earlier
> attempt to migrate to this version was successful.
>
> I have a question about what I can do about it.
> Alternatively, how to withdrawal to an earlier version 17.11.05 to check
> whether this error can be invoked.
>
> Best regards
> Przemek Kosiński
>
> --
> *
> Powiatowa i Miejska Biblioteka
> Publiczna w Skarżysku-Kamiennej
> www: www.biblioteka24.eu
> mail: p.kosin...@biblioteka24.eu
> *
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL report with Comma Delimited Paramater

2018-06-12 Thread Magnus Enger

On 6 June 2018 at 15:17, Barton Chittenden  wrote:
> This is not currently possible, but if you check the bywatersolutions
> github page, you can find a plugin called 'koha-plugin-reports-plus', or
> something similar (on mobile, or I'd link to it). That plugin will allow
> you to add a parameter that lets you enter a list.

Probably this one? https://github.com/bywatersolutions/koha-plugin-reports-plus

I have added it to https://wiki.koha-community.org/wiki/Koha_plugins

Best regards,
Magnus
Libriotech
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Migration problem

2018-06-12 Thread Przemek Kosiński


Hi everyone,

I tried to do a base migration from 3.20 to 17.11.06. The conversion of 
the database to the new schema and indexation has gone ok - everything 
works except the possibility of a full preview of the patron - after 
choosing one they receive such an error:


Template process failed: undef error - 
DBIx::Class::Storage::DBI::_dbh_execute(): Table 
'koha_biblio-main.club_enrollments' doesn't exist at 
/usr/share/koha/lib/Koha/Objects.pm line 269


I did two attempts and this problem appeared every time.

System: Ubuntu 16.04LTS
DataBase: MariaDB 10.0.34
Plack not enabled - when enable plack I get an error: Internal Server Error

In the version of koha 17.11.05 there was no such error - the earlier 
attempt to migrate to this version was successful.


I have a question about what I can do about it.
Alternatively, how to withdrawal to an earlier version 17.11.05 to check 
whether this error can be invoked.


Best regards
Przemek Kosiński

--
*
Powiatowa i Miejska Biblioteka
Publiczna w Skarżysku-Kamiennej
www: www.biblioteka24.eu
mail: p.kosin...@biblioteka24.eu
*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] EDS Plugin not loading

Re: [Koha] EDS Plugin not loading

Re: [Koha] Plugin Error

Re: [Koha] SQL Report not populating

Re: [Koha] SQL Report not populating

Re: [Koha] Plugin Error

[Koha] Koha used for asset inventory

Re: [Koha] Plugin Error

[Koha] Plugin Error

Re: [Koha] SQL report with Comma Delimited Paramater

Re: [Koha] Zebra - less logging

Re: [Koha] SQL Report not populating

Re: [Koha] Migration problem

Re: [Koha] Software error

Re: [Koha] Migration problem

Re: [Koha] SQL report with Comma Delimited Paramater

[Koha] Migration problem

17 matches

Site Navigation

Mail list logo

Footer information