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]
The easier way is to remove all roles and set them again. Do the following in some mysql ( or postgresql ) client":
then get the Admin user_id:
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
this should return "2" and "2".
Rafael [originally posted on jforum.net by Rafael Steil]