Serendipity Forums

Hi!
Im not sure if this is the right place to ask.
I successfully installed the blog, but when i tried going to my blog page, I have this:

Query failed:

SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.email
, e.body, e.extended

FROM
blog_entries AS e
LEFT JOIN blog_authors a
ON e.authorid = a.authorid
LEFT JOIN blog_entrycat ec
ON e.id = ec.entryid
LEFT JOIN blog_category c
ON ec.categoryid = c.categoryid

WHERE isdraft = 'false'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15

/ Unknown column 'e.timestamp' in 'field list'

Since this error happened exactly after installation, I guess it still is under the Installation category right? I hope so...
Can anyone please help me on this? Please...

Can it be that you already had a "blog_entries" table when you installed serendipity?

Serendipity is complaining about a missing 'timestamp' column, which should be created for the tabled uring installation. But if s9y detects that such a table 'blog_entries' already exists, it will not modify existing tables.

Did you get any errors during installation, telling you of failed SQL statements?

The best thing would be to delete (or move) all blog_* tables, and then re-install serendipity. After that you should have a table blog_entries which contains a 'timestamp' column.

Which database type are you using? MySQL?

Regards,
Garvin

Yup! Im using MySql..
And I did get some errors about the db during installation and I had to edit and ran the installation a few times.
Im gonna try and delete the table and reinstall now.