Setting user admin permissions via mysql tables?

[steven s]

We are working with a company to develop our new forum.
Currently I have mod rights in our test forum.
I imported my vB forum to the database server and now want to test the import.

Is there way for me to set my permissions so I have admin access to run the import?
I have access to the database and root passwords.
I don't want to wait until Monday for my access.

 

[Paul B]

See this post: http://xenforo.com/community/threads/promote-to-admin-via-database.12356/#post-163304

 

[steven s]

Thanks.
According to the other thread, everything is set correctly. Also cleared cache and cookies to be on the safe side. I still appear as moderator.
Added myself as superadmin.

Can't see usernames or the import under tools. ??

 

[Paul B]

Have you made yourself an administrator and added the necessary permissions?

 

[steven s]

Have you made yourself an administrator and added the necessary permissions?

The current admin says he made me an admin.
I added myself as a superadmin in the config file.

user.is_admin = 1 as it should.
I'm listed in the xf_admin.user_id

I cleared cache and cookies. Logged back in.
Usergroup says moderator as it did before.
There may be permissions I don't see.

 

[Paul B]

Do you appear in the list when you click on Users -> Administrators?

If so, are you able to see what your permissions are by clicking on your name?

 

[steven s]

Do you appear in the list when you click on Users -> Administrators?

If so, are you able to see what your permissions are by clicking on your name?

That's the thing. I don't see anything that I would expect expect that and the couple of tables I checked look correct.

 

[Paul B]

In which case your permission set is quite limited.

You need to ask the super admin to change it.

 

[steven s]

In which case your permission set is quite limited.

You need to ask the super admin to change it.

Can I do that through the tables?

my xf_admin.extra_user_group_ids = 332c342c35
User 1 is = 33

xf_user.secondary_group_ids = 332c342c35
User 1 = 332c34

xf_user.permission_combination_id = 10
User 1 = 7

 

[Paul B]

I'm not sure how to do it directly on the DB as the permission_cache field is a long string of digits relating to the actual permission set.

 

[Luke F]

Can I do that through the tables?

my xf_admin.extra_user_group_ids = 332c342c35
User 1 is = 33

xf_user.secondary_group_ids = 332c342c35
User 1 = 332c34

xf_user.permission_combination_id = 10
User 1 = 7

How can you have database access but not full admin permissions?

 

[steven s]

How can you have database access but not full admin permissions?

Because we have a web development company creating a single sign on with another database and they are incorporating our site design in the footer and header of xenforo.
I now have the admin's login and password. The problem with my permissions might have something to do with the single sign on.