How to find accounts without profiles?
Currently, I see in statistics that I have 1392 people and 1398 accounts. The question is how to find the 6 accounts without profiles because it does not interest me to keep them, I like the round figures.
There is a trick for that?
-
-
·
Alex T⚜️
- ·
Accounts without profiles will have empty "Profiles" field on this page - page/accounts-administration
-
·
Alex T⚜️
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Yes Alex I understand that, but I do not know how to look for them. should I review all pages? I see only this means for now, but it is not very practical. Is there a regular expression that I can use with the search box?
-
-
·
Alex T⚜️
-
·
In reply to Baloo
- ·
Is there a regular expression that I can use with the search box?
No, another way is to search manually in the database.
-
·
Alex T⚜️
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Alex, how to identify an account that does not have a profile because in the sys_accounts table an account that does not have a profile seems to still have a profile_id.
How are you doing then? -
-
·
Alex T⚜️
-
·
In reply to Baloo
- ·
You can use the following query to get all emails which don't have any person or org profile associated with it:
SELECT `email` FROM `sys_accounts` AS `a` LEFT JOIN `sys_profiles` AS `p` ON ( `p`.`account_id` = `a`.`id` AND `p`.`type` != 'system' ) WHERE `p`.`id` IS NULL
-
·
Alex T⚜️
-
- · DeDiary
- ·
I think this feature should be included in the Admin Functionality.
It easy for low traffic or membership yielding website, but a mirage for big systems. Moreover, If an old member decides to delete his or her profile leaving the account behind, it wont be easy to purge them during routine cleanup process.
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Thank you Alex, it helps, but like DeDiary, I hope a more user-friendly solution and secondly it is not a solution for turnkey solutions that you propose to avoid this kind of manipulation.
-
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Alex, recently, it seems that there is an account without anyone hiding somewhere ...
-
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
No Alex, by manually browsing the list I was finally able to locate the account that is causing a problem.
As you can see, he does not have a profile.
Problem, if I try to delete it, the wheel turns indefinitely.Also, I try to reset the password of the account, then tried to connect to it, this produces a 500 error. It looks like a corrupt account somewhere ...
I can see this account in the sys_account table ...
-
-
·
Alex T⚜️
- ·
Could you please provide more details ? When 500 HTTP error is generated it should be more info in web server error log files, could you please check this error log when this happens ?
-
·
Alex T⚜️
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Yes => [:error] [pid 2740] [client 62.197.120.226:59494] PHP Fatal error: Call to a member function onDeleteContent() on boolean in /var/www/meetsee/modules/base/general/classes/BxBaseModGeneralFormEntry.php on line 223, referer: https://www.meetsee.online/studio/module.php?name=bx_accounts
-
-
·
Alex T⚜️
- ·
It's difficult to say why it happens, but we'll try add additional checking to get rid of this error:
-
·
Alex T⚜️
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Yes, not easy, I only have one account involved. Do you think I can delete the line directly in sys_accounts without risking a problem?
-
-
·
Alex T⚜️
-
·
In reply to Baloo
- ·
It still maybe some relative records in other tables, so it's not recommended to do it, please wait for the official update.
-
·
Alex T⚜️
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Ok, thanks for the response.
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Alex T⚜️ , I beg you, couldn't you add this in 12, I'm tired of doing it in the database, it's a very small change. Thank you.
-
-
·
Alex T⚜️
-
·
In reply to Baloo
- ·
ok, good idea - https://github.com/unaio/una/issues/3135
-
·
Alex T⚜️
-
- · Baloo
-
·
In reply to Alex T⚜️
- ·
Alex T⚜️ Thanks a lot for that, but wouldn't it be wise to exclude "robot" from the selection?
Otherwise it is a real pleasure to be able to delete these accounts in two clicks. -
-
·
Alex T⚜️
-
·
In reply to Baloo
- ·
Alex T⚜️ Thanks a lot for that, but wouldn't it be wise to exclude "robot" from the selection?
Otherwise it is a real pleasure to be able to delete these accounts in two clicks.Thank you for the idea, issue was reopened
-
·
Alex T⚜️