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