Upgrade Problems from 5.0 to 5.3
- BillyS
-
Topic Author
- Offline
- New Member
-
Less
More
- Posts: 6
- Thank you received: 1
17 years 9 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.
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.
- Saka
-
- Offline
- Administrator
-
17 years 9 months ago #1106
by Saka
Emir Sakic
www.sakic.net
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/
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.
- BillyS
-
Topic Author
- Offline
- New Member
-
Less
More
- Posts: 6
- Thank you received: 1
17 years 9 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.
- Saka
-
- Offline
- Administrator
-
17 years 9 months ago #1109
by Saka
Emir Sakic
www.sakic.net
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.