mahara-contributors team mailing list archive

[mafen <1717371@xxxxxxxxxxxxxxxxxx>]

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