HELP! Password Problem

[Brookston]

I recently upgraded both of my photoblogs from 1.4.2 to 1.4.3. One is fine, but the other won't let me log in, saying the password is incorrect. Okay, fine. So I tried to use the passreminder function, but when I do so and click on the "send new password" button, I get the following:

Database error:
Updating the new password failed. Back to admin page

When I click on the "Back to admin page" link, I get this:

The username you have mentioned is not the same as the admin user of Pixelpost.
Back to admin page

But, of course, I'm quite certain of my username. Though to be fair I'm quite certain of password that it doesn't recognize, either. So it appears that somehow during the upgrade (though I suppose it could be a coincidence) I lost my username and password information. Does anybody know where it is listed in the files so that I can change in manually? Or is there another way to fix this. Help, please. Thanks. J

[eon]

If you have phpMyAdmin you can change the password directly in the db. Don't forget you have to set the function on MD5.

[Brookston]

Sadly, I don't have access to phpMyAdmin. I'm using a friend's server space he uses for his business and he's been very good about it. So I don't like to bug his tech guy unless I absolutely have to. He's trying to run a business, after all whereas I'm just goofing around. I suppose I could ask him as a last resort, of course.

One other possible wrinkle, though. I'm running to photoblogs on the same database along with several other WordPress blogs using different table prefixes. I don't know if that makes a difference but I though I'd mention it just in case.

Thanks again, J

[eon]

I don't know, sorry. Did you search already in this forum about the problem?

[Brookston]

Yes, I searched for "password" and "lost password" but all the fixes involve what you suggested. It did also appear that the code to use is for a single database change:

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

I'm not sure, but is the "pixelpost_" part of "pixelpost_config" the database table so that to change the password for a specific table in my database I'd need the code to me "myphotoblogtablename_config" blah blah blah? If so, then it looks like the only thing to be done is send the correct code to my server tech guy and ask him to run it in phpmyadmin. I just wish there was a way around that. C'est la vie.

Thanks again, J

[GeoS]

The last paragraph is correct - send your SQL UPDATE statement to tech guys and they should run it for you.

[eon]

I didn't test it but I think it is safe.
Place this script in index.php. Don't forget to change your the new password and fill in your adminname.

$query = "update ".$pixelpost_db_prefix."config set password=MD5('changeme') where admin='changeme'";
if(mysql_query($query)){
echo "Password changed";
}else{
$dberror = mysql_error();
echo "Database error: " .$dberror ."<br />Updating the new password failed. " ;
}

After you run index.php remove the code.

Succes!

[Brookston]

You, my new best friend are an absolute genius. Well done. I can't thank you enough.

J

[Dkozikowski]

EON, just a thought, but you should write a stand alone file that users can upload and run on their servers when this happens. Either have the script set a standard username / password combo that can be switched once logged in or have text fields that would allow the user to enter in the new username and password they want to use.

This seems to happen every once in a while so this could be useful for the complete mysql novice.

anyway, good work on thinking of changing the code in index.php
its a great alternative when you're in a pinch with no DB access.

[eon]

I'm gonna work on it today :D

Here it is!
http://forum.pixelpost.org/showthread.php?p=24463
and here the download
http://www.pixelpost.org/v1/index.php?x=downloads&details=150