CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Problems with TRIGGER
Pages: [1]

Author Topic: Problems with TRIGGER  (Read 741 times)

Dan C

  • I post frequently
  • ***
  • Posts: 179
  • Karma: 17
  • CiviCRM version: All
  • CMS version: Joomla 2.5 and 3.X, Drupal 7, Wordpress 3.7 and up
  • MySQL version: 5.1.7 and up
  • PHP version: 5.3.5 and up
Problems with TRIGGER
April 09, 2013, 06:28:30 am
Hello all,

I am working with a client that with an existing Joomla 1.5.26/CiviCRM 3.4.8 installation that is having problems.  While going through the logs it looks like a lot of them all end up with the same error message

[userinfo] => CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]

I have done my research and presented them with two options, they could grant Super access to the SQL user or upgrade to MySQL 5.1 or higher (they are currently on 5.0.96).  They went back to their host and the host told us that because they are on shared hosting they refuse to let us grant Super Access to the user or upgrade MySQL for fear of breaking the other sites on the server.

So I'm wondering, are their any other options to get around this error?  I'm hoping that someone might have a trick to make Civi 3.4.8 work under SQL 5.0.96 without granting Super privileges.

Thanks!
CrusonWeb - Web Development, Implementation, and Support.  Specializing in CiviCRM and Joomla (although also knowledgable in Wordpress and Drupal as well).

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Problems with TRIGGER
April 10, 2013, 10:34:28 am
Quote from: danc on April 09, 2013, 06:28:30 am
So I'm wondering, are their any other options to get around this error?

I am fairly certain there is no other option, no.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Problems with TRIGGER
April 10, 2013, 01:35:05 pm
i think that you only need triggers when you have logging turned on.  if you turn logging off, you might find this problem goes away.
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Problems with TRIGGER
April 10, 2013, 05:00:27 pm

for 4.2 and prior, triggers were needed only for multi-lingual and logging

in 4.3, triggers are used in more places and i suspect the usage will continue to grow in future releases (along with stored procedures)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Problems with TRIGGER

This forum was archived on 2017-11-26.