Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Admin Panel is lost

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

When i enter the system by admin account, i cannot see admin panel link at the buttom. What is wrong ?? Please bring it to me

Thanks.
[originally posted on jforum.net by altuga]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It could be one of two things:

The admin user has been removed from the admin group or the admin user has had administrator rights removed.

To fix this, you will need to do some manual database changes using whatever tools it supplies (like MySQL's Administrator tool and the like)

First, you need to verify the admin user's database user_id number. This should be 2 but can change. To do this, look at the data in your jforum_users table for the record with a username of Admin. E.g.:

Select * from jforum_users where username = "Admin"

Next you need to check if the admin user is still a member of the "Administration" group. First get the group_id from the jforums_group table with:

Select * from jforum_groups where group_name = "Administration"

Then check if the admin user is a member of this group by doing:

Select * from jforum_user_groups where group_id = <admin group_id>

If the admin user is a member, you should see their user_id number in one of the records returned.

If the admin user is not a member, then you need to add them back in with:

insert into jforum_groups ( group_id, user_id) values ( <admin group_id>, <admin user_id>)

If the admin user IS a member, then you probably need to re-grant administrator rights to the group. You can do this by:

insert into jforum_roles ( group_id, name ) values ( <admin group_id>, 'perm_administration' )

Note: If you DB does not support autoincrement type key generation, you will need to include a valid role_id value as well, e.g. find the current maximum role_id value and add 1 to it.



[originally posted on jforum.net by monroe]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic