Mahara

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

Bug #1171641 reported by Aaron Wells
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
High
Aaron Wells
Mahara 1.8.0
1.7
Fix Released
High
Aaron Wells
Mahara 1.7.1

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.

Tags: licenses
Revision history for this message
Aaron Wells (u-aaronw) wrote :

1.8dev: https://reviews.mahara.org/2080

1.7: https://reviews.mahara.org/2081

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/2081
Committed: http://gitorious.org/mahara/mahara/commit/7068bf0e913cea9ab53ca0ea4c51b712382a97b3
Submitter: Son Nguyen (<email address hidden>)
Branch: 1.7_STABLE

commit 7068bf0e913cea9ab53ca0ea4c51b712382a97b3
Author: Aaron Wells <email address hidden>
Date: Tue Apr 23 10:24:03 2013 +1200

Fixing license support for $cfg->dbprefix

Bug #1171641

Change-Id: I79460eae318a223edc688f244f08e74d95015fda
Signed-off-by: Aaron Wells <email address hidden>

Revision history for this message
Mahara Bot (dev-mahara) wrote :

Reviewed: https://reviews.mahara.org/2080
Committed: http://gitorious.org/mahara/mahara/commit/7639518c42db22c63a64020f3f0fa0dab6767a84
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit 7639518c42db22c63a64020f3f0fa0dab6767a84
Author: Aaron Wells <email address hidden>
Date: Tue Apr 23 10:24:03 2013 +1200

Fixing license support for $cfg->dbprefix

Bug #1171641

Change-Id: I79460eae318a223edc688f244f08e74d95015fda
Signed-off-by: Aaron Wells <email address hidden>

Changed in mahara:
status: New → Fix Committed
Aaron Wells (u-aaronw)
Changed in mahara:
milestone: 1.8rc1 → 1.8.0
Aaron Wells (u-aaronw)
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.