Lost admin

[Migrated From Jforum.net]

It seems like I've changed my admin users priviliges to non-admin. I log in as adamin but I cant get to the admin pages. Any way to recover from this? * Some days it's just not worth getting out of bed
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

The easier way is to remove all roles and set them again. Do the following in some mysql ( or postgresql ) client":

DELETE FROM jforum_role_values;
DELETE FROM jforum_roles;

INSERT INTO jforum_roles ( group_id, name, role_type ) VALUES (2, 'perm_administration', 1);

then get the Admin user_id:

SELECT user_id FROM jforum_users WHERE username = 'Admin';

and then make sure the user is in the administrators group. The table is "jforum_user_groups". So, if the Admin user id is 2, you must have an entry like

SELECT user_id, group_id FROM jforum_user_groups;

this should return "2" and "2".

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Perfect! Thanks!
[originally posted on jforum.net by Anonymous]