Page 1 of 1
postgresql column missing
Posted: Sun Apr 03, 2005 8:02 am
by 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.
Re: postgresql column missing
Posted: Sun Apr 03, 2005 7:40 pm
by 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