Page 1 of 1

Message: Permissions Transferrred?

Posted: Tue Oct 25, 2011 8:20 pm
by imagedude
I logged in today to my site to check for spammers. I got a message when trying to access teh ACP. Permissions Transferred. :?:

Here's teh support template thingy...


Support Request Template
What version of phpBB are you using? phpBB 3.0.9
What is your board's URL? http://www.ecmplace.com
Who do you host your board with? hostgator.com
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? No
Is registration required to reproduce this issue? No
What version of phpBB3 did you update from? phpBB 3.0.8
What styles do you currently have installed? Prosilver, serenity
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 4
What is your level of experience? Experienced with PHP and phpBB
When did your problem begin? Today - October 25, 2011
Please describe your problem. Logged in to board.
Checked for spam posts. (I look at "unanswered posts") Usually I get a few per day, as i have the anti-spam mods installed. All posts are from registered users and I have the anti-spam question that must be answered for registration.

I then went to delete a user from the ACP. I was given a message, "Permissions Transferred." It went on to say my permissions are from another user (a spam user) but that Iwas unable to access the ACP.

I went into the SQL tables and deleted this user.

Ideas?
Generated by SRT Generator

Re: Message: Permissions Transferrred?

Posted: Tue Oct 25, 2011 8:48 pm
by Erik Frèrejean
imagedude wrote:I went into the SQL tables and deleted this user.
You shouldn't delete users (or anything else for that matter) through the database itself.

You probably (by accident) have clicked on the "test permissions" link in the users profile. This allows you to see the board as that user to test permissions. In this "mode" you can reset permissions back by clicking "restore permissions" on the board or the link in that message.

Re: Message: Permissions Transferrred?

Posted: Tue Oct 25, 2011 8:53 pm
by imagedude
Oh, I got it.

I've deleted users through mysql before. Not usually my first option, but haven't so far caused any issues. I have a query i run based on the ones run from the ACP.

Re: Message: Permissions Transferrred?

Posted: Tue Oct 25, 2011 8:57 pm
by Erik Frèrejean
imagedude wrote:I've deleted users through mysql before. Not usually my first option, but haven't so far caused any issues. I have a query i run based on the ones run from the ACP.
As long you update/delete all references to the user there isn't a problem (users table isn't the only one), if not you risk leaving your database in a corrupted state which can cause unexpected behavior.