Problems creating an account

[bobeisenberg]

I have updated my OSC addresses for UK counties. When someone creates an account, and types in their county, when they click on the continue button, the box becomes a drop-down box listing the counties. However, when they then select their county, it is not accepted.

 

Is there any way to stop the drop down box appearing?

 

Many thanks.

 

Bob Eisenberg

Oakleaf Jewellery

 

www.oakleafjewellery.com

[♥Vger]

If you added all of the UK Counties via an SQL file into your database then you shouldn't be having this problem.

 

Vger

[bobeisenberg]

If you added all of the UK Counties via an SQL file into your database then you shouldn't be having this problem.

 

Vger

 

 

Vger

 

I did add it using an SQL file. The only 'county' it doesn't accept is London (but is does accept Mancheser and Bristol), even though it is in the SQL file. I am completely baffled.

 

Bob.

[GlebeCS]

Vger

 

I did add it using an SQL file. The only 'county' it doesn't accept is London (but is does accept Mancheser and Bristol), even though it is in the SQL file. I am completely baffled.

 

Bob.

 

 

I had this problem, it seems it was a conflict between London and Londonderry, try changing 'Londonderry' to 'County Londonderry' in your SQL, this worked for me.

 

Andy

[boxtel]

Vger

 

I did add it using an SQL file. The only 'county' it doesn't accept is London (but is does accept Mancheser and Bristol), even though it is in the SQL file. I am completely baffled.

 

Bob.

 

that is because the zone check uses this wonderful "like" constuction which would result in 2 occurrences found and thus is an error message:

 

$zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name like '" . tep_db_input($state) . "%' or zone_code like '%" . tep_db_input($state) . "%')");