Unable to Login!

[futura]

Hi there,

I've come across a slight problem with my photoblog... I can't login. For the last few months I've just been relying on autocomplete and guess what, it asked me to enter my details again and I've forgotten my username and password.

Can anyone help?

Cheers,

Andy

[raminia]

I'm going for lunch but I'll help you. you can search forum for "lost password" and you'll find the thread.

[futura]

Hi - I did a quick search and came across a thread where another user was having the same problem. They mentioned that a moderator had sent them some sql to run against their database and that seemed to solve the problem.

[raminia]

Hi (after lunch;) )

Do you have you're own server?
Do you have access to CPanel? (or any other control panel for your site)
Which version of PP do you use?
Did you set a email address in admin panel of PP?

[raminia]

if you have Cpanel then

1- if you have pp v1.3
try this query in phpmyadmin in cpanel
UPDATE pixelpost_config SET `password`='mynewpassword'

and it will be ok

2- if you have pp v1.4.x
try this query in phpmyhadmin in cpanel
UPDATE pixelpost_config SET `password`=MD5('mynewpasssword')

OR

if you have set email address in version 1.4.x you can submit it and receive a new password by email through password recovery feature.

[futura]

Thanks for helping me out raminia, worked a treat!

[raminia]

you're welcome

and please tell us which solution worked for future refereces.

[futura]

As I my site uses pixelpost 1.4.1 I ran -

UPDATE pixelpost_config SET `password`=MD5('mynewpasssword')

against my database from the mySQL CPanel.

Cheers

[Mohib]

I am also facing the same problem. I am on a holiday in India and can't remember my password now.

I tried password recovery but I get this message,
Database error:
Updating the new password failed. Back to admin page

I also ran this query through phpmyadmin, but am not sure what to do next.
UPDATE pixelpost_config SET `password`=MD5('mynewpasssword')

Please help, thanks a ton.

Best,
Mohib

[riken]

Now try logging in using the password you just set.

UPDATE pixelpost_config SET `password`=MD5('mynewpasssword')

This line basically sets the admin password to what is in the quotes at the end. So for example to set the password to 'frogbeetle' you would do:

UPDATE pixelpost_config SET `password`=MD5('frogbeetle')

Run the line and then try to log in.

[raminia]

1.4.x has a bug in password recovery!

[Mohib]

Thank you, it is working fine now.

Mohib

[jrandall]

Thanks for this thread! It just saved me.

[jaywilliams]

Thank you so much!

I forgot my password, and when I tried to use the "Forgot Your Password" form it totally reset the password, and didn't tell me what it was!

the command
UPDATE pixelpost_config SET `password`=MD5('mynewpasssword')
worked great!

It saved the day!

Thanks!