/ Unknown column 'a.realname' in 'field list'

[Blake_Ivey]

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:

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'

I have been checking the config file and all the database settings are right, etc. What can I do to fix this? Thanks!

[Blake_Ivey]

Sorry, should have searched first, just became to impatient. Here is what helped me fix it: http://www.s9y.org/forums/viewtopic.php ... field+list