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!
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.
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.
JohntheFish,
Your solution helped me out! :)
Thanks
Your solution helped me out! :)
Thanks
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
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
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.
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.
In v8 the table was renamed to UserBannedIPs so you can still use John's solution
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
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
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)
It contains ranges of IPs and for each range a type (blacklist, whitelist, automatic, manual)
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.
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 ?!