New Users shipping address autopopulated with random user!

[GooRu]

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

[PRO]

this might be the problem,
http://forum.virtuemart.net/index.php?topic=44776.msg157392#msg157392

it was for 1.1 but sounds right

[GooRu]

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?

[PRO]

the table
user_usergroup_map

maps vmart and other component info to the joomla user id

[GooRu]

PRO...

I did find that table but what would I do with it?

[GooRu]

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 ?

[GooRu]

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

[PRO]

go to extension manager, database.

& then fix problems

[GooRu]

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

[PRO]

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  ?

[GooRu]

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?

[PRO]

thats why I said create an account.

then go an change the numbers