From 1.10.3 to 1.11.1 Database Issue [SOLVED]

[jackstringer]

Just tried to upgrade from 1.10.3 straight to 1.11.1 and after going through /install stages I then tried to login. The site fails as its trying to insert data into a table that doesn't exist.

Code: Select all

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 'mwmcc_cms.cms_routes' doesn't exist

I didn't get any upgrading database schema things so not sure if that failed hence the error.

I am uploading 1.11 and going to try that.

[Jos]

It will not make a difference if you upgrade to 1.11 or directly to 1.11.1
I just did an upgrade directly to 1.11.1, and all went as smooth as could be.

The routes table should be created during the upgrade process (scheme 35 to 36)
Maybe your MYSQL-user doesn't have the permission to create/alter tables?

[jackstringer]

I never saw it say 'Upgraded Schema from x to y' So maybe that is an issue. Should I try to call the upgrade.35.to.36.php directly?

[Jos]

I don't think that will work...

Did you run install/upgrade.php?

[jackstringer]

I just went to the folder /install and followed the instructions.

[Jos]

That's not the proper way to upgrade.
Check: http://docs.cmsmadesimple.org/upgrading

[jackstringer]

Ah, that could be the cause. Like most users I just backup, upload, and follow the screen. Don't read manuals. I just did want I normally do on a upgrade and it worked in the past...including upgrading the database schema.

Maybe the index.php of install should check to see if there is already an install of CMS-MS there and then offer to upgrade or re-install.

[Jos]

Maybe the index.php of install should check to see if there is already an install of CMS-MS there and then offer to upgrade or re-install.

CMSms does offer you to upgrade if you just login to the admin panel