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

This has just happened to me - anyone have any ideas?

I've had this problem. I'm extremely bothered that no-one else has complained about the countries being messed up...

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.
 
WBR,
ViArt Support Team

We have created a universal patch for mixed up data in orders and users tables. More information is available in Announcements section here:
http://www.viart.com/patch_for_orders_and_user_data_after_upgarde_and_fix_of_admin_upgrade_php_for_releases_3_4.html
 
WBR,
ViArt Support Team

Eugene, link seems broken (08:14)