I've given up trying to get the zip code function to work. All I want to do now is completely dump it and get back to the situation where new people can join my web site. At the moment everyone gets knocked back and I'm sent a database error.
In my MySQL database I have deleted the field (i.e. a database column)
called 'zip' (which is of type check box) from the Inactive Fields
area. I did this because I was getting the following error message
when someone tried to join my subscription website;
Mysql error:
Column 'Zip' specified twice
Having deleted this column from the inactive fields I now get an error message as follows;
Mysql error:
Unknown Column 'Zip' in fields list
There
is another field in the Inactive Fields also called 'zip' (which is of
type text). However I can not delete this second database column
(field) as there in no delete button when I go into the 'Field Builder'
and click on the field (in the inactive fields area).
1) How do I delete this database column?
2) How do I delete the associated search keys for this column?
3) Are there any other things that I need to do in order to resolve this problem?
Muchos gracia
