Page 1 of 1

Upgrade to 1.1 Problem

Posted: Thu Jan 18, 2007 3:49 am
by 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.

Re: Upgrade to 1.1 Problem

Posted: Thu Jan 18, 2007 9:59 am
by 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

Posted: Thu Jan 18, 2007 1:38 pm
by 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 :D

Thanks!