News:

Support the VirtueMart project and become a member

Main Menu

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

Started by SuitedScooter, January 01, 2022, 08:48:35 AM

Previous topic - Next topic

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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