Answers.Body: <p>The tables that use triggers are: <code>civicrm_contact</code>, <code>civicrm_address</code>, <code>civicrm_phone</code>, <code>civicrm_email</code>, <code>civicrm_im</code>, and <code>civicrm_phone</code>.  Additionally, if you turn on advanced logging, all tables have triggers.  The Summary Fields extension also creates triggers.</p>
  
  <p>The "core" triggers are mainly used for updating the <code>modified_date</code>, though they also generate a value for a hidden numeric-only phone field (used for SMS etc.).</p>
  
  <p>In all though - I would NOT use GoDaddy for hosting.  CiviCRM uses far more resources than a brochureware WordPress site.  While I hear your concerns about cost, there's plenty of VPS services that cost the same as GoDaddy hosting - assuming you or someone else is willing to manage the server.  I use Linode, whose $10/month plan will give you far better performance than any shared hosting out there.  There's equivalent plans from smaller VPS providers too.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-07T06:28:46.437Z
Answers.Text: Thanks Jon G.  I have been in touch with Linode and the packages do indeed seem reasonable.  Are you interested in assisting a poor volunteer working in Nepal to do server setup and migration of a very basic (static HTML) website? :)
Answers.UserDisplayName: jkobier
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-03T16:59:38.883Z
Answers.LastActivityDate: 2016-10-03T16:59:38.883Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>After spending 3 months configuring and testing CiviCRM on a locally hosted/internal server (and being suitably impressed), I attempted to install onto our website which is hosted with GoDaddy.  </p>
  
  <p>I kept running into an error that prevented CiviCRM from installing being that I am unable to install triggers on the DB due to permissions in a shared server environment.  </p>
  
  <p>I appear to have 2 options:
  1 - fork out more $$$ to get a dedicated server or VPS.  Not possible.</p>
  
  <p>2 - Move from GoDaddy to HostGator who claim to allow triggers. "We can enable trigger privileges for your database, simply contact us via phone or Live Chat with the database, database user, and the tables that you require the permissions on."</p>
  
  <p>Can anyone provide a list of tables that require the trigger permissions added please?</p>
  
  <p>Or provide an alternate hosting solution/suggestion, noting that the organisation is a Not For Profit based in Nepal and not able to spend much money on a solution.</p>
  
  <p>Thanks, Joe.</p>
  
Tags: <database><installation><mysql>
Title: Installation Issue - Database Triggers not allowed by hosting provider
ThreadText: # Installation Issue - Database Triggers not allowed by hosting provider
  
  (Asked by: username_0 on 2016-10-03)
  
  After spending 3 months configuring and testing CiviCRM on a locally hosted/internal server (and being suitably impressed), I attempted to install onto our website which is hosted with GoDaddy.
  
  I kept running into an error that prevented CiviCRM from installing being that I am unable to install triggers on the DB due to permissions in a shared server environment.
  
  I appear to have 2 options:
  1 - fork out more $$$ to get a dedicated server or VPS. Not possible.
  
  2 - Move from GoDaddy to HostGator who claim to allow triggers. "We can enable trigger privileges for your database, simply contact us via phone or Live Chat with the database, database user, and the tables that you require the permissions on."
  
  Can anyone provide a list of tables that require the trigger permissions added please?
  
  Or provide an alternate hosting solution/suggestion, noting that the organisation is a Not For Profit based in Nepal and not able to spend much money on a solution.
  
  Thanks, Joe.
  
  **Tags:** database, installation, mysql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-10-03. Score: 2
  
  The tables that use triggers are: `civicrm_contact`, `civicrm_address`, `civicrm_phone`, `civicrm_email`, `civicrm_im`, and `civicrm_phone`. Additionally, if you turn on advanced logging, all tables have triggers. The Summary Fields extension also creates triggers.
  
  The "core" triggers are mainly used for updating the `modified_date`, though they also generate a value for a hidden numeric-only phone field (used for SMS etc.).
  
  In all though - I would NOT use GoDaddy for hosting. CiviCRM uses far more resources than a brochureware WordPress site. While I hear your concerns about cost, there's plenty of VPS services that cost the same as GoDaddy hosting - assuming you or someone else is willing to manage the server. I use Linode, whose $10/month plan will give you far better performance than any shared hosting out there. There's equivalent plans from smaller VPS providers too.
  
  > **Comments:**
  > **username_0**: Thanks Jon G.  I have been in touch with Linode and the packages do indeed seem reasonable.  Are you interested in assisting a poor volunteer working in Nepal to do server setup and migration of a very basic (static HTML) website? :)  
  
  ---
  
  