Query Failed

Having trouble installing serendipity?
Post Reply
kazekage
Posts: 2
Joined: Fri Feb 17, 2006 11:44 am

Query Failed

Post by kazekage »

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... :cry:
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Query Failed

Post by garvinhicking »

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
kazekage
Posts: 2
Joined: Fri Feb 17, 2006 11:44 am

Post by kazekage »

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. :)
Post Reply