Author Topic: CiviCRM 4.3.5 requires MySQL trigger privileges. (Read 3206 times)

FrTommy · July 20, 2013, 02:40:34 pm

I just attempted to upgrade from 4.3.3 to 4.3.5 and i'm getting the

Sorry but we are not able to provide this at the moment. CiviCRM 4.3.5 requires MySQL trigger privileges.

i've checked with my host and they allow trigger privileges and we checked the privileges to ensure they were set. but still the error....

<sigh> I've had it with Civi....error after error after error. Every upgrade introduces a new error. It's just too buggy to actually use. one upgrade ruins the whole darn database and you lose everything. Even if you do a backup it won't help cuz the sql file is too big to run.

Useless, absolutely useless. If Civi Worked like it was supposed to then it'd be an awesome product.

Hershel · July 22, 2013, 10:06:42 pm

Sorry to hear you are having troubles. I could respond to a few issues and share that upgrading to 4.3.5 works just fine on a server configured correctly. I say this from personal experience.

I have also never lost "everything" due to an upgrade. Also if your backup SQL file is "too big" then you are using the wrong methods of backing it up. Using the Linux command line it's almost impossible to be too big, both for mysqldump and for importing again.

CiviCRM does work, almost always, as it should. A lot of your problems, it would appear, are with your LAMP environment. Perhaps with a new server you would find CiviCRM works much better.

FrTommy · July 23, 2013, 06:56:26 pm

Show me a hosting company that can run Civi that is comparable in price to what I'm running now and will allow me at least 4 different sites. Every hosting company that I've checked out that says it can run civi without problems is more expensive and is less features.

Hershel · July 24, 2013, 04:12:22 am

I am uncertain what to respond here. We can't know what you pay for hosting, but anyhow I don't think that is the issue precisely. The About CiviCRM page makes a point of noting:

Quote

CiviCRM is resource-intensive. We encourage users to consider Virtual Private Servers (VPS) OR (semi) dedicated hosting OR shared hosting from a host with experience hosting CiviCRM.

So while CiviCRM does work, it indeed requires a lot of server resources and thus won't actually run well on every server. In the hosting business, like most other fields, you basically get what you pay for. So whereas there are certainly a multitude of low-cost and even very-low-cost hosts on the market today, the quality of their service and support is generally also quite low. There may certainly be exceptions, but experience (and also researching this subject on the internet) indicates that if you want higher quality hosting, you will need to pay more for it.

So the answer to your question probably is that there is not a hosting company with a super-low price that provides the quality you need to run CiviCRM properly.

xavier · July 24, 2013, 11:29:20 am

Quote from: FrTommy on July 23, 2013, 06:56:26 pm

Show me a hosting company that can run Civi that is comparable in price to what I'm running now and will allow me at least 4 different sites. Every hosting company that I've checked out that says it can run civi without problems is more expensive and is less features.

How much do you pay for hosting? For what I've seen the cheapest hosting options won't work with civi indeed (specifically they don't like when you send mailings).

X+

Donald Lobo · July 24, 2013, 01:50:47 pm

IMHO, hershel's civihosting offering is super reasonable for the support and quality he delivers

comparing hosting services solely on price is not necessarily the rright thing

lobo

FrTommy · July 24, 2013, 07:02:55 pm

I'm on Dreamhost. prior to the 4.xx releases Civi ran fine no real issues and I had their regular shared hosting account. It was a little slow but that's because their MySQL servers are slow. I had no troubles with CiviMail on their servers. It worked fine the only restriction was it throttled emails to 100 an hour. I rarely send that many so it wasn't an issue. With the 4.xx releases It began to be so memory intensive that it would shut my site down quite often on the shared hosting. I made the decision to switch to their VPS hosting which allows you to scale the amount of memory available to the virtual server. I started out at 300 MB of memory for 15.00 a month. That wasn't enough so I increased to 600 MB a month for 30.00. It's still causing a server reboot for hogging too much of the memory.

With the first 4.xx release, and I waited a while before I upgraded to see what sort of troubles would pop up. After a few weeks and not seeing alot of issues I upgraded. The upgrade got all the way to the end and then gave a db error about creating two triggers on the same field or something. I posted a forum topic on here about it. Everything seemed fine though until I started adding a new profile or custom field and i'd get an error saying the database field doesn't exist when I'd click save....yet it would go ahead and create the profile and custom fields. I dealt with the errors. I'm on 4.3.3 right now. I attempted to upgrade to 4.3.5 and it fails the trigger test. Not sure why, 4.3.3 didn't. So I'm stuck at 4.3.3 on Civi until i find a replacement. I'm currently looking at sugarCRM.

I talked to Dreamhost about the trigger issue and they don't know why it's giving the error they give trigger access. The only restriction they put on the trigger access is "Cannot set DEFINER as non-root user, please remove DEFINER='user'@'host' combo to create trigger"

I would switch to civihosting but he only allows 1 site and I have 3 sites. I can't do the drupal multisite option because one site is a complete custom php site. Plus civihosting limits bandwitch and disk space. Not that it would be an issue with my small sites but just seems like if I can pay 8.00 a month and get unlimited why can't he at 15.00 and 20.00 a month.

xavier · July 25, 2013, 12:02:25 am

Hi,

You point out an issue that is a big one indeed: software needs more and more resources. I know I had the problem when moving from drupal 6 to drupal 7, I had to increase the available memory to work properly and I suspect civi isn't better (civiaccount I'm sure increased the resource usage for instance)

This being said, spotting these issues are hard, because when we develop we tend to run on powerful machines with plenty of memory and with small contact databases so if one modification increases the resource needed by 10%, we won't notice it.

I've experienced as well your error message on another server, after a time consuming process, it turned out that it was a mysql configuration issue on the server. What I did was to download the db, run the the upgrade locally and upload the result.

At the end of the day, my personal strategy is that I'm happily throwing the equivalent of the cost of a few coffees per month to avoid loosing wasting more of my time on these problems.

Relationship with a software is a bit like a couple, when things get past the point where every little default that you used to find charming -or at least didn't pay attention to- is going to drives you nuts, it's better to split up. However, like for a couple, it doesn't mean the next one is going to end up better. And with a new software, you don't have the rush of adrenaline and honeymoon period and your are only dealing with the pain of the adjustment to different habits.

As for your backup/restore problem: I would highly recommend you to fix that first. It's a safety device, it just has to work, if it doesn't, it's going to turn a mild issue into a major problem at the worse possible moment.

Good luck.

X+

FrTommy · July 25, 2013, 08:21:16 pm

D7 runs perfectly fine on the server no issues. Civi is the only one that i'm having problems with.

The DB issue i dont know how to fix.....i am clueless when it comes to doing mysql commands through the command line. I've tried a couple times to learn but every resource i've looked at wasn't very helpful and I dont learn really well from a book. I learn better from someone showing me and explaining it and well programmers tend not to be very friendly about teaching someone else skills that could potentially cause them to lose money.

The DB I'm running on is (I think) a partially corrupted DB. I've wanted to export the data only and import into a fresh install but never could get a clear answer as to which tables I needed to export the data from to ensure I got all the data.

My contacts are around 200 with probably 500-1000 activities per contact. I wouldn't call that a large db at all.

CiviCRM Community Forums (archive)

News:

Author Topic: CiviCRM 4.3.5 requires MySQL trigger privileges. (Read 3206 times)

FrTommy

CiviCRM 4.3.5 requires MySQL trigger privileges.

Hershel

Re: CiviCRM 4.3.5 requires MySQL trigger privileges.

FrTommy

Re: CiviCRM 4.3.5 requires MySQL trigger privileges.

Hershel

Re: CiviCRM 4.3.5 requires MySQL trigger privileges.

xavier

Re: CiviCRM 4.3.5 requires MySQL trigger privileges.

Donald Lobo

Re: CiviCRM 4.3.5 requires MySQL trigger privileges.

FrTommy

Re: CiviCRM 4.3.5 requires MySQL trigger privileges.

xavier

Re: CiviCRM 4.3.5 requires MySQL trigger privileges.

FrTommy

Re: CiviCRM 4.3.5 requires MySQL trigger privileges.