After update to 3.4 the admin orders page
Admin_orders.php countries to be all mix up.
All the countries are mix up. So now I don't know where my customers are from.
For the new orders, everything is fine. But all the old orders everything is mess up. What cause that bug?
Also I lost the taxes settings and the US states are no longer map with United-State (Country)
The page: admin_states.php
your-shoppingcouk
21 Mar 2008 10:40 PM
This has just happened to me - anyone have any ideas?
TOCDCO
23 Mar 2008 10:34 PM
I've had this problem. I'm extremely bothered that no-one else has complained about the countries being messed up...
Eugene (Guest)
24 Mar 2008 4:29 PM
Hi,
Here is a quick patch for databases that support sub queries (e.g. MySQL version 4 and 5).
In order to fix the problem please run these 4 queries to your viart database. Don't forget to make a database backup first.
UPDATE va_orders o
SET country_id = (SELECT country_id FROM va_countries s WHERE s.country_code = o.country_code)
WHERE NOT ISNULL(o.country_code);
UPDATE va_orders o
SET delivery_country_id = (SELECT country_id FROM va_countries s WHERE s.country_code = o.country_code)
WHERE NOT ISNULL(o.delivery_country_code);
UPDATE va_orders o
SET state_id = (SELECT state_id FROM va_states s WHERE s.state_code = o.state_code)
WHERE NOT ISNULL(o.state_code);
UPDATE va_orders o
SET delivery_state_id = (SELECT state_id FROM va_states s WHERE s.state_code = o.state_code)
WHERE NOT ISNULL(o.delivery_state_code);
Later on we shall create more universal patch that can be run on any database system.
