mahara-contributors team mailing list archive

[Mahara Bot <1728815@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/8292
Committed: https://git.mahara.org/mahara/mahara/commit/db0b49d47cc5ea3b23134823920d008b20154656
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    17.10_STABLE

commit db0b49d47cc5ea3b23134823920d008b20154656
Author: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
Date:   Tue Oct 31 20:40:09 2017 +1300

Bug 1728815: Not include the logoxs column in sql query until it exists

As it causes problems on upgrade

behatnotneeded

Change-Id: Id330f8c31c763dffce6f559557c9c78ac27ac58f
Signed-off-by: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
(cherry picked from commit 35d46f1d00bb031871f51c951b21df7ef5a379d7)

-- 
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/1728815

Title:
  Upgrading from 15.10.2 to 17.10.0 causes unknown column 'i.logoxs'
  error

Status in Mahara:
  Fix Committed
Status in Mahara 17.10 series:
  Fix Committed
Status in Mahara 18.04 series:
  Fix Committed

Bug description:
  Get the following error:
  [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
  ...
  ...
    * 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

  
  This is similar to the Bug 1717371 but in that case it was the root user trying to fetch institution info (so we could ignore that user) but in this case it is an actual user trying to fetch their institution info in the process of updating their wallposts to fix any embedded images.

  So we will need to make a more robust fix for this problem

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1728815/+subscriptions