postgresql column missing

[ketema]

Downloaded beta 5, went through setup and upon going to intial home page got an error about serendipity_authors not having a column real_name I added the column and page worked fine, but I still can't log into the admin suite. Keeps telling me my username and/or password is wrong.

[garvinhicking]

The column name should be 'realname' and not 'real_name'.

Did you freshly install beta5? Which PGSql version? Does this SQL query work for you:

Code: Select all

create table nauthors (
  realname varchar(255) NOT NULL default '',
  username varchar(20) default null,
  password varchar(32) default null,
  email varchar(128) not null default ''
);

or do you get errors somewhere?

If you added that and can't login, your password is wrong. Reset it by setting the password column to a md5('yournewpassword') value.

Regards,
Garvin