Upgrade Problems from 5.0 to 5.3

[BillyS]

I upgraded from 5.0 to 5.3.2 and I wanted to use alias and I have this problem:  I think this is enough of the error:

mossefalias::store failed <br/>Unknown column ‘title’ in ‘field list’ SQL=INSERT INTO mos_sef_alias (‘id’,’non_sef_url

My mos_sef_alias table only has four fields id, non_sef_url, alias, published

I'm thinking there was some SQL that added more fields to this table.  Does that mean I had to upgrade from 5.0 to 5.2 then 5.3?  Is there some SQL you could supply to help me create this new fields.

[Saka]

Yes from 5.0 you had to upgrade to 5.2 first. Info here: http://www.sakic.net/news/sef_advance_5.2_released/
and then to 5.3, info here: http://www.sakic.net/news/custom_page_titles_and_metadata_with_sef_advance/

[BillyS]

Would this work?

ALTER TABLE jos_sef_alias ADD `title` text NOT NULL default '' AFTER `alias`;
ALTER TABLE jos_sef_alias ADD `metakey` text NOT NULL default '' AFTER `title`;
ALTER TABLE jos_sef_alias ADD `metadesc` text NOT NULL default '' AFTER `metakey`;

[Saka]

Yes, that should work for 5.2->5.3 if you don't want to use built-in export/import.