Page 1 of 1

SOLVED - Upgrade Problem 1.10.3 to 1.11.7

Posted: Sat Jul 13, 2013 8:21 pm
by spike
Have just upgarded several sites - no problem
So I tried to upgrade my main site and recieved the following error at stage 5

Adding module_smarty_plugins table...[done]

Enhancing the adminlog table...[done]

Enhancing the css table table... [done]

Creating routes table... [done]

Adding an index to the content table.... [done]

Building static route database... INSERT INTO cms_routes (term,key1,key2,key3,data,created) VALUES ('travel','__CONTENT__','358',NULL,'O:8:\"CmsRoute\":2:{s:15:\"\0CmsRoute\0_data\";a:4:{s:4:\"term\";s:6:\"travel\";s:8:\"absolute\";b:1;s:4:\"key1\";s:11:\"__CONTENT__\";s:4:\"key2\";s:3:\"358\";}s:18:\"\0CmsRoute\0_results\";N;}',NOW()) -- Duplicate entry 'travel-__CONTENT__' for key 1

Help - gruss - spike

Re: Upgrade Problem 1.10.3 to 1.11.7

Posted: Sat Jul 13, 2013 8:37 pm
by calguy1000
I think your 1.10.3 install somehow managed to have multiple pages with the same alias (or at least 2 pages with the alias 'travel').

You will need to check this.

Re: Upgrade Problem 1.10.3 to 1.11.7

Posted: Sat Jul 13, 2013 9:03 pm
by spike
Thanks for the speedy help CG.
Went back to 1.10.3 and searched for the duplicate - couldn't find any - so I changed the one alias and submitted it to the DB then re-upgraded succesfully.
Thanks again.
Still have some quirks in the admin,
but at least the site is back online.
gruss from the old country
regards spike