Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Lost admin

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Perfect! Thanks!
[originally posted on jforum.net by Anonymous]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic