Unformatted table name breaks matrix
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
High
|
Unassigned | ||
19.10 |
Fix Released
|
High
|
Unassigned | ||
20.04 |
Fix Released
|
High
|
Unassigned |
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_
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
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Changed in mahara: | |
milestone: | 20.04.0 → none |
Reviewed: https:/ /reviews. mahara. org/10557 /git.mahara. org/mahara/ mahara/ commit/ 6459c465101d624 2f47a5e65c53fb7 e3f18ddd19
Committed: https:/
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: master
commit 6459c465101d624 2f47a5e65c53fb7 e3f18ddd19
Author: Robert Lyon <email address hidden>
Date: Mon Nov 4 12:44:20 2019 +1300
Bug 1851176: Adding a skin when on custom theme and using dbprefix
Get table not found error
Also fix for Bug 1851175 - as both fixes were to escape table name
correctly
Note: also fixed another table call that was not escaped correctly
behatnotneeded
Change-Id: I1acdafe9c29aa6 10a8d947b6fbbf9 5883b26f8c6
Signed-off-by: Robert Lyon <email address hidden>