mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: mahara
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: In Progress

** Affects: mahara/17.10
     Importance: High
         Status: In Progress

** Affects: mahara/18.04
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: In Progress

** Changed in: mahara
       Status: New => In Progress

** Changed in: mahara
   Importance: Undecided => High

** Changed in: mahara
     Assignee: (unassigned) => Robert Lyon (robertl-9)

** Also affects: mahara/17.10
   Importance: Undecided
       Status: New

** Also affects: mahara/18.04
   Importance: High
     Assignee: Robert Lyon (robertl-9)
       Status: In Progress

** Changed in: mahara/17.10
   Importance: Undecided => High

** Changed in: mahara/17.10
    Milestone: None => 17.10.1

** Changed in: mahara/18.04
    Milestone: None => 18.04.0

** Changed in: mahara/17.10
       Status: New => In Progress

-- 
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:
  In Progress
Status in Mahara 17.10 series:
  In Progress
Status in Mahara 18.04 series:
  In Progress

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