December 16, 2018
I built a site on my local pc under localhost a while back using Pligg and am now getting back to it after a few years gap. Needless to say I can't remember my passwords. I can access the database using phpmyadmin and have tried changing the password manually by entering new value, selecting md5 as the function against user_pass and then updating the record. I'm fairly certain I updated to the last version of Pligg.
Hello Paul and welcome to Plikli Community!
Yes, it won't work the way you entered a hashed password because the password is hashed along with other info upon registration or changing it.
You can tell the version of the Pligg you are using by going to phpmyadmin and select the misc_data table. It should be the first entry under pligg_version.
The easiest way that I can think about is:
From phpmyadmin, users table:
1- modify your admin username, just add or remove one character.
2- modify the email by adding or removing one character.
Open your browser and navigate to the pligg instance on your localhost
1- Register an account using the original admin username and email or new ones, as you wish.
2- Go back to phpmyadmin, users table
3- Change the user_id original admin entry that you modified to any number that is not taken (maybe before doing this, click on the "Operations" at the top of the users table to find the last auto increment number to use.)
4- modify the user_id of the newly registered account to 1
This way you have restored the original admin account.
I will be remiss not to inform you that all Pligg versions, even the latest ones 2.0.2 and 2.0.3, and consequently all Kliqqi versions (CMS created after Pligg has been sold) are not safe and have a lot of security vulnerabilities and broken features with a lot of bugs.
All this has been fixed in Plikli 4.1.0 and still working on fixing any vulnerabilty that may surface immediately. In addition, Plikli has more features, settings and modules.
You can migrate from Pligg to Plikli easily if you have any version:
Pligg versions 1.2.2; 200rc1; 200rc2; 2.0.0; 2.0.1; 2.0.2; 2.0.3
Kliqqi versions 3.0.0; 3.5.0; 3.5.2
Check the Documentation (installation and requirements and migrating to Plikli from the top menu.
Let me know if you need assistance.
December 16, 2018
Sorry didn't see that you had posted a reminder posting above. Retiring, Christmas and New Year got in the way of trying out your suggested fix.
The Pligg version is 2.0.0.
I did what you said, amended to original admin record, registered a new account and gained access as a user to the dashboard. However, when I logged out and tried logging back in with the new account it comes up with incorrect username password. I think there is something more fundamentally wrong with the installation and have sort of abandoned it and done a fresh install in a different directory. Hopefully as I work through the dashboard I will remember what I did before.
I made some extensive changes to some templates. I will run them through winmerge first to see how the files compare.
Most Users Ever Online: 16
Currently Browsing this Page:
Nishant kumar: 33
Martin Gold: 22
Guest Posters: 0