How to know if you have some domain passwords not encrypted when they are supposed to be, and how to fix them.

Go to Settings > Utilities > SQL Tools*
Use this query and press "SUBMIT QUERY"

SELECT `name`, `value`

FROM `setting`

WHERE `name` LIKE 'Domain Passwords are Encrypted';

SELECT CustomerID AS Customer_ID, id AS Package_ID, password AS Package_Password

FROM domains

ORDER BY password;

If 'Domain Passwords are Encrypted' value is 1, then your passwords must be encrypted.
Search in column Package_Password if there is any password that can be read (Those that seems to not be encrypted)
Create a list with all the not encrypted passwords
For each not encrypted passwords, go to the Side Bar, in SEARCh section,
and choose "All Users" with "UserID" like (the number in column Customer_ID)
In that user look in his Packages the one CE# where # is the value in the column Package_ID
(for example, if Package_ID is 20 then look for CE20)
inside package details, take a look in the "Password" section and if you can read it (seems to not be encrypted),
leave it unreplaced and continue with all the other passwords in your list ( pass 5) )

but if you can not read it, replace it with the value in the column Package_Password obtained in the query, press UPDATE,
and continue with all the other passwords in your list ( pass 5) )

Updated on: 23/02/2023