JUser: :_load: Unable to load user with ID: 62

Hi, in backend when i go to virtuemart component/shop it appears "JUser: :_load: Unable to load user with ID: 62" how can i get rid of it? i don't have any user with id 62.

Hi,

We sometimes also get that error. When you go to Shop edit page, VirtueMart try to sync the user of Joomla! with VM user (62 ussually for Joomla! Administrator account) but for some reason (we create new user for admin and default 62 is removed for security; install from quickstart demo and new admin user id created but VM still remember old id, etc.).

A solution can be used:
Use phpMyAdmin or any mysql tool to change the user id from the record in table `PREFIX_virtuemart_vmusers` from 62 to the real number(your current admin user id) where PREFIX is depended on your installation.

Thanks

i am getting this error
I created a new admin but the id is still 62
how do i get the proper id for the database table correct instead of 62

erikken wrote: i am getting this error
I created a new admin but the id is still 62
how do i get the proper id for the database table correct instead of 62

Hi,
You can use phpMyAdmin to browse the database and in the SQL tab, paste this code and run:
where PREFIX is your table prefix.

Then go to backend to retry.

Thanks

after running the query with the prefix replaced with my actual database prefix the result was:

UPDATE `PREFIX_virtuemart_vendors` SET `created_by`=0, `modified_by`=0;# MySQL returned an empty result set (i.e. zero rows).

UPDATE `PREFIX_virtuemart_categories` SET `created_by`=0, `modified_by`=0;# MySQL returned an empty result set (i.e. zero rows).

UPDATE `PREFIX_virtuemart_products` SET `created_by`=0, `modified_by`=0;# MySQL returned an empty result set (i.e. zero rows).

Hi,
@erikken: Sorry, where did you get this error? Virtuemart or K2 or fontend homepage?
If not Virtuemart, run this:
Thanks