[Solved] Upgrade Error from 1.10.3 to 1.11 (cms_routes)

[msalgo]

Hi there.

I posted a while ago on this subject, but had resolved to the fact that the 1.10.3 to 1.11 upgrade was just not working and I gave up and stayed with the 1.10.3 version. Last week one of our CMSMS sites got hacked and after wiping the site clean and restoring from a backup, I am now resolved to patch up whatever security vulnerability there were and upgrade to the latest version of CMSMS.

Here was my previous post for reference: http://forum.cmsmadesimple.org/viewtopi ... =8&t=64931

After doing the upgrade from 1.10.3 to 1.11, this is the error I receive:
INSERT INTO cms_routes (term,key1,key2,key3,data,created) VALUES ('/[nN]ews\\/(?P[0-9]+)\\/(?P[0-9]+)\\/(?P.*?)\\/d,(?P.*?)$/','News',NULL,NULL,'O:8:\"CmsRoute\":2:{s:15:\"\0CmsRoute\0_data\";a:4:{s:4:\"term\";s:97:\"/[nN]ews\\/(?P[0-9]+)\\/(?P[0-9]+)\\/(?P.*?)\\/d,(?P.*?)$/\";s:8:\"absolute\";b:0;s:4:\"key1\";s:4:\"News\";s:4:\"key2\";N;}s:18:\"\0CmsRoute\0_results\";N;}',NOW()) -- Table '[TABLENAME].cms_routes' doesn't exist

When I did the install I chose not to create tables because that would (and did in a previous attempt) wipe my entire site and replace it with the stock CMSMS site. So I cannot go that route.

Is my only option starting from scratch and recreating the entire site page by page, block by block, template by template?

Thank you,
-Michael

[calguy1000]

I think you're doing it wrong:

http://docs.cmsmadesimple.org/upgrading

[msalgo]

Well I think I did all of the steps correctly.

I had to download the full English packages where available for each version as I migrated upwards from previous releases, running the installer after each file upload set.

What's interesting is I followed the procedures as documented in the bottom of the page "2. Complete the upgrade process described above in numerous steps. I.e: if your current version is version 1.6.7 and you wish to upgrade to 1.10.1, you should at a minimum upgrade to version 1.7, then to version 1.8, 1.9, and finally version 1.10.1"

Right below that, there is a contradicting statement of "The upgrade instructions for CMSMS 1.10.x stipulate that users upgrading from versions prior to 1.9.4 should upgrade to 1.9.4.3 first."

So does this mean I should have upgraded from 1.8 to 1.9 to 1.9.4.3 then to 1.10 then to 1.10.3?

Thanks,
-Michael

[calguy1000]

The upgrade instructions for CMSMS 1.10.x stipulate that users upgrading from versions prior to 1.9.4 should upgrade to 1.9.4.3 first

Means if you're running 1.9.4 or earlier you should upgrade to 1.9.4.3
then I would go straight to 1.10.3 and then go to 1.11.7 testing, and backing up after each step.

Here's a tip: There is no option to 'create tables' in the upgrade routine.

[msalgo]

Ah... here's the difference: I think I was just doing domain/install and not domain/install/upgrade.php.

I will give it a try and see what happens.

[msalgo]

Ok well that seemed to do the trick (using the "upgrade.php" path) - I will flag this as solved now.

Hopefully someone else who makes the same goof can now find this in the search and save themselves some frustration : P

Thank you very much for the guidance - it's been helpful.

Regards,
-Michael

[paulbaker]

Hopefully someone else who makes the same goof can now find this in the search and save themselves some frustration : P

I've been there, done that:
http://forum.cmsmadesimple.org/viewtopi ... =3&t=64473

I think there should be some code that says "you selected install but you appear to have CMSMS installed already....are you sure?" for careless people like us.

[Rolf]

I think there should be some code that says "you selected install but you appear to have CMSMS installed already....are you sure?"

+1

[Rolf]

@paulbaker We are working on it for 2.0 release

[paulbaker]

Cool Thanks Rolf.

[msalgo]

Yup, much appreciated. I think I was just used to that method for how to upgrade phpbb via the automatic update package.

Thanks again,
-Michael