Author Topic: TRIGGER problem  (Read 1384 times)

Offline JJ

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: -
  • CMS version: Drupal and Wordpress
  • MySQL version: 5.5
  • PHP version: 5.3
TRIGGER problem
« on: May 14, 2013, 12:30:03 am »
Hello everybody,

I'm trying to instal CiviCRM on hosting (Wordpress). Now the situation is that I have a main user for DB that has TRIGGER permission (Tested trough phpmyadmin). Other than this user I can create (via control panel) as many DB and DB_user I need, but with no TRIGGER permission (most likely with no SUPER).

As you can imagine I cannot use the main user directly in any app (1 account and user, for many website. Each one is own DB and DBuser).

Now my question is whether it's possible to install CIVICRM by hand with no installer and set up all trigger manually trough  phpmyadmin using the main user or not.

Or perhaps with limited functionality with no trigger at all...

Thanks a lot for your suggestions.

JJ

Offline Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15911
  • Karma: 469
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: TRIGGER problem
« Reply #1 on: May 14, 2013, 09:09:13 am »

unfortunately no :(

might want to consider upgrading mysql and/or switching to a better hosting solution like civihosting.com

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

Offline JJ

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: -
  • CMS version: Drupal and Wordpress
  • MySQL version: 5.5
  • PHP version: 5.3
Re: TRIGGER problem
« Reply #2 on: May 15, 2013, 04:47:46 am »
thanks for your reply...