Guest Posted June 3, 2005 Share Posted June 3, 2005 Does anyone know how to solve an issue regarding London. When one chooses London from the County menu in account set-up it causes an error and goes round in a loop. many thanks Si Quote Link to comment Share on other sites More sharing options...
crash3903 Posted June 3, 2005 Share Posted June 3, 2005 not experienced this b4 - url? Quote Regards Mark A Reynolds Link to comment Share on other sites More sharing options...
Guest Posted June 7, 2005 Share Posted June 7, 2005 not experienced this b4 - url? <{POST_SNAPBACK}> Hi Mark Thanks for the reply. Here is the test URL. http://www.kiono.co.uk/catalog/create_account.php If you then fill in your details and choose London as your county it doesn't like it. Any other county works fine - Londonderry for example. I have tried deleting and re-entering the field in admin but no luck. I am using the UK install files. Any advise will be most welcome! Thanks Si Quote Link to comment Share on other sites More sharing options...
Guest Posted June 19, 2005 Share Posted June 19, 2005 Did anyone make any headway with this? I have precisely te same problem. Surely it must be the same for any major UK town. What would a buyer from Manchester put in as the county for example? Quote Link to comment Share on other sites More sharing options...
Guest Posted June 19, 2005 Share Posted June 19, 2005 Hi Didn't really get anywhere - I decided that London was likely to be more popular than Londonderry! I therefore changed Londonderry to 'Londonerry' and this then allows London to be selected. It seems to be linked to the TAX codes. It is quite strange because the TAX code then comes up in the address which is very confusing for the customer. I changed all the Codes to the standard names which has solved the code display problem. I agree with you, a not required or a blank field would be better. It seems more complicated than it needs to be. Let me know if you come up with a solution becasue I am new to all this! Any help out there would be much appreciated cheers Si Quote Link to comment Share on other sites More sharing options...
Guest Posted June 19, 2005 Share Posted June 19, 2005 Hi Simon, Well in a similar desperate move I ended up adding a 'No County' option to the database (so it appears in the County drop-down) with nothing in the value field so that addresses are still formatted correctly. The only problem with that is I then had to add (or 'No County') next to each of the 'State' (or in my case 'County/State') fields and there a few of them - one in each place you can edit/add an address. Interestingly I notice the list of counties is not comprehensive anyway; where's 'West Midlands' for example? I know there's a contribution with a complete set of UK Counties in but I don't want to risk screwing my database. Maybe I'll be kind and add the missing ones manually. Like you, I'm new-ish to this too although I do have a techie background. I figure you just have to backup/tweak/check in that order every time you make a change. You must give yourself a return path for when you screw it all up! Good luck Quote Link to comment Share on other sites More sharing options...
crash3903 Posted June 19, 2005 Share Posted June 19, 2005 Simon Sorry for the delay - i have justed looked at the url and there is no option for the county selection sorry time got the better of me where is the problem located Quote Regards Mark A Reynolds Link to comment Share on other sites More sharing options...
Guest Posted June 19, 2005 Share Posted June 19, 2005 Hi Mark http://www.kiono.co.uk/catalog/create_account.php Basically, it isn't too serious but it seems crazy to force the user to choosing a county from the menu especially if it is incomplete. Why is it forced? Is it for the TAX CODE. If so, VAT is the same everywhere in the UK. Is there a way of making it a normal Text Field and allow the user to simply write their own county in the format they choose? Thanks for your help Simon Quote Link to comment Share on other sites More sharing options...
radders Posted June 19, 2005 Share Posted June 19, 2005 Just delete all the UK counties. I did (although I also have a list of all the counties if you need it). The thing is the post office doesn't really require the county anyway so as long as they fill in the postcode - no problem. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 19, 2005 Share Posted June 19, 2005 Thanks Does that have any repurcussions with the VAT situation and tax zones? Once they are delted, can the user type anything in and they won't be asked to choose from the drop-down. Do you have an example link to your site? cheers Si Quote Link to comment Share on other sites More sharing options...
wider Posted July 18, 2005 Share Posted July 18, 2005 Hi, after a bit of trying, I've come to the following solution. Either rename your "London" to "Greater London" using phyMyAdmin, or change create_account.php, line 105 to: $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_name like '%" . tep_db_input($state) ."' or zone_code like '" . tep_db_input($state) ."%' )"); That accepts "London", something like "Londo..." and "Londonderry" if your county is named "County Londonderry". It's probably not 100% ideal, but a great deal better than losing all sales from London. :D Quote Link to comment Share on other sites More sharing options...
radders Posted July 18, 2005 Share Posted July 18, 2005 Thanks Does that have any repurcussions with the VAT situation and tax zones? Once they are delted, can the user type anything in and they won't be asked to choose from the drop-down. Do you have an example link to your site? cheers Si <{POST_SNAPBACK}> I'm not sure about tax zones etc. as all my zones have the same tax rate at the moment. People can indeed type in what they like in county if you do it as I did - see the link to my site on the left of this message. Quote Link to comment Share on other sites More sharing options...
ThatMan Posted August 19, 2005 Share Posted August 19, 2005 This is how I solved the problem Thread Link Steve Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.