Help Please!

[mike8823]

I seemed to have banned my own IP address and all the locations that I try to connect from. Is there a back door or a file that I can edit to clear this??

[ForceHSS]

what vb version and explain how u banned yourself

[mike8823]

I'm on Version 4.2.0 and I was trying to keep the spammers out , Admin,Settings, Options, Banning IP's. I must have banned my IP range with an *. That was the only change I made. I have tried different locations to log on to my site but get the same "Sorry. The administrator has banned your IP address. To contact the administrator", Well at least the Spammers can't get in... lol

[ForceHSS]

DELETE FROM `userban` WHERE (`userid`='1')
run this change the id if needed

[mike8823]

Where do I find that, is it on the Server?

[ForceHSS]

you would need to login to something like myphpadmin and run this query

[mike8823]

Thanks I'll give it a try!

--------------- Added [DATE]1349318815[/DATE] at [TIME]1349318815[/TIME] ---------------

That didn't seem to work. When I put in the command I received an error. Is there some place I can manually edit the ip ban list?

[betterthanyours]

You can only edit it accessing the mysql db. Other than that, you can upload tools.php to /admincp and have someone you know to themself admin permissions and instruct them on exactly what they should do. Once you are in remove their permissions, remove tools.php

[ForceHSS]

disable your plugins from the config just in case you have any custom security plugins

[BirdOPrey5]

You need to use phpmyadmin... (or some other MySQL interface)

Go to the settings table (note if you use a table prefix the table will be prefix_settings where prefix_ is whatever you set)

The entry you want to edit is: banip

You can just clear the value field for the entry or edit it to remove the wild cards...

In any case after making this edit you still have to update the datastore-

The easiest way to do this is to go re-run your upgrade.php script in your /install/ directory.