AnsweredAssumed Answered

User name does not exist: admin

Question asked by silenr0c on Mar 15, 2011
Latest reply on Mar 17, 2011 by stevegreenbaum
Hi guys,

I know it sounds funny, but my admin user is missing out of the blue.
one day i can't login using username:admin , password:admin
luckily i had already create another user with admin role before that.

So I check in Administration Console -> Manage System Users
1. the user admin is still there
2. I try to change password for admin it says:
    Please correct the errors below then click Finish.
    A system error happened during the operation: 02150039 User name does not exist: admin
3. I try to create another user with username:admin, password:admin it says:
    Please correct the errors below then click Finish.
    Failed to create Person due to error: 02150081 Person 'admin' already exists.
4. I check in the MySql database using this query
select node_id,qname_id,string_value from alf_node_properties
WHERE qname_id in (
SELECT id from alf_qname where local_name='password'
)
AND node_id in (
    SELECT node_id
    FROM alf_node_properties
    WHERE qname_id in (SELECT id from alf_qname where local_name='username')
    AND string_value = 'admin'
);
there is no record return

I am using Version 3.3.0 (2765) community edition

Thanks

Outcomes