mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

There seems to be a couple of issues that users are having when
upgrading to 15.04

https://mahara.org/interaction/forum/topic.php?id=7318&offset=0&limit=10

1) Failed to get a recordset: mysqli error: [1054: Unknown column 'path' in 'where clause'] in adodb_throw( SELECT DISTINCT id FROM "artefact" WHERE path LIKE '%/832/%' OR path LIKE '%/834/%' ORDER BY id, ) Command was: SELECT DISTINCT id FROM "artefact" WHERE path LIKE '%/832/%' OR path LIKE '%/834/%' ORDER BY id
Call stack (most recent first):

    get_column_sql(" SELECT DISTINCT id FROM {...") at /var/www/html/mahara/artefact/lib.php:1789
    artefact_get_descendants(array(size 2)) at /var/www/html/mahara/artefact/lib.php:1295
    ArtefactType::update_locked("17") at /var/www/html/mahara/lib/db/upgrade.php:3118

This is due to the upgrade wanting to lock some submission artefacts but
the code expects 'path' to exist but the upgrade hasn't reached the
place where that column is added to the database.

2) adodb_throw(SHOW INDEXES FROM group, )
Here the command uses a keyword group without quoting it to be a table name

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

** Summary changed:

- Problems with mysql upgrade to 15.04
+ Problem with mysql upgrade to 15.04 - 'path' column missing

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

Title:
  Problem with mysql upgrade to 15.04 - 'path' column missing

Status in Mahara:
  In Progress

Bug description:
  There seems to be a couple of issues that users are having when
  upgrading to 15.04

  https://mahara.org/interaction/forum/topic.php?id=7318&offset=0&limit=10

  1) Failed to get a recordset: mysqli error: [1054: Unknown column 'path' in 'where clause'] in adodb_throw( SELECT DISTINCT id FROM "artefact" WHERE path LIKE '%/832/%' OR path LIKE '%/834/%' ORDER BY id, ) Command was: SELECT DISTINCT id FROM "artefact" WHERE path LIKE '%/832/%' OR path LIKE '%/834/%' ORDER BY id
  Call stack (most recent first):

      get_column_sql(" SELECT DISTINCT id FROM {...") at /var/www/html/mahara/artefact/lib.php:1789
      artefact_get_descendants(array(size 2)) at /var/www/html/mahara/artefact/lib.php:1295
      ArtefactType::update_locked("17") at /var/www/html/mahara/lib/db/upgrade.php:3118

  This is due to the upgrade wanting to lock some submission artefacts
  but the code expects 'path' to exist but the upgrade hasn't reached
  the place where that column is added to the database.

  2) adodb_throw(SHOW INDEXES FROM group, )
  Here the command uses a keyword group without quoting it to be a table name

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