WRX in addresses

I don't have much to offer you.

There would seem to be two possible sources for the WRX: either the code or the database.

Try using a recursive grep to search the code. The database will be harder, but you might look in the table containing the country and zone information.

Try using just the minimum set of modules you can get away with and see if the problem goes away.

I'll try to check this out this weekend. Thanks for doing the search.

Ok, I looked into this a bit. I couldn't actually reproduce your results,

Let me ask you a few questions that might help track this down:

• Is the UK the only country that is enabled?
• In the Checkout Settings, is the State/Province field enable or disabled? Required or not required?
• In the database uc_addresses table, what value is being stored for the zone field?
• Go to the Store Admin > Orders page. View some orders. Do the addresses in the orders have the same problem with WRX or are they displaying properly?
• Go to the database uc_orders table. What values are being stored in the delivery_zone and billing_zone fields.

Thanks for your help.

I'm noticing this problem on our site. We are selling both downloadable videos and DVDs, therefore some orders have a shipping address and others do not. Therefore the shipping address block is enabled for the checkout page, but not displayed if the order has only downloadable items.

When reviewing a completed order (on a page such as "admin/store/orders/10") with no items to be shipped, the shipping address block is displayed as follows:

Ship to:

, WRX

This is the key issue:
If there is no shipping associated with an order, the Ubercart code is still storing "840" in the delivery_country field, and storing "0" in the delivery_zone field in the uc_orders table. If you look in the uc_countries table, 840 is the United States. If you look in the uc_zones table, 0 is Wrexham (WRX).

This is not the right way to handle this. Regardless of whether or not the shipping pane is enabled on the checkout page, nothing should be stored in the delivery fields in uc_order if the order does not have shippable items.

Sorry, I just realized this is specifically for uc_addresses. We're having this issue with core Ubercart. Hopefully the information I provided above may shed some light on the issue.

You'll need to report this to the Ubercart people. I have nothing to do with order addresses. I can only take the blame for addresses stored in the user's profile. :-)

There is probably a similar problem in the 5.x version of uc_addresses. It's been fixed in the 6.x version (see #368675: Non-shippable products error) and the 5.x version has not been a priority for me. That doesn't mean I won't fix it, it just means that it's lower in the queue. A good way to speed the fix is to send me a patch.

There is also a related bug I reported for the 6.x version of Ubercart: #374633: If no shipping address is requested, uc_order.ca.inc still tries to send email to delivery address.

Thanks for the info. I've been on vacation and just got back. When I have a moment, I'll try to verify your info and see if I can figure out the problem's source.

Hi, Dave,

I finally remembered I hadn't got around to looking at this.

I deleted my store address from the Shipping Quotes settings and from the Store Settings. I removed the !zone_code from both my US and Canada countries. I was not able to reproduce your problem.

I have backported a number of 6.x fixes into my 5.x-2.x-dev build, so you could try to update your uc_addresses version (keep the old one around as the updates haven't had a lot of testing), remove the store address and see if the problem has gone away.

If you don't want to do this, could you please let me know so I can close the bug report?

Hi everybody,
I had the same issue with the WRX showing up in the adress . I dont know what was causing it , but this is , how i bypassed this problem :

Go to "myPHPadmin" or whatever you are using to administer your databases . Export "uc_zones" table into CSV file and save in onto disc . Open it with notepad , find the line , where the WRX appears and replace the WRX with , for example , space. Save it , empty your existing table and import your modified version . ...your addresses should look now like this :

Name
Street
City, zipcode
country

The space will appear there , but its completely harmless and customer wont notice it .

Good luck everybody !

cheers
Tomas Karafa
Czech republic

I think that this occurs due to the following code in the uc_store.module:

/**
 * Format an address for display based on a country's address format.
 */
function uc_address_format($first_name, $last_name, $company, $street1, $street2, $city, $zone, $postal_code, $country) {
  $result = db_query("SELECT * FROM {uc_zones} WHERE zone_id = %d", $zone);
  if (!($zone_data = db_fetch_array($result))) {
    $zone_data = array('zone_code' => t('N/A'), 'zone_name' => t('Unknown'));
  }

Because there is a zone 0, the query will always return something if $zone is 0, NULL, or FALSE, so the (N/A, 'Unknown') result will not be used as expected.

Removing the !zone_code from your address format should keep the WRX from showing when it's empty, but would also prevent addresses that do have state/province info from displaying their abbreviations.

Sounds good to me. I'm closing this bug. If someone would like to file a bug for Ubercart, feel free.