Quote Originally Posted by philip_clarke View Post
In configuration > My Store, you had better check that your store is in the correct country and state first of all.

In the customer details section of configuration you can also choose not to display the "state" as a pull down, but you are now firmly into using some sql or phpmyadmin to clear up your zones because it is probable that when deleting the duplicate counties, some may be linked to one country id while others may be linked to a second. It would almost certainly be better at this stage to remove all UK sub zone using database manipulation and then redo the SQL. I do not recommend deleting all the zones otherwise you are going to need to do a total re-installation as it will wipe out the other countires in the world.

Philip
I have gone into MyPHPAdmin and deleted all the UK zones.

The rest of the world including the UK is fine and i just deleted the UK county zones.

Now here's a problem when i tried running the SQL script again it said the statements were processed but nothing is actually there.

Now heres an interesting thing. I have two other templates installed and i can sign up to an account using them but when i switch to the one i want to use it comes up with that error message.

That suggests that maybe it's something else causing the problem. Maybe the updated fast and easy checkout which i installed late last night.

I'll check that thread out and try and undo some steps did today for this template only.