/ Unknown column 'a.realname' in 'field list'
Posted: Sun Mar 20, 2005 9:14 pm
Well, I decided I would upgrade to the newest beta (I was using alpha still) and I have ran into some trouble. I have tried upgrading multiple times and finally backed up my upload folder, etc and erased the directory to start fresh. Same problem. Basically, after upgrading or installing sucessfully I go to my page at www.blakeivey.com and get:
I have been checking the config file and all the database settings are right, etc. What can I do to fix this? Thanks!
Code: Select all
Query failed:
SELECT
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.author,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.email
, e.body, e.extended
FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
WHERE isdraft = 'false' AND e.timestamp <= '1111349450'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Unknown column 'a.realname' in 'field list'