MyBB Community Forums

How to activate all the users that are waiting their registration?

I accumulated an amount of users that needs to be activated over the time. Lol

Run in PHPMyAdmin

UPDATE mybb_users SET usergroup=2 WHERE usergroup=5

(2014-07-04, 12:59 PM)dragonexpert Wrote: [ -> ]Run in PHPMyAdmin

UPDATE mybb_users SET usergroup=2 WHERE usergroup=5

I rarely use PHPadmin and I don't have experience.. but here I tried and it says it doesn't exist:

Replace mybb_users with whatever the name of your users table is. mybb_users is what the default name of the table is.

beware mistakes, you may ask your host provider to help you run those query

Seems your table isn't right. Probably its:

UPDATE users SET usergroup=2 WHERE usergroup=5 

Some people don't allocate a table extension such as mybb_

(2014-07-05, 04:06 AM)Ace700 Wrote: [ -> ]Seems your table isn't right. Probably its:

UPDATE users SET usergroup=2 WHERE usergroup=5 

Some people don't allocate a table extension such as mybb_

It does not work I tried.

What is your Table Prefix? If you dont know it, go to config.php file OPEN it. And find your TABLE PREFIX.

After that run this:

UPDATE `TABLEPREFIX_users` SET `usergroup` = '2' WHERE `usergroup` = '5';

Replace TABLEPREFIX with your table prefix.... (Say "boxxy_users")

If you're unsure it might be worth asking your hosting provider. If they're not helpful, feel free to PM or email me and I'll take a look for you.

The poster is hiding their prefix because they've been denied support on another account. @OP, if you're going to make copycat boards, I suggest you learn enough about web administration to be able to support them.