Reviewed:  https://reviews.mahara.org/8988
Committed: 
https://git.mahara.org/mahara/mahara/commit/6307cc7fdfbf8c824bc7637d90317198242217ab
Submitter: Cecilia Vela Gurovic ([email protected])
Branch:    master

commit 6307cc7fdfbf8c824bc7637d90317198242217ab
Author: Yaju Mahida <[email protected]>
Date:   Mon Jul 2 13:21:39 2018 +1000

Bug 1779049: Make mysql_has_trigger_privilege() work better / more
robust

behatnotneeded

Author:    Yaju Mahida <[email protected]>

Change-Id: I4a2c51a4a7af0842cc37ba710cdaec6c2d053d75

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

Title:
  Make mysql_has_trigger_privilege() work better / more robust

Status in Mahara:
  Fix Committed

Bug description:
  Currently the function mysql_has_trigger_privilege() checks if we can
  make triggers on the database but if we have a problem during upgrade
  we can get in the state where the 'testtable' exists (not being
  cleaned up)

  Also mysql_has_trigger_privilege() gets checked on every step of db
  upgrade

  We need to do 2 things

  1) Make the need to run mysql_has_trigger_privilege() more infrequent by 
setting a flag in the db config table if the check passes
  2) Make the check more robust so that if the 'testtable' already exists (was 
not cleaned up) we handle that in a better manner, eg drop trigger if exists 
then try adding trigger again

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

_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help   : https://help.launchpad.net/ListHelp

Reply via email to