MyBB Community Forums

Now, in the last thread that I created, I stated that I had a problem changing members usergroups via the admincp, due to a 503 error appearing.

Now, I've contacted my host, with no luck on a reply, and the problem is still about. So, rather than keep trying and getting this damn error, I was wondering if it was possible to change members usergroups via the MySQL itself?

It may not be the safest way, I'm just wondering if it is possible. And if so, how so?

Thanks.

Website

UPDATE `mybb_users` SET `usergroup` = 'X' WHERE `uid` = 'Y';

Change X to the GID of the usergroup and Y to the UID of the user.

Your host should really be able to fix that error though...

(2010-10-27, 10:21 PM)MattRogowski Wrote: [ -> ]

UPDATE `mybb_users` SET `usergroup` = 'X' WHERE `uid` = 'Y';

Change X to the GID of the usergroup and Y to the UID of the user.

Your host should really be able to fi that error though...

They should, but they haven't replied and they haven't fixed anything. I'm growing quite impatient. Thanks for the help!

---

(2010-10-27, 10:21 PM)MattRogowski Wrote: [ -> ]

UPDATE `mybb_users` SET `usergroup` = 'X' WHERE `uid` = 'Y';

Change X to the GID of the usergroup and Y to the UID of the user.

Your host should really be able to fi that error though...

Sorry to double post, but where do I put this code? I'm kind of lost here now...

Presuming you have cPanel, go to phpMyAdmin, then click your MyBB database name, then the SQL tab.

You guys are brilliant! It works perfectly, and no 503 errors! Thank you so much