Banned user

Permalink 4 users found helpful
I am the administrator of my site. Within the past 24 hours I get this message - ?Unable to complete action: your IP address has been banned. Please contact the administrator of this site for more information." What do I do to fix this? Help!

 
JohntheFish replied on at Permalink Reply
JohntheFish
You could try resetting the router or whatever broadband device you use to connect to the internet. Just switch it off for 5 minutes then switch it on again and watch it reboot. Your ISP will probably then assign you a different IP address.
JohntheFish replied on at Permalink Reply
JohntheFish
Failing that, using phpMyAdmin the table UserBannedIPs contains a list of banned IP addresses. So using phpMyAdmin you could remove your IP address from that table.
AdamVidovics replied on at Permalink Reply
JohntheFish,

Your solution helped me out! :)
Thanks
tobyme replied on at Permalink Reply
I solved this in 2 minutes following John The Fish's answer using the database route. Took 2 minutes.

Just go to that table metioned (backed up before doing anything) deleted the only row in the table and relogged in. Jobs a good un
weitau replied on at Permalink Reply
This solution does not work for C5 ver 8 since the bannedIP table no longer exists (or I could not find it).

However the good news is that the ban is temporary and the default time out is 10 minute. So log in after 10 minutes, or use a free proxy (like hide.me) to hide your IP to get in earlier. of course you would need to change your admin password because the proxy can keep a record of everything you do.
mnakalay replied on at Permalink Best Answer Reply
mnakalay
In v8 the table was renamed to UserBannedIPs so you can still use John's solution
deanhawthornthwaite replied on at Permalink Reply
deanhawthornthwaite
Cant find 'UserBannedIPs' table on version 8.0 when using the search facility in PHP MyAdmin.
I reduced the search to just the word 'User' and this was the result, which as you can see does not contain anything regarding IP:

OauthUserMap
PermissionAccessEntityUsers
SavedUserSearchQueries
UserAttributeKeys
UserAttributeValues
UserGroups
UserPermissionEditPropertyAccessList
UserPermissionEditPropertyAttributeAccessListCustom
UserPermissionViewAttributeAccessList
UserPermissionViewAttributeAccessListCustom
UserPointActions
UserPointHistory
UserPrivateMessages
UserPrivateMessagesTo
Users
UserSearchIndexAttributes
UserSignupNotifications
UserSignups
UserValidationHashes
UserWorkflowProgress
mnakalay replied on at Permalink Reply
mnakalay
It got a little more complicated. The table you are looking for is LoginControlIpRanges
It contains ranges of IPs and for each range a type (blacklist, whitelist, automatic, manual)
NotionCommotion replied on at Permalink Reply
For at least 8.5.4, you need use IpAccessControlRanges. Probably you could delete it but I just edited it to use some other poor unsuspecting individual's IP.
enlil replied on at Permalink Reply
enlil
This, oddly, just happened to me in 8.5.4. Reboot my tower, open up the browser, site wants me to login, BOOM, my ip is added to the list somehow at that exact moment, according to the timestamp in the db, and SuperUser is locked out. Removed from IpAccessControlRanges and all is well. How in the LORD does this happen ?!