Bug 29796 - Cannot create new patron accounts
Summary: Cannot create new patron accounts
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: 21.11
Hardware: All Linux
: P5 - low major
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-01-05 04:45 UTC by Jeremiah
Modified: 2023-06-08 22:26 UTC (History)
4 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jeremiah 2022-01-05 04:45:04 UTC
Hello,

My Koha installation suddenly will no longer allow me to create patron accounts. The first prompt I receive is: "Something went wrong when creating the patron. Check the logs."

When I open the plack-intranet-log I see this:
[2022/01/04 20:42:19] [WARN] Patron creation failed! - {UNKNOWN}: DBIC result _type  isn't of the _type Category at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 130. at /usr/share/koha/lib/Koha/Patron.pm line 354

I am honestly stumped, I was not having this problem before and I haven't changed any settings that would have caused this. 
Thankfully, I can use the self-registration feature as a workaround right now until this can get fixed.

I can provide additional details if needed.
Comment 1 Katrin Fischer 2022-01-05 08:03:52 UTC
Hi Jeremiah, what is your exact Koha version? 
Were there any problems/errors shown during the update?
Comment 2 Jonathan Druart 2022-01-05 08:27:59 UTC
Works for me on 21.11.01.
Comment 3 Katrin Fischer 2022-01-05 08:44:14 UTC
Just to make sure, when did it happen and did you run update that caused this? Which was the previous version?

As Joubu said it works in new installations, so we need to dig a bit deeper here.
Comment 4 Jeremiah 2022-01-05 15:30:27 UTC
I was originally running 21.05, currently, I am running 21.11.01.000.
During the update, I was not seeing any errors. 
Also, I was experiencing this right before I updated to the new version.
Comment 5 Katrin Fischer 2022-01-05 15:55:58 UTC
Did you make any local changes, including *UserJs?
Comment 6 Jonathan Druart 2022-01-05 15:59:20 UTC
You should see more info in the log files, can you post the full stacktrace?

Also, do you see the problem with other patron's category? Did you try to create a new category and a patron using it? Does it work if you edit an existing patron?
Comment 7 Jeremiah 2022-01-05 19:20:51 UTC
I did not make any changes to the internal files.

Sure I will post more:

[2022/01/05 07:16:49] [WARN] Patron creation failed! - {UNKNOWN}: DBIC result _type  isn't of the _type Category at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 130. at /usr/share/koha/lib/Koha/Patron.pm line 354
[2022/01/05 07:17:11] [WARN] Subroutine CORE::GLOBAL::time redefined at /usr/share/perl5/Test/MockTime.pm line 20, <DATA> line 755.
[2022/01/05 07:17:11] [WARN] Prototype mismatch: sub CORE::GLOBAL::time () vs none at /usr/share/perl5/Test/MockTime.pm line 20, <DATA> line 755.
[2022/01/05 07:17:11] [WARN] Subroutine CORE::GLOBAL::localtime redefined at /usr/share/perl5/Test/MockTime.pm line 21, <DATA> line 755.
[2022/01/05 07:17:11] [WARN] Prototype mismatch: sub CORE::GLOBAL::localtime (;$) vs none at /usr/share/perl5/Test/MockTime.pm line 21, <DATA> line 755.
[2022/01/05 07:17:11] [WARN] Subroutine CORE::GLOBAL::gmtime redefined at /usr/share/perl5/Test/MockTime.pm line 22, <DATA> line 755.
[2022/01/05 07:17:11] [WARN] Prototype mismatch: sub CORE::GLOBAL::gmtime (;$) vs none at /usr/share/perl5/Test/MockTime.pm line 22, <DATA> line 755.
[2022/01/05 07:31:19] [WARN] Patron creation failed! - {UNKNOWN}: DBIC result _type  isn't of the _type Category at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 130. at /usr/share/koha/lib/Koha/Patron.pm line 354


[2022/01/04 14:10:09] [WARN] Patron creation failed! - {UNKNOWN}: DBIC result _type  isn't of the _type Category at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 130. at /usr/share/koha/lib/Koha/Patron.pm line 346
[2022/01/04 14:10:09] [WARN] Use of uninitialized value $newdata{"emailpro"} in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 479.
[2022/01/04 14:10:09] [WARN] Use of uninitialized value $newdata{"B_email"} in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 482.
[2022/01/04 14:11:02] [WARN] Patron creation failed! - {UNKNOWN}: DBIC result _type  isn't of the _type Category at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 130. at /usr/share/koha/lib/Koha/Patron.pm line 346
[2022/01/04 14:11:02] [WARN] Use of uninitialized value $newdata{"emailpro"} in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 479.
[2022/01/04 14:11:02] [WARN] Use of uninitialized value $newdata{"B_email"} in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 482.
[2022/01/04 14:12:22] [WARN] Patron creation failed! - {UNKNOWN}: DBIC result _type  isn't of the _type Category at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 130. at /usr/share/koha/lib/Koha/Patron.pm line 346
[2022/01/04 14:12:22] [WARN] Use of uninitialized value $newdata{"emailpro"} in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 479.
[2022/01/04 14:12:22] [WARN] Use of uninitialized value $newdata{"B_email"} in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 482.
[2022/01/04 15:23:29] [WARN] Patron creation failed! - {UNKNOWN}: DBIC result _type  isn't of the _type Category at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 130. at /usr/share/koha/lib/Koha/Patron.pm line 346
[2022/01/04 15:23:29] [WARN] Use of uninitialized value $newdata{"emailpro"} in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 479.
[2022/01/04 15:23:29] [WARN] Use of uninitialized value $newdata{"B_email"} in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 482.
[2022/01/04 15:26:19] [WARN] Patron creation failed! - {UNKNOWN}: DBIC result _type  isn't of the _type Category at /usr/share/perl5/DBIx/Class/Storage/BlockRunner.pm line 130. at /usr/share/koha/lib/Koha/Patron.pm line 346
[2022/01/04 15:26:22] [WARN] error at after DATA: 5.2.252 SendAsDenied; xxxxxx@xxxx.org not allowed to send as root@localhost; STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message. 0.35250:97610000, 1.36674:0A000000, 1.61250:00000000, 1.45378:02000000, 1.44866:7C1C0000, 1.36674:0E000000, 1.61250:00000000, 1.45378:811C0000,
Comment 8 Katrin Fischer 2022-01-09 00:05:50 UTC
Hi Jeremiah,

could you please also make these tests as Jonathan suggests?

> Also, do you see the problem with other patron's category? Did you try to
> create a new category and a patron using it? Does it work if you edit an
> existing patron?
Comment 9 Magnus Enger 2022-05-30 06:24:13 UTC
Is this still a problem?