mahara-contributors team mailing list archive

[Aaron Wells <1326205@xxxxxxxxxxxxxxxxxx>]

Marking as "medium" priority because dbprefix is not that commonly used
anymore. On the other hand, most people who use it will be mysql users
(on cheap shared hosting setups that only give them one database).

Definitely worth fixing, though.

** Tags added: mysql

** Summary changed:

- Error installing triggers for new mahara site
+ Error installing triggers for new mahara site in MySQL with dbprefix

** Changed in: mahara
   Importance: Undecided => Medium

** Changed in: mahara
       Status: New => In Progress

** Changed in: mahara
    Milestone: None => 1.10.0

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

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