mahara-contributors team mailing list archive

[Mahara Bot <1326205@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/3405
Committed: http://gitorious.org/mahara/mahara/commit/5573da00efb053766119de274b8ee80abbabd127
Submitter: Son Nguyen (son.nguyen@xxxxxxxxxxxxxxx)
Branch:    master

commit 5573da00efb053766119de274b8ee80abbabd127
Author: Ghada El-Zoghbi <ghada@xxxxxxxxxxxxxxx>
Date:   Wed Jun 4 15:52:07 2014 +1000

Bug 1326205: Error installing triggers for new mahara site in MySQL with
dbprefix

MySql has a maximum of 64 characters for identifiers.
Shorten the names of the triggers to allow space for dbprefix and the '_trigger' suffix.
Apply the name change to both postgres and mysql to keep names aligned.

Change-Id: I729a5e5f4dd8b33dba1aa3f8ddeae92457c50c27
Signed-off-by: Ghada El-Zoghbi <ghada@xxxxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1326205

Title:
  Error installing triggers for new mahara site in MySQL with dbprefix

Status in Mahara ePortfolio:
  In Progress
Status in Mahara 1.7 series:
  New
Status in Mahara 1.8 series:
  New
Status in Mahara 1.9 series:
  New

Bug description:
  Version: Mahara 1.10.0.dev (master)
  OS: Linux
  db: MySql
  Browser: Firefox

  
  When creating a brand new Mahara install, getting the following error:

  Component: artefact.file
  Version: 1.2.2

  Could not execute command: CREATE TRIGGER "testing_unmark_quota_exeed_notified_on_update_usr_setting_trigger" AFTER UPDATE ON "testing_usr" FOR EACH ROW BEGIN UPDATE "testing_usr_account_preference", "testing_artefact_config" SET "testing_usr_account_preference".value = 0 WHERE "testing_usr_account_preference".field = 'quota_exceeded_notified' AND "testing_usr_account_preference".usr = NEW.id AND "testing_artefact_config".plugin = 'file' AND "testing_artefact_config".field = 'quotanotifylimit' AND NEW.quotaused/NEW.quota < "testing_artefact_config".value/100; END
  Call stack (most recent first):

      execute_sql(" CREATE TRIGGER {unmark_quota_exeed_no...") at /var/www/maharacode/mahara/htdocs/lib/dml.php:1794
      db_create_trigger("unmark_quota_exeed_notified_on_update_usr_setting", "AFTER", "UPDATE", "usr", " UPDATE {usr_account_preference}, ...") at /var/www/maharacode/mahara/htdocs/artefact/file/lib.php:167
      PluginArtefactFile::set_quota_triggers() at /var/www/maharacode/mahara/htdocs/artefact/file/lib.php:103
      PluginArtefactFile::postinst(0) at Unknown:0
      call_user_func_array(array(size 2), array(size 1)) at /var/www/maharacode/mahara/htdocs/lib/mahara.php:1562
      call_static_method("PluginArtefactFile", "postinst", 0) at /var/www/maharacode/mahara/htdocs/lib/upgrade.php:543
      upgrade_plugin(object(stdClass)) at /var/www/maharacode/mahara/htdocs/admin/upgrade.json.php:86

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