Re: [Koha] Error while editing item on migrated instance

[DHIM IT]

It was my fault. Please ignore.


Am 18.05.23, 10:49 schrieb "Koha im Auftrag von DHIM IT" 
mailto:koha-boun...@lists.katipo.co.nz> im 
Auftrag von itmana...@dhi-moskau.org <mailto:itmana...@dhi-moskau.org>>:


Dear colleagues,


I migrated koha db to a new server with fresh installed instance. Everything 
working fine. I have only one error while editing items:




[WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st 
execute failed: The user specified as a definer ('root'@'%') does not exist at 
/usr/share/koha/lib/Koha/Object.pm line 170


Does anybody know what can I do to solve it?


KOHA 22.05
Debian 11


Mit besten Grüßen
IT-Manager
Eugen Bastron


___


Koha mailing list http://koha-community.org <http://koha-community.org>
Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
<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] Error while editing item on migrated instance

[DHIM IT]

Dear colleagues,

I migrated koha db to a new server with fresh installed instance. Everything 
working fine. I have only one error while editing items:


[WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st 
execute failed: The user specified as a definer ('root'@'%') does not exist at 
/usr/share/koha/lib/Koha/Object.pm line 170

Does anybody know what can I do to solve it?

KOHA 22.05
Debian 11

Mit besten Grüßen
IT-Manager
Eugen Bastron

___

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

Re: [Koha] Can't connect to local MySQL server through socket

[DHIM IT]

Hello again,

after I run the command sudo koha-mysql koha , the cron working again without 
any error. Thank you!


Am 18.04.23, 09:21 schrieb "Koha im Auftrag von DHIM IT" 
mailto:koha-boun...@lists.katipo.co.nz> im 
Auftrag von itmana...@dhi-moskau.org <mailto:itmana...@dhi-moskau.org>>:


Hello, yes, without any error. 




Am 18.04.23, 07:12 schrieb "Mason James" mailto:m...@kohaaloha.com> <mailto:m...@kohaaloha.com 
<mailto:m...@kohaaloha.com>>>:




hi Eugen




you probably have a config problem with your 'koha' instance








does the following command succeed?




$ sudo koha-mysql koha












On 17/04/23 7:25 pm, DHIM IT wrote:
> Dear Collogues,
> 
> for two weeks I get an every 2-5 minute error from the cron below. I can run 
> the commands from the cron without a problem. Also, I can connect to my 
> database without a problem. Any ideas?
> 
> 
> Best regards,
> Eugen Bastron
> 
> 
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) 
> failed: Can't connect to local MySQL server through socket 
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by 
> "/usr/share/koha/bin/cronjobs/process_message_queue.pl"
> 
> /etc/cron.hourly/koha-common:
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) 
> failed: Can't connect to local MySQL server through socket 
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by 
> "/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl"
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) 
> failed: Can't connect to local MySQL server through socket 
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by 
> "/usr/share/koha/bin/cronjobs/automatic_checkin.pl"
> 
> 
> 
> ___
> 
> Koha mailing list http://koha-community.org <http://koha-community.org> 
> <http://koha-community.org> <http://koha-community.org;>
> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> 
> <mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>>
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
> <https://lists.katipo.co.nz/mailman/listinfo/koha> 
> <https://lists.katipo.co.nz/mailman/listinfo/koha> 
> <https://lists.katipo.co.nz/mailman/listinfo/koha;>










___


Koha mailing list http://koha-community.org <http://koha-community.org>
Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
<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] Can't connect to local MySQL server through socket

[DHIM IT]

Hello, yes, without any error. 
 

Am 18.04.23, 07:12 schrieb "Mason James" mailto:m...@kohaaloha.com>>:


hi Eugen


you probably have a config problem with your 'koha' instance




does the following command succeed?


$ sudo koha-mysql koha






On 17/04/23 7:25 pm, DHIM IT wrote:
> Dear Collogues,
> 
> for two weeks I get an every 2-5 minute error from the cron below. I can run 
> the commands from the cron without a problem. Also, I can connect to my 
> database without a problem. Any ideas?
> 
> 
> Best regards,
> Eugen Bastron
> 
> 
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) 
> failed: Can't connect to local MySQL server through socket 
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by 
> "/usr/share/koha/bin/cronjobs/process_message_queue.pl"
> 
> /etc/cron.hourly/koha-common:
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) 
> failed: Can't connect to local MySQL server through socket 
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by 
> "/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl"
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
> connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) 
> failed: Can't connect to local MySQL server through socket 
> '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 
> 91. at /usr/share/koha/lib/Koha/Database.pm line 139
> koha: 111 status returned by 
> "/usr/share/koha/bin/cronjobs/automatic_checkin.pl"
> 
> 
> 
> ___
> 
> Koha mailing list http://koha-community.org <http://koha-community.org>
> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
> <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] Can't connect to local MySQL server through socket

[DHIM IT]

Hello !


Koha 22.05.10.000 on debian 11.

Best regards
Eugen Bastron


Von: linuxprosun of WIL 
Datum: Montag, 17. April 2023 um 11:32
An: DHIM IT 
Cc: "koha@lists.katipo.co.nz" 
Betreff: Re: [Koha] Can't connect to local MySQL server through socket

Hello,
How many users are using it? What are the software versions??

--regards
Prosun Prodhan
+91-8100-234-555


On Mon, Apr 17, 2023 at 12:55 PM DHIM IT 
mailto:itmana...@dhi-moskau.org>> wrote:
Dear Collogues,

for two weeks I get an every 2-5 minute error from the cron below. I can run 
the commands from the cron without a problem. Also, I can connect to my 
database without a problem. Any ideas?


Best regards,
Eugen Bastron


DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by 
"/usr/share/koha/bin/cronjobs/process_message_queue.pl<http://process_message_queue.pl>"

/etc/cron.hourly/koha-common:
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by 
"/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl<http://build_holds_queue.pl>"
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by 
"/usr/share/koha/bin/cronjobs/automatic_checkin.pl<http://automatic_checkin.pl>"



___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto: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] Can't connect to local MySQL server through socket

[DHIM IT]

Dear Collogues,

for two weeks I get an every 2-5 minute error from the cron below. I can run 
the commands from the cron without a problem. Also, I can connect to my 
database without a problem. Any ideas?


Best regards,
Eugen Bastron


DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by 
"/usr/share/koha/bin/cronjobs/process_message_queue.pl"

/etc/cron.hourly/koha-common:
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by 
"/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl"
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by "/usr/share/koha/bin/cronjobs/automatic_checkin.pl"



___

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

Re: [Koha] Can't delete fresh created biblio. DBI Exception: DBD::mysql::db do failed: Duplicate entry

[DHIM IT]

Dear colleagues,

the problem was that I had some old data in deletedbiblio_metadata. I think I 
forgot to clear the table after some test imports. Thanks Katrin for the tip.

Another question. Is it ok for KOHA to empty all deleted_TABLES ? 

Best regards,
Eugen Bastron

Am 17.02.23, 12:35 schrieb "Koha im Auftrag von DHIM IT" 
mailto:koha-boun...@lists.katipo.co.nz> im 
Auftrag von itmana...@dhi-moskau.org <mailto:itmana...@dhi-moskau.org>>:


Hello Alvoro,


before deletion I don’t have any problems in koha-about/system. After I’m 
trying to delete the record I get an error in koha-about/system. But if I 
delete the record from deletedbiblio I can delete the biblio over Web without 
any problem.






I think the error is if I try to delete the biblio, koha put the biblionumber 
into deletedbiblio than check deletedbiblio and give me error. I can’t 
understand, why I can normally delete the record second time after I delete the 
biblio from deletedbiblio .


Maybe is it some Indexing problem? Any other ideas?




Server version: 10.5.18-MariaDB-0+deb11u1 Debian 11






init-file_koha_fix.sql is implemented.




Von: Alvaro Cornejo mailto:cornejo.alv...@gmail.com>>
Datum: Donnerstag, 16. Februar 2023 um 17:23
An: DHIM IT mailto:itmana...@dhi-moskau.org>>
Cc: "koha@lists.katipo.co.nz <mailto:koha@lists.katipo.co.nz>" 
mailto:koha@lists.katipo.co.nz>>
Betreff: Re: [Koha] Can't delete fresh created biblio. DBI Exception: 
DBD::mysql::db do failed: Duplicate entry


Hi,


Seems you have duplicated records and need to fix them. You can check that out 
in:


Go to koha-about/system information.


If that is the case, you will find there instructions on how to fix the issue 
as well as the duplicated record numbers..


Regards


Alvaro
||
[Das Bild wurde vom Absender entfernt.] 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 jeu. 16 févr. 2023 à 03:05, DHIM IT mailto:itmana...@dhi-moskau.org><mailto:itmana...@dhi-moskau.org 
<mailto:itmana...@dhi-moskau.org>>> a écrit :
Dear colleagues,


I have problem on one of koha instance Version 22.05.09.000.


If I try to delete some biblio, fresh created too, I get this error:
An error has occurred!
Error 500




From: /var/log/koha/koha/plack-error.log




{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 
'61703-marcxml-MARC21' for key 'deletedbiblio_metadata_uniq_key' at 
/usr/share/koha/lib/C4/Biblio.pm line 2867










At the same time biblio landed in to the table deletedbiblio. After deleting of 
record from deletedbiblio and trying to delete the record again, it works.








Maybe have somebody idea about the error?




Mit besten Grüßen
IT-Manager
Eugen Bastron


___


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


Koha mailing list http://koha-community.org <http://koha-community.org>
Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
<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] Can't delete fresh created biblio. DBI Exception: DBD::mysql::db do failed: Duplicate entry

[DHIM IT]

Hello Alvoro,

before deletion I don’t have any problems in  koha-about/system. After I’m 
trying to delete the record I get an error in koha-about/system. But if I 
delete the record from deletedbiblio I can delete the biblio over Web without 
any problem.



I think the error is if I try to delete the biblio, koha put the biblionumber 
into deletedbiblio than check deletedbiblio and give me error. I can’t 
understand, why I can normally delete the record second time after I delete the 
biblio from deletedbiblio .

Maybe is it some Indexing problem?  Any other ideas?


Server version: 10.5.18-MariaDB-0+deb11u1 Debian 11



init-file_koha_fix.sql is implemented.


Von: Alvaro Cornejo 
Datum: Donnerstag, 16. Februar 2023 um 17:23
An: DHIM IT 
Cc: "koha@lists.katipo.co.nz" 
Betreff: Re: [Koha] Can't delete fresh created biblio. DBI Exception: 
DBD::mysql::db do failed: Duplicate entry

Hi,

Seems you have duplicated records and need to fix them. You can check that out 
in:

Go to koha-about/system information.

If that is the case, you will find there instructions on how to fix the issue 
as well as the duplicated record numbers..

Regards

Alvaro
||
[Das Bild wurde vom Absender entfernt.] 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 jeu. 16 févr. 2023 à 03:05, DHIM IT 
mailto:itmana...@dhi-moskau.org>> a écrit :
Dear colleagues,

I have problem on one of koha instance Version 22.05.09.000.

If I try to delete some biblio, fresh created too, I get this error:
An error has occurred!
Error 500


From: /var/log/koha/koha/plack-error.log


{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 
'61703-marcxml-MARC21' for key 'deletedbiblio_metadata_uniq_key' at 
/usr/share/koha/lib/C4/Biblio.pm line 2867





At the same time biblio landed in to the table deletedbiblio. After deleting of 
record from deletedbiblio and trying to delete the record again, it works.




Maybe have somebody idea about the error?


Mit besten Grüßen
IT-Manager
Eugen Bastron

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto: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] Can't delete fresh created biblio. DBI Exception: DBD::mysql::db do failed: Duplicate entry

[DHIM IT]

Dear colleagues,

I have problem on one of koha instance Version 22.05.09.000.

If I try to delete some biblio, fresh created too, I get this error:
An error has occurred!
Error 500


From: /var/log/koha/koha/plack-error.log


{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 
'61703-marcxml-MARC21' for key 'deletedbiblio_metadata_uniq_key' at 
/usr/share/koha/lib/C4/Biblio.pm line 2867





At the same time biblio landed in to the table deletedbiblio. After deleting of 
record from deletedbiblio and trying to delete the record again, it works.




Maybe have somebody idea about the error?


Mit besten Grüßen
IT-Manager
Eugen Bastron

___

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

Re: [Koha] koha 22.11 upgrading Error

[DHIM IT]

Dear all,

I had the same error. Here is the solution:

SET FOREIGN_KEY_CHECKS = 0;


ALTER TABLE issues MODIFY COLUMN borrowernumber int(11) NOT NULL COMMENT 
'foreign key, linking this to the borrowers table for the patron this item was 
checked out to', 
MODIFY COLUMN itemnumber int(11) NOT NULL COMMENT 'foreign key, linking this to 
the items table for the item that was checked out'

SET FOREIGN_KEY_CHECKS = 1;


Best regards,

Eugen Bastron

Am 03.12.22, 07:42 schrieb "Koha im Auftrag von Giuseppe Angilella" 
mailto:koha-boun...@lists.katipo.co.nz> im 
Auftrag von giuseppe.angile...@ct.infn.it 
>:


Hi,


same problem here.


Googling around, I've found a related issue here:


https://lists.katipo.co.nz/public/koha/2022-October/058542.html 



It seems to have to do with a constraint on a column, to be removed before 
the update can be applied, and then to be enforced again.


But I wouldn't dare adapting that solution to this specific case without 
further guidance by someone more expert than me ...


Could anyone help, please?


Regards,


Giuseppe (CC: Sami Rasheed)


___


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] Another DBI Exception for foreign key constraint in upgrade to Koha

[DHIM IT]

Dear all,

I had the same error. Here is the solution:

SET FOREIGN_KEY_CHECKS = 0;


ALTER TABLE issues MODIFY COLUMN borrowernumber int(11) NOT NULL COMMENT 
'foreign key, linking this to the borrowers table for the patron this item was 
checked out to', 
MODIFY COLUMN itemnumber int(11) NOT NULL COMMENT 'foreign key, linking this to 
the items table for the item that was checked out'

SET FOREIGN_KEY_CHECKS = 1;


Best Regards,

Eugen Bastron



Am 04.12.22, 08:48 schrieb "Koha im Auftrag von Pablo Bianchi" 
mailto:koha-boun...@lists.katipo.co.nz> im 
Auftrag von pablo.bian...@gmail.com >:


Thank you all for the answers!


On Sat, 3 Dec 2022 at 18:59, Katrin Fischer mailto:katrin.fischer...@web.de>>
wrote:


> Do you have entries in your issues table, where the borrowernumber is
> NULL?
>


Nope. In fact, *issues* has only one row, with its integer on
borrowernumber:
issue_id: 2. *borrowernumber: 53805*. issuer_id: NULL. *itemnumber: 1581.*
date_due: 2020-10-08 23:59:00. branchcode: BC. returndate: NULL.
lastreneweddate: NULL. renewals: 0. unseen_renewals: 0. auto_renew: 0.
auto_renew_error: NULL. timestamp: 2020-10-07 15:29:52. issuedate:
2020-10-07 15:29:52. onsite_checkout: 0. note: NULL. notedate: NULL.
noteseen: NULL.
On Sun, 4 Dec 2022 at 01:00, Tomas Cohen Arazi mailto:tomasco...@gmail.com>> wrote:


> That's a data issue. Maybe an old bug let things in wrongly on the db, it
> incomplete data migration.
>
> You should do something with those checkouts with no linked patron, and
> the upgrade script will continue where it left.
>


borrowernumber (and itemnumber) are not NULL in the only row of issues
table. Also, the borrowernumber (53805) exists on borrowers table. Could be
something else?


As a last resource (I wish to avoid) I could DELETE the row. This will
always cascade any action and can't break any consistency?


JFTR, even of course upgrading to Debian 10 has nothing to do with this, I
had some trouble with Apache and Memcached and new security features of
systemd (like PrivateTmp). I had to disable them.
___


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] Koha as SRU Server authentication problem

[DHIM IT]

Dear Colleagues,

I use Koha as SRU Server (Version 22.05.03).

I can connect to the server without credentials (user and password is blank) 
and with credentials from koha-conf.xml

How can I disable connection without credentials?

Example from koha-conf.xml:




/etc/koha/zebradb/ccl.properties

kohauser

password






Best regards
Eugen Bastron

___

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

Re: [Koha] Background jobs in Koha menu "Administration"

[DHIM IT]

Hello Anke,

my solution for the problem is to enable plugins in Koha-conf.xml file:


 1



Mit besten Grüßen,
Eugen Bastron

Von: Koha  im Auftrag von Bruns, Anke 

Gesendet: Thursday, July 7, 2022 1:55:58 PM
An: koha@lists.katipo.co.nz 
Betreff: Re: [Koha] Background jobs in Koha menu "Administration"

... I forgot to mention that these jobs aren't executed either, but remain in 
the New status on the overview page.

Regards,
Anke

> -Ursprüngliche Nachricht-
> Von: Bruns, Anke <>
> Gesendet: Donnerstag, 7. Juli 2022 12:52
> An: koha@lists.katipo.co.nz
> Betreff: AW: [Koha] Background jobs in Koha menu "Administration"
>
> Hi,
>
> not sure if this belongs to this thread, but as it concerns
>
> /cgi-bin/koha/admin/background_jobs.pl
>
> it may fit in.
>
> We realized that in 22.05 there is a http 500 error when clicking on "View" in
> one of the jobs listed on the background jobs overview. This is independent of
> - the Koha instance (we tried it with two different instances on our server)
> - whether you navigate to the background jobs overview via menu
> "Administration > Manage background jobs" or when you just started a batch
> operation (in our case batch item modification) and from there try to view the
> job in the list.
>
> The corresponding message in the plack-error.log reads:
>
>Can't call method "GetPlugins" on an undefined value at
> /usr/share/koha/lib/Koha/BackgroundJob.pm line 402.
>
> And this is line 402 in /usr/share/koha/lib/Koha/BackgroundJob.pm:
>
> my @plugins = Koha::Plugins->new()->GetPlugins( { method =>
> 'background_tasks', } );
>
> Should we file a bug for this?
>
> Regards,
> Anke
>
>
>
> --
> Anke Bruns M.A. (LIS)
> Arbeitsgruppe "Anwendungs- und Informationssysteme"
> E-Mail: anke.br...@gwdg.de
> ---
> Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG)
> Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
>
> Support: Tel.: +49 551 39-3, URL: https://gwdg.de/support
> Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@gwdg.de
>
> Geschäftsführer: Prof. Dr. Ramin Yahyapour
> Aufsichtsratsvorsitzender: Prof. Dr. Norbert Lossau
> Sitz der Gesellschaft: Göttingen
> Registergericht: Göttingen, Handelsregister-Nr. B 598
> ---
> Zertifiziert nach ISO 9001
> ---
>
>
>
>
>
> > -Ursprüngliche Nachricht-
> > Von: Koha  Im Auftrag von Michael Kuhn
> > Gesendet: Mittwoch, 22. Juni 2022 08:53
> > An: koha@lists.katipo.co.nz
> > Betreff: Re: [Koha] Background jobs in Koha menu "Administration"
> >
> > Hi Christopher
> >
> > Thanks for your meesage. You wrote:
> >
> >  > With just a cursory look, I would assume something like 1/1 means 1
> >  > job, 1 completed.  Something like 2/1 would mean 2 jobs, 1 completed.
> >  > 0/0, I would assume, means there are no jobs.
> >
> > Yes this is also our assumption - but we ask ourselves if there is no
> > job, why is there a line at all saying there is no job?! The library is
> > afraid that maybe something went wrong in such a case.
> >
> > As said, unfortunately clicking the button "View" does not show more
> > information like WHAT biblio or item exactly the job is referring to.
> >
> > Best wishes: Michael
> > --
> > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> > T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W 
> > www.adminkuhn.ch
> >
> >
> > > Message: 5
> > > Date: Mon, 20 Jun 2022 14:48:02 +0200
> > > From: Michael Kuhn 
> > > To: Koha 
> > > Subject: [Koha] Background jobs in Koha menu "Administration"
> > > Message-ID: 
> > > Content-Type: text/plain; charset=UTF-8; format=flowed
> > >
> > > Hi
> > >
> > > We saw in Koha 22.05 there is a new Koha menu "Administration > Manage
> > background jobs". Unfortunately there seems to be no entry in the Koha
> manual
> > 22.05 for it, also the context-sensitive help just leads to https://koha-
> > community.org/manual//21.11/en/html/ (this is in an installation of Koha
> > 22.05!).
> > >
> > > However the shown list has a column "progress" which can say "1/1" or
> "0/0"
> > for example. What does ist mean? Library personnel thinks "0/0"
> > > suggests that something went wrong even if column "Status" says
> "Finished".
> > Unfortunately clicking the button "View" does not show more information like
> > WHAT biblio or item exactly the entry is referring to.
> > >
> > > We saw that Bywater Solutions wrote an article about this new menu (
> > https://bywatersolutions.com/education/koha-21-11-background-jobs-and-
> task-
> > queue-enhancements
> > > ) but our question is not answered there. Can someone please enlighten us
> > what "0/0" means?
> > >
> > > Best wishes: Michael
> > > ___
> > >
> > > Koha mailing list  

Re: [Koha] Background jobs in Koha menu "Administration"

[DHIM IT]

Hello, I have the same problem. Koha Version: 22.05.02.000

Job ID  Status  ProgressTypeQueued  Started
3   New 0 / 1   Batch item record deletion  07.07.2022 06:27

Am 07.07.22, 13:56 schrieb "Koha im Auftrag von Bruns, Anke" 
:

... I forgot to mention that these jobs aren't executed either, but remain 
in the New status on the overview page.

Regards,
Anke

> -Ursprüngliche Nachricht-
> Von: Bruns, Anke <>
> Gesendet: Donnerstag, 7. Juli 2022 12:52
> An: koha@lists.katipo.co.nz
> Betreff: AW: [Koha] Background jobs in Koha menu "Administration"
> 
> Hi,
> 
> not sure if this belongs to this thread, but as it concerns
> 
> /cgi-bin/koha/admin/background_jobs.pl
> 
> it may fit in.
> 
> We realized that in 22.05 there is a http 500 error when clicking on 
"View" in
> one of the jobs listed on the background jobs overview. This is 
independent of
> - the Koha instance (we tried it with two different instances on our 
server)
> - whether you navigate to the background jobs overview via menu
> "Administration > Manage background jobs" or when you just started a batch
> operation (in our case batch item modification) and from there try to 
view the
> job in the list.
> 
> The corresponding message in the plack-error.log reads:
> 
>   Can't call method "GetPlugins" on an undefined value at
> /usr/share/koha/lib/Koha/BackgroundJob.pm line 402.
> 
> And this is line 402 in /usr/share/koha/lib/Koha/BackgroundJob.pm:
> 
> my @plugins = Koha::Plugins->new()->GetPlugins( { method =>
> 'background_tasks', } );
> 
> Should we file a bug for this?
> 
> Regards,
> Anke
> 
> 
> 
> --
> Anke Bruns M.A. (LIS)
> Arbeitsgruppe "Anwendungs- und Informationssysteme"
> E-Mail: anke.br...@gwdg.de
> ---
> Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG)
> Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
> 
> Support: Tel.: +49 551 39-3, URL: https://gwdg.de/support
> Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@gwdg.de
> 
> Geschäftsführer: Prof. Dr. Ramin Yahyapour
> Aufsichtsratsvorsitzender: Prof. Dr. Norbert Lossau
> Sitz der Gesellschaft: Göttingen
> Registergericht: Göttingen, Handelsregister-Nr. B 598
> ---
> Zertifiziert nach ISO 9001
> ---
> 
> 
> 
> 
> 
> > -Ursprüngliche Nachricht-
> > Von: Koha  Im Auftrag von Michael Kuhn
> > Gesendet: Mittwoch, 22. Juni 2022 08:53
> > An: koha@lists.katipo.co.nz
> > Betreff: Re: [Koha] Background jobs in Koha menu "Administration"
> >
> > Hi Christopher
> >
> > Thanks for your meesage. You wrote:
> >
> >  > With just a cursory look, I would assume something like 1/1 means 1
> >  > job, 1 completed.  Something like 2/1 would mean 2 jobs, 1 completed.
> >  > 0/0, I would assume, means there are no jobs.
> >
> > Yes this is also our assumption - but we ask ourselves if there is no
> > job, why is there a line at all saying there is no job?! The library is
> > afraid that maybe something went wrong in such a case.
> >
> > As said, unfortunately clicking the button "View" does not show more
> > information like WHAT biblio or item exactly the job is referring to.
> >
> > Best wishes: Michael
> > --
> > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> > T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
> >
> >
> > > Message: 5
> > > Date: Mon, 20 Jun 2022 14:48:02 +0200
> > > From: Michael Kuhn 
> > > To: Koha 
> > > Subject: [Koha] Background jobs in Koha menu "Administration"
> > > Message-ID: 
> > > Content-Type: text/plain; charset=UTF-8; format=flowed
> > >
> > > Hi
> > >
> > > We saw in Koha 22.05 there is a new Koha menu "Administration > Manage
> > background jobs". Unfortunately there seems to be no entry in the Koha
> manual
> > 22.05 for it, also the context-sensitive help just leads to 
https://koha-
> > community.org/manual//21.11/en/html/ (this is in an installation of Koha
> > 22.05!).
> > >
> > > However the shown list has a column "progress" which can say "1/1" or
> "0/0"
> > for example. What does ist mean? Library personnel thinks "0/0"
> > > suggests that something went wrong even if column "Status" says
> "Finished".
> > Unfortunately clicking the button "View" does not show more information 
like
> > WHAT biblio or item exactly the entry is referring to.
> > >
> > > We saw that Bywater Solutions 

[Koha] Translation mistakes ru-RU

[DHIM IT]

Dear Colleagues,

I found some mistakes in the translation ru-RU.

How can I provide to all KOHA users right translation?

Mit besten Grüßen,

Eugen Bastron
IT-Manager

Deutsches Historisches Institut Moskau

___

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

Re: [Koha] LDAP search failed to return object : 000004DC: LdapErr: DSID-0C090A5C, comment: In order to perform this operation a successful bind must be completed on the connection., data 0, v4563 at

[DHIM IT]

Problem solved. Here is right configuration:



 ldap://10.1.1.1
 DC=domain,DC=local
 CN=admin,OU=Admins,OU=OU_Users,DC=dhim,DC=local
 password
 1
 1
 1
 0
 OU=Admins,OU=OU_Users,DC=domain,DC=local
 
 
 
 
 ??
 ??
 
 
 


Am 21.06.22, 14:59 schrieb "Koha im Auftrag von DHIM IT" 
:

Dear colleagues,

After two days of tests I will ask you for help

I try to connect Koha to Microsoft Active Directory 2019 and get this error:



LDAP search failed to return object : 04DC: LdapErr: DSID-0C090A5C, 
comment: In order to perform this operation a successful bind must be completed 
on the connection., data 0, v4563 at /usr/share/koha/lib/C4/Auth_with_ldap.pm 
line 96.

What do I do wrong?

Ldapsearch works perfect:

ldapsearch -H ldap://hostname -x -D 
"CN=admin,OU=Admins,OU=OU_Users,DC=domain,DC=local" -w "Password" -b 
"CN=Users,DC=domain,DC=local" sAMAccountName=testuser

Here is config from koha-conf.xml

 
 ldap:// hostname 
 DC=domain,DC=local
     CN=admin,OU=Admins,OU=OU_Users,DC=dhim,DC=local
 Password
     1
 1
 0
 CN=Users,DC=dhim,DC=local
 
 
 
 
 
 





___

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] Access denied after try to run batchRebuildBiblioTables.pl

[DHIM IT]

It runs! Thank you, Mason!

Mit besten Grüßen,
Eugen Bastron

Von: Mason James 
Gesendet: Saturday, July 10, 2021 4:31:11 AM
An: DHIM IT ; Koha@lists.katipo.co.nz 

Betreff: Re: [Koha] Access denied after try to run batchRebuildBiblioTables.pl

hi Eugen
try using the 'koha-shell' command

$ sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c' 
your_koha_name


cheers, Mason


On 10/07/21 2:44 am, DHIM IT wrote:
> Dear colleagues,
>
> I will try to rebuild the biblioitems table after mapping a new value in 
> “Koha to MARC mapping”, but I get this error:
>
>
> /usr/share/koha/bin/batchRebuildBiblioTables.pl -c
>
> DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
> denied for user 'root'@'localhost' (using password: NO) at 
> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.
>
> DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
> denied for user 'root'@'localhost' (using password: NO) at 
> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.
>
> DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
> denied for user 'root'@'localhost' (using password: NO) at 
> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.
>
> DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
> denied for user 'root'@'localhost' (using password: NO) at 
> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.
>
> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access 
> denied for user 'root'@'localhost' (using password: NO) at 
> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at 
> /usr/share/koha/lib/Koha/Database.pm line 117
>
> Koha version: 20.11.05.000
>
>
>
> I can connect to MySQL without problems without password like: mysql -u root
>
>
>
> What am I doing wrong?
>
> Eugen Bastron
>
>
> ___
>
> 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] Access denied after try to run batchRebuildBiblioTables.pl

[DHIM IT]

Dear colleagues,

I will try to rebuild the biblioitems table after mapping a new value in “Koha 
to MARC mapping”, but I get this error:


/usr/share/koha/bin/batchRebuildBiblioTables.pl -c

DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
denied for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.

DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
denied for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.

DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
denied for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.

DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
denied for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.

DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied 
for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at 
/usr/share/koha/lib/Koha/Database.pm line 117

Koha version: 20.11.05.000



I can connect to MySQL without problems without password like: mysql -u root



What am I doing wrong?

Eugen Bastron


___

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

[Koha] hide some holding information in user opac

[DHIM IT]

Dear colleagues,

is it possible to hide some holding information in user opac?

In my case, I will hide the field “supplier”.

Best ragards,
Eugen Bastron


___

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

[Koha] colon between title and subtitle?

[DHIM IT]

Dear Colleagues,

does anyone know how to automatically put a colon(:) between the title(245a) 
and subtitle(245b)? Is there a setting for that? We want to separate both 
title(245a) and subtitle(245b) for better reading.

Best regards,
Eugen Bastron



___

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