mahara-contributors team mailing list archive

[Kristina Hoeppner <1171494@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1171641 ***
    https://bugs.launchpad.net/bugs/1171641

Hi Richard,

This seems to be a duplicate of bug 1171641 which has been fixed.

Cheers
Kristina


** This bug has been marked a duplicate of bug 1171641
   "artefact_license" error when trying to install with $cfg->dbprefix

-- 
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/1171494

Title:
  Unable to upgrade to Mahara 1.7

Status in Mahara ePortfolio:
  New

Bug description:
  Hi,

  When I attempt to upgrade from Mahara 1.6.2 or even pre-upgrade to
  1.6.4 to upgrade to Mahara 1.7 I get the following message:

  Failed to get a recordset: mysql error: [1146: Table 'maharatest.artefact_license' doesn't exist] in adodb_throw( SELECT * FROM artefact_license LIMIT 1 , ) Command was: SELECT * FROM artefact_license LIMIT 1 
  Call stack (most recent first): 
  	• get_recordset_sql(" SELECT * FROM artefact_license LI...", null, 0, 0) at /home/moodleapp/lib/dml.php:333
  	• get_record_sql(" SELECT * FROM artefact_license LI...") at /home/moodleapp/lib/license.php:333
  	• install_licenses_default() at /home/moodleapp/lib/db/upgrade.php:3192
  	• xmldb_core_upgrade("2012080608") at /home/moodleapp/lib/upgrade.php:301
  	• upgrade_core(object(stdClass)) at /home/moodleapp/admin/upgrade.json.php:94

  
  Mahara version(s):  1.6.2  or 1.6.4
  Operating System:  Debian Squeeze 6.0.4 - 32bit
  Database:  MySQL 5.5.20 for Windows 64bit
  Browser:  Firefox 20.0.1

  I noticed that the SELECT statement was wrong and didn't use the
  tablename prefix 'mah' which was set during the initial install of
  Mahara.  Therefore, the tablename artefact_license is wrong and should
  actually be mahartefact_license

  It seems that the db upgrade script doesn't take into consideration
  the tablename prefix?

  Once I changed the tablename in /lib/license.php on line 333 to get
  the statement 'SELECT * FROM mahartefact_license LIMIT 1', the upgrade
  process was able to complete.

  Regards,
  Richard

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