Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I'm using Drupal 6.10 and UC 2.0-beta5. I am testing the checkout area and discovered that the "State" pull-down menus for billing and shipping addresses list the U.S. states/territories and Canadian provinces in duplicate. Actually any form that calls for states show in duplicate.
#1 Is this a problem?
#2 Where should I look to fix it?
#3 Could it interfere with the shipping conditions or UC's ability to accurately quote a shipping rate.
I have created a number of shipping methods (7) - all flat rate. When I created the shipping conditions initially I know the states were only listed once.
Now, a few weeks later, they show up in duplicate at checkout and when setting the shipping conditions.
I've only changed two things in between those events - 1. Upgrade to beta5, 2. Install uc_edi for Drupal 6.
uc_zones table in the mysql database seems to be intact. Values only listed once.
Any ideas?
Thanks,
snepa
Comments
Comment #1
cha0s commentedI'd say you might wanna wait to fix this, in lieu of #357201: Cannot create products with addresses in countries other than the site's default, I'd like to get the AHAH stuff on all those select elements, so perhaps that will have a side-effect of solving this problem...
Comment #2
rszrama commentedOut of curiosity, are the rows duplicated in the uc_zones table in your database?
Comment #3
snepa commentedrszrama,
Yes in fact, they are listed twice. This was the first thing I checked before, but being a numskull, didn't think to sort by zone name. The list goes through zone_id 78 then starts over and repeats going through zone_id 156.
Should I just delete the duplicated rows with zone_id's 79-156?
thnx,
snepa
Comment #4
snepa commentedrszrama,
Ok. Fixed. Sorry to bother. You can close this one out. Thanks for asking the simple question and making me go back and double check.
What makes it even better is that, in my pride, when you asked about the uc_zones table, I was thinking, "huh, check the uc_zones table - don't you think that was the first thing I did. Give me some credit..." ; )
ahhh, humility...
snepa
Comment #5
rszrama commentedlol - glad it worked out. ; )
The real question is how you ended up with two entries... that's rare, but I'll know to dig in if someone else turns up the problem.
Comment #7
dboulet commentedI ended up with this same problem. I was able to fix it by deleting the extra entries in the uc_zones table, but there definitely is a bug somewhere causing this.
Comment #8
tr commented@dboulet: Same problem? Did you upgrade to beta5 as well? Or just same symptom? The most likely cause of something like this, if it's a problem with Ubercart, is a bad database update function which is run only during an upgrade. So it would be highly dependent upon what version you upgraded *from* and what version you upgraded *to*. Definitely need more information on that in order to proceed.
Comment #9
tr commentedI'm going to close this one out. If you can reproduce the error with the current version of Ubercart please feel free to open it again.
Comment #11
ktf commentedDon't want to re-open this unnecessarily, but this bug just got me too, on UC 2.9. Haven't been able to figure out how to reproduce yet though. Hopefully it's safe to just kill the dupes from the database...
Will report back if I figure out what caused this.
Comment #12
longwaveComment #13
tr commentedMaybe you can answer #2?
Comment #14
tr commentedNo further information provided.