Author Topic: Deleted shopper and now can't login to Joomla as admin  (Read 350 times)

SuitedScooter

  • Beginner
  • *
  • Posts: 8
Deleted shopper and now can't login to Joomla as admin
« on: January 01, 2022, 08:48:35 am »
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

  • Beginner
  • *
  • Posts: 8
Re: Deleted shopper and now can't login to Joomla as admin
« Reply #1 on: January 01, 2022, 09:13:00 am »
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

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28263
  • Always on vacation
    • Jenkin Hill Internet
Re: Deleted shopper and now can't login to Joomla as admin
« Reply #2 on: January 01, 2022, 12:59:13 pm »
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.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.9.10473 on Joomla 3.9.28 PHP 7.4.14

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10343
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Deleted shopper and now can't login to Joomla as admin
« Reply #3 on: January 01, 2022, 13:09:40 pm »
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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

SuitedScooter

  • Beginner
  • *
  • Posts: 8
Re: Deleted shopper and now can't login to Joomla as admin
« Reply #4 on: January 01, 2022, 23:26:58 pm »
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