Print Page - Required fields empty

Title: Required fields empty
Post by: ArchiB on October 13, 2017, 16:17:15 PM

Hi all,

I have a bunch of people that have required virtemart fields that are empty. (they probably were in the joomla before the virtuemart fields were required)

I need to change the groups of some of these people. I tried looking in the DB, because when I do it in virtuemart, is says the required fields are empty, but I can't find where this info is located.

I also have a bunch to do, so doing them one by one is not the best solution. Although I will do it if there isnt another faster option.

Where can I find the info in the DB (or file) so I can make the changes and bypass the required fields?

Thanks for the help!

EDIT: yep sorry forgot the versions...

Joomla 3.8.1
Virtuemart 3.2.4
PHP 7.1.10

Title: Re: Required fields empty
Post by: jenkinhill on October 13, 2017, 16:53:54 PM

http://forum.virtuemart.net/index.php?topic=79799.0

Title: Re: Required fields empty
Post by: ArchiB on October 13, 2017, 17:11:19 PM

I added it to the first post. Thanks and sorry about that.

Title: Re: Required fields empty
Post by: jenkinhill on October 13, 2017, 17:53:17 PM

Thanks.

The shopper field data is stored in ###_virtuemart_userinfos where virtuemart_user_id is the same as id in ### _users for matching purposes.

Title: Re: Required fields empty
Post by: ArchiB on October 13, 2017, 18:45:16 PM

Thanks.

It got me on the right path.

I was looking for ###_virtuemart_vmuser_shoppergroups

That is where I can set the shopper groups for the correct ###_virtuemart_user_id

Thanks again!

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: ArchiB on October 13, 2017, 16:17:15 PM