Hello Robert, i just did a fresh restore of our 15.10.2 instance and tried to upgrade to 17.10.0
This is the whole log i get (referer changed): [DBG] 39 (lib/db/upgrade.php:4213) Upgrade comment plugin for threaded comments, referer: https://xyz.com [DBG] 39 (artefact/comment/db/upgrade.php:140) Adding "hidden" column to artefact_comment_comment, referer: https://xyz.com [DBG] 39 (artefact/comment/db/upgrade.php:150) Checking for existing deleted comments that should now be hidden, referer: https://xyz.com [DBG] 39 (lib/db/upgrade.php:4220) Expanding the size of the activity_queue.data column, referer: https://xyz.com [DBG] 39 (lib/db/upgrade.php:4229) Upgrade wall block and add wall notifications to default inbox block, referer: https://xyz.com [WAR] 39 (lib/errors.php:859) Failed to get a recordset: mysqli error: [1054: Unknown column 'i.logoxs' in 'field list'] in EXECUTE(", referer: https://xyz.com [WAR] 39 (lib/errors.php:859) SELECT u.institution,IF(ctime >= '1970-01-01', UNIX_TIMESTAMP(ctime), TIMESTAMPDIFF(SECOND, '1970-01-01', ctime)) AS ctime,IF(u.expiry >= '1970-01-01', UNIX_TIMESTAMP(u.expiry), TIMESTAMPDIFF(SECOND, '1970-01-01', u.expiry)) AS membership_expiry,u.studentid,u.staff,u.admin,i.displayname,i.theme,i.registerallowed, i.showonlineusers,i.allowinstitutionpublicviews, i.logo, i.logoxs, i.style, i.licensemandatory, i.licensedefault, i.dropdownmenu, i.skins, i.suspended, referer: https://xyz.com [WAR] 39 (lib/errors.php:859) FROM "usr_institution" u INNER JOIN "institution" i ON u.institution = i.name, referer: https://xyz.com [WAR] 39 (lib/errors.php:859) WHERE u.usr = 60 ORDER BY i.priority DESC")Command was: , referer: https://xyz.com [WAR] 39 (lib/errors.php:859) SELECT u.institution,IF(ctime >= '1970-01-01', UNIX_TIMESTAMP(ctime), TIMESTAMPDIFF(SECOND, '1970-01-01', ctime)) AS ctime,IF(u.expiry >= '1970-01-01', UNIX_TIMESTAMP(u.expiry), TIMESTAMPDIFF(SECOND, '1970-01-01', u.expiry)) AS membership_expiry,u.studentid,u.staff,u.admin,i.displayname,i.theme,i.registerallowed, i.showonlineusers,i.allowinstitutionpublicviews, i.logo, i.logoxs, i.style, i.licensemandatory, i.licensedefault, i.dropdownmenu, i.skins, i.suspended, referer: https://xyz.com [WAR] 39 (lib/errors.php:859) FROM "usr_institution" u INNER JOIN "institution" i ON u.institution = i.name, referer: https://xyz.com [WAR] 39 (lib/errors.php:859) WHERE u.usr = ? ORDER BY i.priority DESC and values was (0:60), referer: https://xyz.com Call stack (most recent first):, referer: https://xyz.com * log_message("Failed to get a recordset: mysqli error: [1054: Un...", 8, true, true) at /var/www/html/maharatest/lib/errors.php:95, referer: https://xyz.com * log_warn("Failed to get a recordset: mysqli error: [1054: Un...") at /var/www/html/maharatest/lib/errors.php:859, referer: https://xyz.com * SQLException->__construct("Failed to get a recordset: mysqli error: [1054: Un...") at /var/www/html/maharatest/lib/dml.php:517, referer: https://xyz.com * get_recordset_sql(", referer: https://xyz.com SELECT u.institution,IF(ctime >= '1970-01...", array(size 1), "", "") at /var/www/html/maharatest/lib/dml.php:697, referer: https://xyz.com * get_records_sql_assoc(", referer: https://xyz.com SELECT u.institution,IF(ctime >= '1970-01...", array(size 1)) at /var/www/html/maharatest/lib/user.php:1811, referer: https://xyz.com * load_user_institutions("60") at /var/www/html/maharatest/auth/user.php:916, referer: https://xyz.com * User->reset_institutions() at /var/www/html/maharatest/auth/user.php:119, referer: https://xyz.com * User->find_by_id("60") at /var/www/html/maharatest/lib/embeddedimage.php:46, referer: https://xyz.com * EmbeddedImage::prepare_embedded_images("Testmeeting f\xc3\xbcr Sonntag um 20:00...", "wallpost", "51", null, "60") at /var/www/html/maharatest/blocktype/wall/db/upgrade.php:25, referer: https://xyz.com * xmldb_blocktype_wall_upgrade("2009111201") at /var/www/html/maharatest/lib/upgrade.php:423, referer: https://xyz.com * upgrade_plugin(object(stdClass)) at /var/www/html/maharatest/lib/db/upgrade.php:4231, referer: https://xyz.com * xmldb_core_upgrade("2015092917") at /var/www/html/maharatest/lib/upgrade.php:347, referer: https://xyz.com * upgrade_core(object(stdClass)) at /var/www/html/maharatest/admin/upgrade.json.php:87, referer: https://xyz.com , referer: https://xyz.com It works when i go from 15.10.2 -> 16.10.5 -> 17.10.0, but it fails when i go directly 15.10.2 -> 17.10.0 -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1717371 Title: Upgrade from 15.04 -> 17.10 fails on logoxs not found Status in Mahara: Fix Released Bug description: When upgrading from 15.04 -> 17.10 the upgrade process fails at step if ($oldversion < 2015082500) { // Add a site default portfolio page template log_debug('Add a site default portfolio page template'); ... } This is because there is a call to load_user_institutions() which expects the 'logoxs' column but that does not exist yet (it is added later in the upgrade). As upgrade is run by user id = 0 we can ignore the institution check for them (they won't have any institutions anyway). To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1717371/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
