mahara-contributors team mailing list archive

[Aaron Wells <1171641@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

As reported in the Mahara forums:
https://mahara.org/interaction/forum/topic.php?id=5376&offset=0&limit=10#post23189

If you try to install Mahara 1.7 with $cfg->dbprefix turned on, you get
this error: "Failed to get a recordset: mysql error: [1146: Table
'mahara17.artefact_license' doesn't exist] in adodb_throw( SELECT * FROM
artefact_license LIMIT 1 , ) Command was: SELECT * FROM artefact_license
LIMIT 1"

The problem is that there are some SQL queries in the artefact code that
don't properly have the table names surrounded in {curly brackets},
which is what the DB libraries use to locate them and put the DB prefix
in front of them.

** Affects: mahara
     Importance: High
     Assignee: Aaron Wells (u-aaronw)
         Status: New

** Affects: mahara/1.7
     Importance: Undecided
         Status: New


** Tags: licenses

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

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contrib members
https://bugs.launchpad.net/bugs/1171641

Title:
  "artefact_license" error when trying to install with $cfg->dbprefix

Status in Mahara ePortfolio:
  New
Status in Mahara 1.7 series:
  New

Bug description:
  As reported in the Mahara forums:
  https://mahara.org/interaction/forum/topic.php?id=5376&offset=0&limit=10#post23189

  If you try to install Mahara 1.7 with $cfg->dbprefix turned on, you
  get this error: "Failed to get a recordset: mysql error: [1146: Table
  'mahara17.artefact_license' doesn't exist] in adodb_throw( SELECT *
  FROM artefact_license LIMIT 1 , ) Command was: SELECT * FROM
  artefact_license LIMIT 1"

  The problem is that there are some SQL queries in the artefact code
  that don't properly have the table names surrounded in {curly
  brackets}, which is what the DB libraries use to locate them and put
  the DB prefix in front of them.

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