Upgrade from 1.10.3 to 1.11, 1.11.7 or 1.11.13 cms_routes

[montedavis]

Hello,

I'm trying to upgrade a CMSMS version 1.10.3 to present version but I can't get past upgrading to 1.11, I've also tried 1.11.7 and 1.11.13. Each time I receive the error below. When I check the db tables for the 1.10.3 version I have installed there is no cms_routes table. I can't get past this issue. I have been using the domain/install/upgrade.php script while trying to upgrade. Any thoughts on what I can do?

Building static route database... 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 'brueggem_cms.cms_routes' doesn't exist

Thank you,

Monte

SYSTEM INFO BELOW

MS Install Information
CMS Version 1.10.3

Installed Modules
CMSMailer 2.0.2
CMSPrinting 1.0
FileManager 1.2.0
MenuManager 1.7.7
Gallery 1.5.3
ModuleManager 1.5.3
News 2.12.3
Search 1.7
ThemeManager 1.1.4
CGExtensions 1.28.2
CGCalendar 1.9.6
TinyMCE 2.9.6

CMS Config Settings
php_memory_limit
process_whole_template false
output_compression false
max_upload_size 256000000
default_upload_permission 664
url_rewriting mod_rewrite
page_extension
query_var page
image_manipulation_prog GD
auto_alias_content true
locale
default_encoding utf-8
admin_encoding utf-8
set_names true
debug false
root_url http://brueggemanfellows.org
ssl_url https://brueggemanfellows.org
root_path Success /home/customer/www/brueggemanfellows.org/public_html (0755)
previews_path Success /home/customer/www/brueggemanfellows.org/public_html/tmp/cache (0755)
uploads_path Success /home/customer/www/brueggemanfellows.org/public_html/uploads (0755)
uploads_url http://brueggemanfellows.org/uploads
image_uploads_path Success /home/customer/www/brueggemanfellows.org/public_html/uploads/images (0755)
image_uploads_url http://brueggemanfellows.org/uploads/images
ssl_uploads_url https://brueggemanfellows.org/uploads
use_smarty_php_tags false

PHP Information
Current PHP Version (phpversion) Success 5.6.40
md5 function (md5_function) Success On (True)
GD version (gd_version) Success 2
tempnam function (tempnam_function) Success On (True)
Magic quotes in runtime (magic_quotes_runtime) Success Off (False)
Is E_STRICT disabled in error_reporting (E_STRICT) Success
Is E_DEPRECATED disabled in error_reporting (E_DEPRECATED) Caution E_DEPRECATED is enabled
PHP Effective Memory Limit (memory_limit) Success 768M
Maximum Execution Time (max_execution_time) Success 120
PHP output_buffering (output_buffering) Caution 0 ?
PHP Safe Mode (safe_mode) Success Off (False)
File uploads (file_uploads) Success On (True)
Maximum Post Size (post_max_size) Success 256M
Maximum Upload Size (upload_max_filesize) Success 256M
Session Save Path (session_save_path) Success /tmp (1777)
Sessions are allowed to use Cookies (session_use_cookies) Success On (True)
Basic XML (expat) support (xml_function) Success On (True)
Checking if the httpd process can create a file inside of a directory it created (create_dir_and_file) Success
PHP register_globals (register_globals) Success Off (False)
disable_functions in PHP (disable_functions) Success
PHP Open Basedir (open_basedir) Success
Test for remote URL (test_remote_url) Success
fsockopen: Connection ok! Success
fopen: Connection ok! Success
Test ini_set (check_ini_set) Success On (True)

Server Information
Server API (server_api) cgi-fcgi
Server Database (server_db_type) mysql (mysql)
Server Database Version (server_db_version) Success 5.7.32
Server Software (server_software) apache
Server Operating System (server_os) linux 3.12.18-clouder0 on x86_64

Permission Information
tmp Success /home/customer/www/brueggemanfellows.org/public_html/tmp (0755)
templates_c Success /home/customer/www/brueggemanfellows.org/public_html/tmp/templates_c (0755)
modules Success /home/customer/www/brueggemanfellows.org/public_html/modules (0755)
File Creation Mask (umask) Success /home/customer/www/brueggemanfellows.org/public_html/tmp/cache (0755)
config_file Failure 0644
config.php writable. It is more safe if you change permission to read-only

[DIGI3]

I think the easiest thing to try would be to just create that table manually. Diagnosing *why* it's not there is another issue, it could be an older upgrade that should have created it and didn't, or an interim step was skipped etc. Without installing older versions and checking I don't have any recollection of if/when that table was first used.

Failing that, if the site isn't too complex you can consider doing a clean install and importing/copying what you need. There are some modules and tricks for this, or just disable the wysiwyg and copy/paste content and templates.

[montedavis]

DIGI3 Thanks for the ideas. I will give them a try.

[montedavis]

To solve this issue I exported the cms_routes table from an existing 1.11.x site and imported the cms_routes table into my 1.10.3 version. I then proceeded to upgrade to 1.11.13 without an issue.