Serendipity Upgrade to v 1.5.x Gotcha

Just a quick note: I just updated Serendipity to version 1.5.1 on one of our servers; yet afterwards I could not log in anymore. Also, Serendipity reported that version 1.5.1 was present, although I did not run the update script from the admin console yet. At first I thought I did something wrong, but a s9y forum posting described a similar issue.

The fix was actually quite simple: for some reason—may it be due to my own fault or due to a bug in the upgrade logic—the SQL upgrade script was not run, but Serendipity still thought it had been upgraded already. The file sql/db_update_1.5-alpha1_1.5-alpha2_mysql.sql contains the required SQL commands (in case you are using MySQL). Just remember to replace {PREFIX} with the table prefix you are using (s9y_ in my case):


ALTER TABLE s9y_authors ADD COLUMN hashtype int(1);
ALTER TABLE s9y_authors CHANGE password password VARCHAR(64) NOT NULL;


HTH. Once again, Happy Holidays.