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

_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help   : https://help.launchpad.net/ListHelp

Reply via email to