Unable to upgrade to Mahara 1.7

[Richard]

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

[Kristina Hoeppner (kris-hoeppner)]

Hi Richard,

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

Cheers
Kristina