View Full Version : I cannot login anymore..
09-09-2008, 06:42 PM
I'm afraid I forgot my passwd and now I cannot login anymore.. (I installed more than a year ago, and now I want to add photos)
Can someone help me please?
09-09-2008, 07:13 PM
I'm always thrown back to the log-in page, I was pretty sure about my name and passwd..
I do not have an emailrecovery button
and this does not work neither, I get a blank page..:
"Place this file (password_recovery.php) in the root of your site and run it. Fill in all questions and you will have a totally new and fresh password"
09-10-2008, 05:26 AM
johnvdv: do you have access to PHPMyAdmin?
09-10-2008, 10:19 AM
yes I have
09-10-2008, 04:23 PM
you can execute a query to update the password then.
UPDATE `pixelpost_config` SET `password`=MD5('yourpassword') WHERE `id`=1
If your username is still admin you can change it to something less obvious:
UPDATE `pixelpost_config` SET `admin`='newusername' WHERE `id`=1
09-10-2008, 05:58 PM
Thank you for your answer Dennis
UPDATE `pixelpost_config` SET `password` = MD5( 'mypsswd' ) WHERE `id` =1
MySQL said: Documentation
#1146 - Table 'johns_fotothing.pixelpost_config' doesn't exist
I do not know what I am doing wrong here, but I have never tampered with db before..
09-10-2008, 06:11 PM
OK, error is gone. (it was because I changed the name from pixelpost to photopixel),
but now i am stuck here and I'm afraid to mess up my databases:
"You have to choose at least one column to display"
and I have to choose a field, and sort, show ?
09-11-2008, 05:48 AM
Uhm, if you executed the query and it returned something like "One row affected" you're good to go.
That is it.
vBulletin® v3.7.3, Copyright ©2000-2013, Jelsoft Enterprises Ltd.