Upgrade Problems from 5.0 to 5.3

17 years 2 months ago #1105 by 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.

Please Log in or Create an account to join the conversation.

17 years 2 months ago #1106 by Saka
Yes from 5.0 you had to upgrade to 5.2 first. Info here: www.sakic.net/news/sef_advance_5.2_released/
and then to 5.3, info here: www.sakic.net/news/custom_page_titles_an...ta_with_sef_advance/

Emir Sakic
www.sakic.net

Please Log in or Create an account to join the conversation.

17 years 2 months ago #1107 by 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`;

Please Log in or Create an account to join the conversation.

17 years 2 months ago #1109 by Saka
Yes, that should work for 5.2->5.3 if you don't want to use built-in export/import.

Emir Sakic
www.sakic.net

Please Log in or Create an account to join the conversation.

About us

We provide high quality Joomla components created by a co-founder and original core developer of Joomla. For over a decade, our products have been used by more than 20.000 webmasters around the world.

Stay in touch