Upgrade to 1.1 Problem

[TKS]

Hey guys,

I backed everything up...saved the filestructure and overwrote everything with the 1.1 package.

I wasn't greeted by the normal "it appears you are trying to upgrade" link...I just received the blog again...no upload link at all. (and yes I did protect things with .htaccess and .htpasswd)

When I go into the media library, I see

Code: Select all

SELECT  i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
                     a.realname AS authorname
                     FROM serendipity_images AS i
       LEFT OUTER JOIN serendipity_authors AS a
                    ON i.authorid = a.authorid
                       

                       WHERE 1=1 
                     GROUP BY i.id
            ORDER BY i.date DESC  LIMIT 0, 8

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

So, I'm thinking that there was supposed to be an upgrade link that ran an SQL query or something that I missed?

Any direction anyone can send me in would be appreciated.

[garvinhicking]

Hi!

Yes, it seems the upgrader was not executed. Can you try to follow the Steps from the s9y.org FAQ:

http://www.s9y.org/11.html#A20

This should make it possible to re-perform the required upgrade stuff from 1.0 to 1.1!

HTH,
Garvin

[TKS]

Worked great!

it's a testament to the quality of s9y...this is the first time I've had a problem since I began with .7

Thanks!