mahara-contributors team mailing list archive

[Richard <richard.flurey@xxxxxxxxx>]

Public bug reported:

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

** Affects: mahara
     Importance: Undecided
         Status: New

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