_users database cannot be edited

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
fzp0
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Nov 22, 2023 6:37 pm

_users database cannot be edited

Post by fzp0 » Wed Nov 22, 2023 6:45 pm

Hello, i just got access to a server with Joomla! CMS 3.10 installed on it. The previous administrator unfortunately did not provide me with administrator panel access. So I followed the guide https://docs.joomla.org/How_do_you_reco ... assword%3F
The problem is, when I edit the existing admin account's password or add a new one using phpmyadmin, my changes to the databse revert after a few seconds. Has anyone had this kind of issue? If yes, how did you fix it?

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9874
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: _users database cannot be edited

Post by AMurray » Wed Nov 22, 2023 9:56 pm

Did you actually save the change in the database? You need to click "Go" (or a similarly labelled button) in phpmyadmin to execute the SQL query to effect the change.

This is done at the database level so I don't see Joomla being the issue.

Are you editing the correct record?

Never had this happen, but very rarely need to use that method for resetting of Admin password. Side issue but are you also resaving that record with the relevant encryption (If not, I don't know why that would cause it to revert to old detail).
Regards - A Murray
General Support Moderator

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44150
Joined: Sat Apr 05, 2008 9:58 pm

Re: _users database cannot be edited

Post by Webdongle » Thu Nov 23, 2023 12:12 am

Have you tried editing the configuration.php file or adding another Super Admin?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".


Post Reply

Return to “General Questions/New to Joomla! 3.x”