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

Bug #1728815 reported by Robert Lyon on 2017-10-31
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
High
Robert Lyon
17.10
High
Unassigned
18.04
High
Robert Lyon

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

Robert Lyon (robertl-9) on 2017-10-31
Changed in mahara:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Robert Lyon (robertl-9)

Reviewed: https://reviews.mahara.org/8248
Committed: https://git.mahara.org/mahara/mahara/commit/35d46f1d00bb031871f51c951b21df7ef5a379d7
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit 35d46f1d00bb031871f51c951b21df7ef5a379d7
Author: Robert Lyon <email address hidden>
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 <email address hidden>

Reviewed: https://reviews.mahara.org/8292
Committed: https://git.mahara.org/mahara/mahara/commit/db0b49d47cc5ea3b23134823920d008b20154656
Submitter: Robert Lyon (<email address hidden>)
Branch: 17.10_STABLE

commit db0b49d47cc5ea3b23134823920d008b20154656
Author: Robert Lyon <email address hidden>
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 <email address hidden>
(cherry picked from commit 35d46f1d00bb031871f51c951b21df7ef5a379d7)

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers