Hello All,
The user type of 2 users changes from ‘Administartor’ to ‘Regular User’ without any intervention. There are no custom logics to change the user type and confirm no schedulers are operating to change the user type.This is happening after the upgrade of suitecrm from 7.11 version to 7.13 and PHP8.0
.This is not happening in any other intsances like DEV and replica of prod.
Please help me with this.
Thanks in advance.
Hello Maneesha,
can you replicate this issue?
When does it usually happen?
Can you check your DB, there have been changes in the user table?
If you have more insights there, try to switch your log level to a more detailed one so get an impression of what’s going on.
The easiest option for debugging would probably be the SQL query that changes the user table in the column is_admin from 1 to 0.
If you’ve identified this query, you’d just need to work backwards: What happened before and go through the whole call stack.
Thanks @BastianHammer , for your response.
No, I could not able to replicate this issue. This is happening in PROD and not in other instances and this is causing only for 2 users
Yes, I have checked in database, as there is no audit table for the users table , I cannot verify the exact modified filed.But I have verified the general log for the mysql. But it does not return the exact results.Please see the below screenshot for the query reference.
Can you replicate it in the sense of time or trigger?
If you set the 2 users as admins, when are they switched back to non admins?
Can you check the users table manually (is_admin) - was it set to 1 before and now its set to 0?
Try to use the SuiteCRM logs (via admin - system settings - Log Level) and see whether you can find the change there.
