UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support User can't login

One of our users is getting a "Your account has been banned or locked" when they try to view any forum or login. This user has NOT been banned or locked, and all permissions look fine.

What is going on here? Is this a board problem? A firewall thing? A browser thing? Any ideas/help?

I've got to admit, this recent upgrade to ubb.threads from ubb.classic has been a little painful, and I still have one board left to convert. :-( Seems like every day I have one or two new problems cropping up.

Thanks so much in advance for your assistance!

Tracy

As Admin you can try out to 'become this user' and so you can test his account without knowing his password.
It's possible that you have some db trouble after converting. But first try the 'becom this this user' function and see if this work.

Then check the tables w3t_Banned and w3t_BannedEmails for entrys (phpmyadmin)

Right, I had already tried the 'become this user' feature and was able to view everything just fine.

I did check the tables you mentioned and there are no records at all in either table.

??????

Tracy

Sounds like a cookie problem but I never see a report like this (you have been banned). Ask the user to clean out theyr cookies or test another browser. I guess its a problem on the user side.

But wait for answers of the board pro's <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" /> maybe they have another ideas.

Is the "Member has access rights" unchecked when viewing the user in the control panel?

Yes, as Rick mentioned see if the member has the access rights box unchecked, this could be the source of your problem (unchecking that box is equivalent to banning a user).

If that doesn't help then you can always become that user to see if the account works. If he/she still can't log in then ask them to clear their cookies using this link http://www.yourforumsite.com/ubbthreads/mycookies.php

As mentioned, I already checked all of the permissions possibilities; they are all set fine -- user is not banned, "Member has access rights" is checked. Also already logged in as that user, without problem.

Is Zarzal's thought about cookies a possibility?

Tracy

It definitely can't be a cookie issue. There are only 2 places that exact text string is used and both of those come when comparing a check on their U_Banned field.

Try this. Run this command from the Database Tools -> SQL Command box:

select U_Banned from w3t_Users where U_Username='theirusername'

Replace theirusername with their actual display name.

OK, I did that and it produced 0 results...

Tracy

Hmm, that means it couldn't find her username at all. Let's try by their User Number.

select U_Banned from w3t_Users where U_Number='theirusernumber'

You could always ask the user to re-register and then move all their posts to the new account

Oh, dear, I'm sorry... I looked at the database through phpMyAdmin and I just realized what that SQL query was checking. I thought maybe the UBB interface was returning '0' to indicate '0' records, but now I see it is the value for the U_Banned field for that record.

In fact, the original query did find the user and returned '0', meaning, I presume, that they aren't banned.

Sorry for the temporary mis-lead there!

Tracy

Ok, so there is no *logical* reason why this user is getting that message then. Like I said, the only time that appears is when the U_Banned field returns a 1.

Perhaps this user is trying to login with the wrong username maybe? I'm pretty sure in classic usernames were case sensitive and in threads they are not. Perhaps someone else had the same username, different case and was banned. I'm kinda grasping at straws here because like I said, there's no logical reason for that to be happening.

Can you find out what exactly name she is logging in with and then run this query:

select U_Banned from w3t_Users where U_LoginName='herloginname'

As with the other SQL query, the result is 'U_Banned' = 0.

So this can't possibly be cookies or something like that on her end?

Now I have yet another user who can't login, this time with a different error (just that the username/password can't be found); but I can login as them.

Help?!

Tracy

Honestly, if you can type in their username and password and get in, but they cannot, then it sounds like something as simple as they aren't typing their username or password correctly. The latest one "Username/password can't be found" only gets displayed if one or the other is incorrect.

You can open a support ticket if you'd like and provide some of the usernames and passwords they are logging in with and I can verify.

I saw a classic import once that had some duplicate usernames (like the same user twice) thus produced odd results in some places.

SELECT U_Username, U_Number
FROM w3t_Users
WHERE U_Banned = 1

Should select all the users who are banned. Make sure there's nothing in there matching the user that's having trouble.

Josh, I've already run that query and there are 0 users banned. Thanks for the advice, though.

Rick, I will have to ask the user about that. Otherwise I'll have to open a support ticket. This is an oddity.

Regarding the second user I mentioned yesterday, an FYI that he said he deleted his cookies and then changing his blocked site settings, as per the following:
[]Fist I deleted my list of cookies to web sites that had been blocked. I know I never specifically opted to block a cookie at Plus Community, but there might have been a request made from an unrelated site where someone posted a link to your site.

Then I dropped my cookie guard from “Prompt” to “Allow all”.

Then I successfully logged in.

I can’t go back and restore the long list of cookies that were blocked, but I did reset the cookie guard for “Prompt” and was still able to log in after IE asked to permit the cookie. So I guess your site got into my list of blocked sites.[/]
So that might be useful for other UBB admins who are having complaints like this.

Tracy