Page 1 of 1
From 1.10.3 to 1.11.1 Database Issue [SOLVED]
Posted: Tue Aug 14, 2012 10:59 am
by 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.
Re: From 1.10.3 to 1.11.1 Database Issue
Posted: Tue Aug 14, 2012 11:08 am
by 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?
Re: From 1.10.3 to 1.11.1 Database Issue
Posted: Tue Aug 14, 2012 11:13 am
by 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?
Re: From 1.10.3 to 1.11.1 Database Issue
Posted: Tue Aug 14, 2012 11:15 am
by Jos
I don't think that will work...
Did you run install/upgrade.php?
Re: From 1.10.3 to 1.11.1 Database Issue
Posted: Tue Aug 14, 2012 11:17 am
by jackstringer
I just went to the folder /install and followed the instructions.
Re: From 1.10.3 to 1.11.1 Database Issue
Posted: Tue Aug 14, 2012 11:20 am
by Jos
That's not the proper way to upgrade.
Check:
http://docs.cmsmadesimple.org/upgrading
Re: From 1.10.3 to 1.11.1 Database Issue
Posted: Tue Aug 14, 2012 11:25 am
by 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.
Re: From 1.10.3 to 1.11.1 Database Issue
Posted: Tue Aug 14, 2012 11:27 am
by Jos
jackstringer wrote: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