VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: baroen on April 30, 2012, 16:52:14 PM

Title: Table userinfos check failed: Unknown address_type
Post by: baroen on April 30, 2012, 16:52:14 PM
I am (trying to) migrating from VM 1.5.25 to 2.0.6.
When hitting the 'Start Migration' button in Virtuemart migration section I get a maxed of 1000 lines with:
vmError: Table userinfos check failed: Unknown address_type

There are no customers imported and obviously also no orders.

What can I do to fix this?
Title: Re: Table userinfos check failed: Unknown address_type
Post by: ocean1 on May 09, 2012, 10:31:36 AM
I had the same error after migration from VM 1.9 to 2.0.6
We are working in JM 1.5.26
Title: Re: Table userinfos check failed: Unknown address_type
Post by: baroen on May 14, 2012, 16:27:58 PM
I -kind of- fixed this by going through the upgradeconversion process one item at a time.
Title: Re: Table userinfos check failed: Unknown address_type
Post by: Milbo on May 16, 2012, 11:58:01 AM
Please try the latest version 2.0.7. We found some small errors in the migrator, imho also mechanics like, when there is not BT or ST stored, assume BT and things like this.
Title: Re: Table userinfos check failed: Unknown address_type
Post by: lucrus on July 17, 2012, 18:24:10 PM
Same problem here, trying to migrate from VM 1.1.6 to 2.0.8c

@baroen: what is the upgradeconversion process?
Title: Re: Table userinfos check failed: Unknown address_type
Post by: airone93 on July 29, 2012, 12:44:43 PM
Same problem here.
VM 2.0.8e
Orders and items already migrated ok.

configuration->migrate->users:
User accounts migrated ok, except addresses!

only two error lines:
vmError: Table userinfos check failed: Unknown address_type
vmError: Table userinfos check failed: Unknown address_type
Title: Re: Table userinfos check failed: Unknown address_type
Post by: rossi256 on September 04, 2012, 21:34:33 PM
Same problem with VM 2.0.10 and J2.5.6
Anybody found a solution for this?
Title: Re: Table userinfos check failed: Unknown address_type
Post by: maxxer on October 30, 2012, 18:26:19 PM
same here with latest 2.0.12f, any help appreciated...
Title: Re: Table userinfos check failed: Unknown address_type
Post by: mzwarg on October 30, 2012, 20:44:10 PM
I have the same problem using v 2.0.12f.  Thanks ahead of time.
Title: Re: Table userinfos check failed: Unknown address_type
Post by: MAtkins on November 22, 2012, 12:38:04 PM
Quote from: Milbo on May 16, 2012, 11:58:01 AM
Please try the latest version 2.0.7. We found some small errors in the migrator, imho also mechanics like, when there is not BT or ST stored, assume BT and things like this.

I'm using the LATEST Virtuemart version 2.0.14 and I'm getting the exact same problem.

Joomla!       2.5.8
Virtuemart   2.0.14

It might not be so bad except there is a 'max messages' limit apparently that forces the script to stop.
I can't really tell whether or not it's entering the records correctly.
In spite of the error the address_type field is being filled in correctly until it chokes on the 'message limit'.

I cannot get the migration to work.
Title: Re: Table userinfos check failed: Unknown address_type
Post by: Rune Rasmussen on June 10, 2013, 11:54:05 AM
Quote from: Milbo on May 16, 2012, 11:58:01 AM
Please try the latest version 2.0.7. We found some small errors in the migrator, imho also mechanics like, when there is not BT or ST stored, assume BT and things like this.

Got same error in 2.0.20b...?
Title: Re: Table userinfos check failed: Unknown address_type
Post by: pflaume on October 11, 2013, 20:33:59 PM
anyone solved the problem??
Title: Re: Table userinfos check failed: Unknown address_type
Post by: Maxim Pishnyak on October 12, 2013, 09:01:16 AM
http://forum.virtuemart.net/index.php?topic=119426.msg406608#msg406608
Title: Re: Table userinfos check failed: Unknown address_type
Post by: admiss on January 29, 2014, 21:03:08 PM
Hello,


VirtueMart 2.0.26d
Joomla 2.5.17
Responsive template
Multilingual site

After I was happy to getting rid of the "vmError: Model Userfields, country with id United Kingdom not found "
I got another error, when editing ship­ment address:
vmError: Table userinfos check failed: address_type ST without name
vmError: Was not able to save the VirtueMart user data


Sometimes it changes to "User data stored." Although, I haven't touch settings.

In Shopper Field [ Edit ] address_type_name (Address Nickname) IS "Published" and "Show in shipment form" set on YES.
Properly speaking, I even don't understand, why is address_type_name (Address Nickname)  important  at all?!

I don't think, I use old versions of VM+Jla.

I haven't found useful information about this error on forum.
Only here https://code.google.com/p/universal-project/source/browse/trunk/tmvbeautywebsite/administrator/components/com_virtuemart/tables/userinfos.php?r=2457#126 (https://code.google.com/p/universal-project/source/browse/trunk/tmvbeautywebsite/administrator/components/com_virtuemart/tables/userinfos.php?r=2457#126)
is coded something about address_type (line 126)
I am not familiar with coding (neither with german), so quick response would be highly appreciated.

Thank you!


[attachment cleanup by admin]
Title: Re: Table userinfos check failed: Unknown address_type
Post by: admiss on January 30, 2014, 08:45:05 AM
Hi,

That's what I was talking about. Add/Edit shipping addr. is working NOW. I HAVEN'T changed any settings! I tested it as Guest, Registered (Logged in)  user, Super User (admin)
I just cannot imagine, what is happening . . .
But this "once working - once not" syndrom can be detected at checkout also, when one you are redirected to to PayPal site - once not (in this case after "Please select a pay­ment method - Save" it redirects you to the Shopping Cart page)

[attachment cleanup by admin]
Title: Re: Table userinfos check failed: Unknown address_type
Post by: AzMan on May 04, 2014, 12:37:18 PM
What you need to do is to open the table jos_vm_user_info and search by query SELECT * FROM `jos_vm_user_info` WHERE address_type_name IS NULL;
It will most probably give a result with some number of entries.

I have run a custom SQL query for that table.
UPDATE `jos_vm_user_info` SET address_type_name = "-default-" WHERE address_type_name IS NULL

And this helped me to solve the problem with migration when vmError: Table userinfos check failed: address_type ST without name error occurs