Unformatted table name breaks skin editing
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
When you are in an institution with configurable theme (custom) set and the site database is using $cfg->dbprefix
You get the following error
Failed to get a recordset: postgres8 error: [-18: ERROR: relation "style_property" does not exist
LINE 1: SELECT sp.value FROM style_property sp JOIN institution i ON...
WHERE i.name IN ('instone')
ORDER BY i.name
LIMIT 1")Command was: SELECT sp.value FROM style_property sp JOIN institution i ON i.style = sp.style AND sp.field = ?
WHERE i.name IN ('instone')
ORDER BY i.name
LIMIT 1 and values was (0:headings)
to test:
1) Have clean database
2) in config.php set $cfg->dbprefix = 'cats';
3) install site
4) add an institution and set it's theme to 'Configurable theme' and make sure 'Page skins' is set to Yes
5) add a user to this institution
6) login as user and add a skin
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Changed in mahara: | |
milestone: | 20.04.0 → none |
Patch for "master" branch: https:/ /reviews. mahara. org/10557