Upgrade from 1.7.1 to 2.10.1
How Do I?
I have read through requests both here and on the old forum archive and am at a loss.
After attempting steps on https://docs.expressionengine.com/v2/installation/upgrade_from_1.x.html, and trying things like bumping memory on https://expressionengine.com/forums/archive/topic/186911/after-updating-1.6.6-to-2.1.3-site-error-unable-to-load-site-preferences-no-preferences-found/P15, the upgrade still bombs out with:
‘An Error Was Encountered Site Error: Unable to Load Site Preferences; Invalid Preference Data’
I am seeing truncated fields in the 2.x db:
mysql> select site_system_preferences, site_mailinglist_preferences, site_member_preferences, site_template_preferences, site_channel_preferences from exp_sites;
+--------------------------------------------------------------------------------------------------------------------------------------+------------------------------+-------------------------+--------------------------------------------------------------+--------------------------+
| site_system_preferences | site_mailinglist_preferences | site_member_preferences | site_template_preferences | site_channel_preferences |
+--------------------------------------------------------------------------------------------------------------------------------------+------------------------------+-------------------------+--------------------------------------------------------------+--------------------------+
| YTozOntzOjE1OiJpbmNsdWRlX3NlY29uZHMiO3M6MToibiI7czoxMToiZGF0ZV9mb3JtYXQiO3M6ODoiJWotJW4tJXkiO3M6MTE6InRpbWVfZm9ybWF0IjtzOjI6IjI0Ijt9 | czowOiIiOw== | czowOiIiOw== | YToxOntzOjIyOiJlbmFibGVfdGVtcGxhdGVfcm91dGVzIjtzOjE6InkiO30= | czowOiIiOw== |
+--------------------------------------------------------------------------------------------------------------------------------------+------------------------------+-------------------------+--------------------------------------------------------------+--------------------------+
1 row in set (0.00 sec)Not sure why the old serialized ones are not getting base64 encoded properly, they look good on the 1.x db. I even went so far as to base64 encode the 1.x versions and mysql update (huge paste lol). That resulted in updates/ud_2_09_03.php complaining about $prefs = unserialize(base64_decode($site[‘site_system_preferences’])); even though the fields were correct (at least I could decode to the usual a:10…..).
The update always seems to fail after exactly 180s and at the 2.9.3 step. Going back to admin.php shows: “We have detected that you are currently running ExpressionEngine version 2.9.2
If you are ready to update ExpressionEngine to version 2.10.1 click the link below”
Environment:
web: ubuntu14.04/apache 2.4.10/php5.5.9
db: ubuntu18.04/mysql Ver 14.14 Distrib 5.5.56 (which again is working on the current 1.7.1 install)admin.php and index.php updated with correct system_path (since my predecessor opted to not use ‘system’), all db/url configs correct (since I made a copy of everything and hosted at a different URL).
Please help.