Lock account

The link in the profile is pointing to an out of date location. Use the Admin->Members panel instead for now.  Choose "Unlocked Members" and then click on the name of the member you want to lock out.

I went to the admin panel, then members.  Then I clicked "Unlocked Members", which happens to be 8,080 people.  Since the particular user has a name that starts with S, I clicked that letter.  Here's what I got:

Query: SELECT COUNT(DISTINCT author.uid) FROM secondfanfiction_authors as author LEFT JOIN secondfanfiction_stories as stories ON stories.validated > 0 AND (FIND_IN_SET(author.uid, stories.coauthors) > 0 OR stories.uid = author.uid) LEFT JOIN secondfanfiction_authorprefs as ap ON author.uid = ap.uid WHERE (ap.level IS NULL OR ap.level > -1) AND S AND author.penname LIKE 'S%'
Error: (1054) Unknown column 'S' in 'where clause'

I did manage to navigate using the pagelinks (and by changing the offset in the URL), and I got very close to the correct username before either my Internet connection went down to 7Kb/s again (worst "high speed" ever) or the server had issues.  So I guess I'll tell you if it worked once it gets going again.

Edit: because of the combo of 8000 members and really slow internet, it took a while, but it worked.  Still get MySQL errors clicking on the letters, though.

At the request of Jan_AQ:

After upgrading to 3.2.1, I was able to lock accounts through the admin links when viewing profiles.

However, when I attempted to log in using the locked account, I got this:

TemplatePower Error: Template isn't prepared!
rn

I can log in and out normally, so it appears to be only for the locked account.  I'm not sure what is supposed to appear when a locked user attempts login, though.

(The MySQL error in the letter links is also fixed.)

It'll be fixed with the next update.

aha yes this is the same problem im getting and great to hear that it will be fixed with the next update 🙂

Can someone please verify if this is fixed or not? thank you.

on my 3.3  testsite I get "You are not authorized to access that function" when trying to log in with a locked account

so I'd say its not fixed yet :p

How is that incorrect? Maybe it should read "Your account has been locked" or something, but a locked account trying to log in ought be blocked by the script, right? Or am I reading you wrong?

How is that incorrect? Maybe it should read "Your account has been locked" or something, but a locked account trying to log in ought be blocked by the script, right? Or am I reading you wrong?

Yeah it should read that the account has been locked

Jan_AQ asked me to report back on this a while ago, and I just upgraded to 3.3 yesterday.

The message is different than the one I reported earlier for 3.2.1.  It says instead, "You are not authorized to access that function."

If that is what it is meant to say, then it appears to be working correctly.  The header and footer are both appearing (I don't think they did before), so it looks good to me.

If there's meant to be some explanation about the account being locked, then it's not working.  I'm not sure what is intended.

im pretty sure its supposed to say that the accounts been locked by an admin (im sure I seen this in the languages/en.php file)

so im pretty sure that it has not been correctly fixed as of yet

From languages/en_admin.php, line 4:

define ("_ACCTLOCK", "Your account has been locked. Please contact the site administrator for further information.");

Bump.  This should be fixed in 3.3.1

Confirm fixed, vote topic relocation and thanks again.