Open rfc1036 opened 6 months ago
/user/list
is routed to the customer@list
method, but this error refers to customer@overview
which is the view when you click on /customer/overview/xxx
and click on the Users tab.
Can you describe how to repeat the problem?
Also, can you:
Hey @rfc1036 - pending Nick's ask above for steps to reproduce - I've looked at resources/views/user/index.foil.php
and don't see any issues and it works fine in production and dev.
One thing to note is that /users/list
is not a valid URL but rather /user/list
, which I suspect you meant anyway.
Is there a database issue here? I can't imagine how it would happen, but ensure there are no users not linked to a customer:
SELECT * FROM `user` WHERE `custid` IS NULL;
To reproduce the issue I just had to access /user/list
.
Indeed there was one user with no custid
: after setting it the page works again.
I may or may not have deleted that user myself as the administrator, I cannot really remember. But I am sure that I have never tried modifying the database.
| id | custid | username | password | email | authorisedMobile | uid | privs | disabled | lastupdatedby | creator | name | peeringdb_id | extra_attributes | prefs | created_at | updated_at |
| 220 | NULL | xxxxx.xxxxxx2 | ... | NULL | NULL | NULL | 1 | NULL | NULL | OAuth-PeeringDB | NULL | 54698 | [] | {"mailinglist": {"minap-tech": 0}} | 2023-02-22 13:52:25 | 2023-02-22 20:32:01 |
Thanks @rfc1036 - OAuth-PeeringDB
may indicate the culprit. If a user is authenticated via PeeringDB and then subsequently removed from that org's PeeringDB account then we may clear custid. Will keep this open and check + find a better way to handle this case.
ISSUE TYPE
Bug Report
OS
Ubuntu 22.04.4 LTS.
VERSION
ENVIRONMENT
SUMMARY
/users/list
fails with a 500 error.RELEVANT LOGS