Deleted shopper and now can't login to Joomla as admin

[SuitedScooter]

Hi there,

First time user. Just finished building my website, installed Virtuemart and loaded my products etc.
Then noticed, during testing of the Cart, that MY details auto populated as the shopper.
I deleted the only shopper and Joomla (or VM) kicked me out of Joomla.
Trying to login to Joomla gives me:
"Username and password do not match or you do not have an account yet."

The Joomla Admin username and the VM shopper username were different.

I don't know how to resolve it.

Do you have any ideas?

Joomla 3.10.22 (If I remember correctly)
VM 3.8.8.10472
Temp URL is http://49.50.249.34/~delightsweet/administrator and http://49.50.249.34/~delightsweet/

Thanks for any help.

[SuitedScooter]

Looking into the SQL Database, I was unable to find ANY users.

So, I followed these instructions (to create a new Super User) (but still can't log in).

Login to phpMyAdmin.

Select the database that is used for your Joomla website. You can know which database is used on your Joomla website by checking the $db value in the configuration.php file.

Click on the SQL tab, and then run the following queries (replace #__ with your database prefix, which is the value of the $dbprefix variable that can be found in your configuration.php file WHICH I DID):

INSERT INTO `#__users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES (1000000, 'tempsuperuser', 'tempsuperuser', 'youremail@yourjoomlawebsite.com', MD5('temppassword'), '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', '0', '', '', '0');

INSERT INTO `#__user_usergroup_map` (`user_id`, `group_id`) VALUES ('1000000', '8');

[jenkinhill]

Standard Joomla repair:

Register a new Joomla account in the site frontend.

Open the site database in phpMyAdmin

Look in the table ###_users and note the id for your new user.

Open the table ###_user_usergroup_map  edit the entry with your new user id to change the group_id to 8 (ie super user) Save the edit.

Then log into backend as your new user.

[GJC Web Design]

and once there if the new super user isn't already the shop admin (vendor) then fill in the details in VM->Shop-> Shop (Vendor)

there may be still a non existing user id registered as the vendor .. you can change to your new id with VM->Tools->Tools & Migration->Write here the new store owner id

[SuitedScooter]

OMG  !!
@ jenkinhill and GJC Web Design.
You guys are the bomb. THANK YOU. THANK YOU. THANK YOU.

I was feeling rather down last night (when I posted my request for help) thinking I was going to have to start all over again.
You guys really are SUPER HEROES.

Happy New Year to you and your families, May 2022 be much better than 2020 and 2021 combined.
With kind regards.
Me