*** 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

_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to     : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help   : https://help.launchpad.net/ListHelp

Reply via email to