Update misery

[pgielen]

Judging by the posts in this forum, I am not the only one who bumped into trouble by updating Serendipity to the newest version. I have been using it for q couple of years now, but since there is no update system in Serendipity, it took me a while to discover that it has now evolved to version 1.5.2.
I intalled Serendipity when it was only version 0.96 or something like that and now tried to update, only to discover that I could not log into the administrator account anymore afterwards. So how do I recover my articles and files in order to migrate them to the new Serendipity and if that doesn't work, to Wordpress? Of course I do have ftp access to my server and I can access the database through phpmyadmin.

Pierre

[garvinhicking]

Hi!

Can you describe you exactly you performed the upgrade?

When you use phpmyadmin, check your "serendiipty_authors" database table. Check if it has a "hashtype" column. if it doesn't, it means you might not have upgraded the version according to the upgrade documentation on the s9y.org FAQ and the database upgrades where not performed.

In that case you can edit serendipity_config_local.inc.php and insert the old version number to see the DB upgrader again and execute the updates.

Regards,
Garvin

[pgielen]

Hi Gavin,

Indeed, there is no hashtype entry in the serendipity_authors database. Can't I just add that manually?

Pierre

[garvinhicking]

Hi!

You could, but chances are you are missing other updates as well. Safest thing is to properly execute the upgrade.

You can also manually apply SQL updates by going through the files in sql/db_update_*.sql

Regards,
Garvin

[pgielen]

Can you describe you exactly you performed the upgrade?

I just ftp'd the updated files to my server, then started the browser and got the message that Serendipity noticed I wanted to update to 1.5.2, which it did after a mouseclick.

I have edited the config.local.inc file and I got that message again. But now, I got a load of error messages (see the attachment) after which I still can't login and there is still no hashtype field in the authors database... Is there another way to completely erase and reinstall Serendipity and set a new administrator password, without losing the messages and media databases?

Pierre

Serendipity Installatie.doc

Error messages when updating

(39.5 KiB) Downloaded 431 times

[garvinhicking]

Hi!

The error messages indicate that a lot of files do not match the checksums. You might have accidentaly uploaded them inproperly, or the files could even be missing.

Especially important are the mentioned sql/db_update*.sql files! If they are not there, the upgrades that are required are not performed. Please thoroughly check this, and upload the missing files from the serendipity release, then the upgrader should execute itself properly!

The red error messages are okay, because they indicate that some of the previous upgrades were already executed. The cannot be done again, so the error is expected and you shouldn't mind.

This all looks very much like simply files were missing in your upload, and are the cause of your issues.

Regards,
Garvin