I can't log in after installing latest version

[tlabel]

I have installed the latest version , but after trying to install it 3 times I still can not login , it won't recognize user name whatever I do, any ideas?

[garvinhicking]

Hi!

In installation, did you change the default username and password, or did you leave it at default?

Did you use in your username or password any special characters beside 0-9 and a-z?

You have two options, one is to reset your password using phpMyAdmin, the other is reinstalling and trying a different username? Reinstallation can be forced by deleting the serendipity_config_local.inc.php files and using phpMyAdmin to drop your database tables...

HTH,
Garvin

[tlabel]

Hi G, appreciate your reply. I have tried reinstalling 3 times changing the admin and always got the same result.

no special characters used just numbers, I do not undestand.

this never happend before with previous versions.

[garvinhicking]

Hi!

Did you, after each installation, delete the serendipity_authors table? If you didn't delete that, the installer will not create it from scratch!

So maybe if you can use phpMyAdmin to delete that file and reinstall, it might work?

Do you know how to do that with phpMyAdmin?

Regards,
Garvin

[tlabel]

Hi G, never had to do tha before, would appreciate some guidance

[garvinhicking]

Hi!

Do you have phpMyAdmin access?

Regards,
Garvin

[tlabel]

I do G, how do I proceed from there.

[garvinhicking]

Hi!

Okay. Then using your phpMyAdmin, we will purge all your existing tables so that you will be able to re-install the s9y script with completely fresh user data.

Fire up your phpMyAdmin, go to your serendipity database.

Click on the first serendipity table (all should be prefixed with something like "serendipity_"). You might want to check out serendipity_authors as the first table. After you click on it you go to the right frame and click on "browse". There you should see all created users, it should be one per installation.

Now, the easy route would be to edit one row (click on the EDIT pencil icon) of the user you want to login. See the fields that read 'username' and 'password', those are the important ones. Make sure you have a username there that you use to login that contains no spaces or special characters. In the password column, you can enter a new password. Then MAKE SURE you select the entry "MD5" in the dropdown to the left of the input field. When you select that, you tell phpMyAdmin to save your password encrypted into the database, which is how Serendipity expects it.

Save the edited row, and then try to login. If it all works out for you, hooray, you circumvented a fresh installation.

If anything failed, you can go to phpMYAdmin again, click on every single serendipity table one after the other, and for each clicked table click the button "DROP" in the right hand section of your screen. You will be asked if you are sure you want to drop that table, which you can agree to.

After every table is wiped, you delete the 'Serendipity_config_local.inc.php' file via FTP and then open your blog URL to attempt the re-install.

If now in the end something is still wrong, there's something else fishy going on, and for me to be able to help you further I can only offer you to have a look at your installation if you can provide me a temporary FTP account. But first things first, so let's see how the other two options work out for you.

Best regards,
Garvin

[tlabel]

Thanks Garv, I had to delete all the tables and it now works!

I have one clue, I selected english language this time whereas all the other times it was italian, there could be a problem with that. I appreciate!