mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

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...
                            ^] in EXECUTE("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")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

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

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

** Affects: mahara/20.04
     Importance: High
         Status: 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/1851176

Title:
  Unformatted table name breaks skin editing

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

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...
                              ^] in EXECUTE("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")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

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