mahara-contributors team mailing list archive

[Ghada El-Zoghbi <ghada@xxxxxxxxxxxxxxx>]

Developer Note:

MySql triggers -

An INSERT BEFORE triggers will not pass the autoincrement ID in the NEW
row (i.e. ID is an autoincrement column).

Use an INSERT AFTER trigger to get the value of NEW.ID.

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

Title:
  Make Elasticsearch plugin work with MySQL

Status in Mahara ePortfolio:
  In Progress

Bug description:
  The Elasticsearch plugin currently only works in Postgres. The reason,
  is that it's dependent upon a series of triggers which were non-
  trivial to port to MySQL, and the organizations funding the
  development of the plugin were only using Postgres.

  However, it should be a relatively easy job for someone familiar with
  MySQL triggers to port it over.

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