mahara-contributors team mailing list archive

[Jamshid <jamshid.dastur@xxxxxxxxx>]

I tried executing the mentioned command but it fails. Please see the reply
from support team of GoDaddy
Discussion Notes*Support Staff Response*Dear Teen,

Thank you for contacting Online Support. I understand you have a question
regarding enabling triggers in your MySQL database. In order to protect our
shared servers we restrict the following features:

*MySQL 5.0*:


   - Triggers will not be supported in the MySql 5.0 offering because the
   SUPER privilege is needed to run all triggers. A bug report was
   submitted to MySql AB for a privilege tables fix in later versions of MySql
   5.1.
   - Stored functions are not allowed, however, deterministic stored
   procedures/routines will be supported. For more information see Are
   stored procedures allowed in MySQL <http://help.godaddy.com/article/2449>


*MySQL 4.1 and 5.0*:


   - The Berkeley storage engine is no longer supported by us or MySQL AB.
   If you have tables which use the Berkeley storage engine you may continue
   to use that table, however we will not support it. We advise that all
   customers convert their Berkeley storage engine tables into InnoDB.


Please let us know if we can assist you in any other way.

Regards,
Topher P.
Online Support


Regards
Jamshid
On Mon, Apr 30, 2012 at 3:44 PM, Ruslan Kabalin
<990959@xxxxxxxxxxxxxxxxxx>wrote:

> MySQL on Godaddy does not support trigger creation at all, or does not
> support TRIGGER permission?
>
> In either case, this is not a Mahara bug I think. The only thing I can
> recommend, if you have direct access to MySQL console, run command that
> is described here:
>
> https://wiki.mahara.org/index.php/System_Administrator%27s_Guide/Granting_Trigger_Privilege
>
> ** Changed in: mahara
>       Status: New => Invalid
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/990959
>
> Title:
>  requires permission to create database triggers which MYSQL5 doesn't
>  support on godaddy
>
> Status in Mahara ePortfolio:
>  Invalid
>
> Bug description:
>  requires permission to create database triggers which MYSQL5 doesn't
>  support on godaddy
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/mahara/+bug/990959/+subscriptions
>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/990959

Title:
  requires permission to create database triggers which MYSQL5 doesn't
  support on godaddy

Status in Mahara ePortfolio:
  Invalid

Bug description:
  requires permission to create database triggers which MYSQL5 doesn't
  support on godaddy

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