VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: GooRu on December 29, 2013, 02:41:10 AM

Title: New Users shipping address autopopulated with random user!
Post by: GooRu on December 29, 2013, 02:41:10 AM
Hi...

That's right, when a new user registers, then adds items to the cart and visits the cart, their address is auto populated with a random users information! What's up with that?

The Bill to info which is not available via the joomla registration, is auto filled with another users address.

version: 2.0.26a
J! 2.5

Title: Re: New Users shipping address autopopulated with random user!
Post by: PRO on December 29, 2013, 03:03:47 AM
this might be the problem,
http://forum.virtuemart.net/index.php?topic=44776.msg157392#msg157392

it was for 1.1 but sounds right
Title: Re: New Users shipping address autopopulated with random user!
Post by: GooRu on December 29, 2013, 03:45:52 AM
Pro...

That does look like it would be it, but I notice that the Joomla user created is the same as the VM user created, at least the ID's are the very same.

Any other ideas?
Title: Re: New Users shipping address autopopulated with random user!
Post by: PRO on December 29, 2013, 13:37:55 PM
the table
user_usergroup_map

maps vmart and other component info to the joomla user id

Title: Re: New Users shipping address autopopulated with random user!
Post by: GooRu on December 29, 2013, 17:17:00 PM
PRO...

I did find that table but what would I do with it?
Title: Re: New Users shipping address autopopulated with random user!
Post by: GooRu on December 29, 2013, 18:43:49 PM
So I think the same problem that happened in VM 1.1 is happening in 2.2 and here is why

This is a migrated site from J! 1.0 and appears not all the users came through so we have new users in the joomla core with a lower ID then the new user created in Virtuemart.

So according to the fix for vm 1.1 I need to do this, but I need help in targeting the right VM 2.2 table.

ALTER TABLE table_name AUTO_INCREMENT = 2000

That set the autoincrement to 2000



I think this is the table? virtuemart_userfield_values ?
Title: Re: New Users shipping address autopopulated with random user!
Post by: GooRu on December 29, 2013, 20:23:20 PM
Hi...

What would be the SQL statement needed to make the user id's increment then?

ALTER TABLE table_name AUTO_INCREMENT = 2000

would it be:

ALTER TABLE user_usergroup_map AUTO_INCREMENT = 2000
Title: Re: New Users shipping address autopopulated with random user!
Post by: PRO on December 30, 2013, 16:44:24 PM
go to extension manager, database.

& then fix problems

Title: Re: New Users shipping address autopopulated with random user!
Post by: GooRu on December 30, 2013, 17:48:18 PM
Pro...

No result, I'm still short in users in Joomla, compared to VM so when a new VM user is created it is matched with a joomla user with a similar ID. If I can get Joomla users up or at least change the ID to a higher auto increment I can get this done. The link you provided aluded to this but my sql syntax did not work on the db
Title: Re: New Users shipping address autopopulated with random user!
Post by: PRO on December 31, 2013, 00:42:11 AM
register,
then go into the database, and fond your row.
Then change the ID
do the same for all the tables you need.
you dont have to do a statement. just edit the #

but, you still said you do not have the user group MAP  ?
Title: Re: New Users shipping address autopopulated with random user!
Post by: GooRu on December 31, 2013, 03:31:46 AM
Hi..

I do have  user group MAP

But I see less users in joomla then in VM and this is what may be mismatching the users. I need to get the auto increment in sync no?
Title: Re: New Users shipping address autopopulated with random user!
Post by: PRO on December 31, 2013, 10:07:43 AM
thats why I said create an account.

then go an change the numbers