mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

Unable to get matrix form and instead get:

Failed to get a recordset: postgres8 error: [-18: ERROR: relation
"block_instance" does not exist LINE 2: INNER JOIN block_instance bi ON
bi.id = bid.bloc... ^] in EXECUTE("SELECT MAX("positiony") FROM
"mh_block_instance_dimension" bid INNER JOIN block_instance bi ON bi.id
= bid.block WHERE bi.view = ?")Command was: SELECT MAX("positiony") FROM
"mh_block_instance_dimension" bid INNER JOIN block_instance bi ON bi.id
= bid.block WHERE bi.view = ? and values was (0:8)


To test:

1) have a new/clean database
2) update config.php and set $cfg->dbprefix = 'cats_';
3) install site
4) enable smart evidence in Admin -> Institutions configuration
5) create a collection of at least 1 page and set it to use a smart evidence matrix
6) view the matrix page and click on a point

It should pop up a modal but it doesn't

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

** Affects: mahara/19.10
     Importance: High
         Status: Confirmed

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

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

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

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

** Changed in: mahara/19.10
       Status: New => Confirmed

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

** Changed in: mahara/19.10
   Importance: Undecided => Critical

** Changed in: mahara/19.10
   Importance: Critical => High

** Changed in: mahara/20.04
    Milestone: None => 19.10.1

** Changed in: mahara/19.10
    Milestone: None => 19.10.1

** Changed in: mahara/20.04
    Milestone: 19.10.1 => 20.04.0

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

Title:
  Unformatted table name breaks matrix

Status in Mahara:
  In Progress
Status in Mahara 19.10 series:
  Confirmed
Status in Mahara 20.04 series:
  In Progress

Bug description:
  Unable to get matrix form and instead get:

  Failed to get a recordset: postgres8 error: [-18: ERROR: relation
  "block_instance" does not exist LINE 2: INNER JOIN block_instance bi
  ON bi.id = bid.bloc... ^] in EXECUTE("SELECT MAX("positiony") FROM
  "mh_block_instance_dimension" bid INNER JOIN block_instance bi ON
  bi.id = bid.block WHERE bi.view = ?")Command was: SELECT
  MAX("positiony") FROM "mh_block_instance_dimension" bid INNER JOIN
  block_instance bi ON bi.id = bid.block WHERE bi.view = ? and values
  was (0:8)

  
  To test:

  1) have a new/clean database
  2) update config.php and set $cfg->dbprefix = 'cats_';
  3) install site
  4) enable smart evidence in Admin -> Institutions configuration
  5) create a collection of at least 1 page and set it to use a smart evidence matrix
  6) view the matrix page and click on a point

  It should pop up a modal but it doesn't

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