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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade from 4.4.3 to 4.4.4 fails
Pages: [1]

Author Topic: Upgrade from 4.4.3 to 4.4.4 fails  (Read 987 times)

ericross

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • civiadmin
    • National Day of Prayer New York
  • CiviCRM version: 4.6.2
  • CMS version: WordPress 4.1.1
  • MySQL version: 5.5.40-36.1
  • PHP version: 5.4.38
Upgrade from 4.4.3 to 4.4.4 fails
February 18, 2014, 11:40:34 pm
Upgrade to 4.4.4 failed. I exported the data structure and compared it to civicrm.mysql from 4.4.3 and the upgrade failed again.
Usability Matters.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Upgrade from 4.4.3 to 4.4.4 fails
February 19, 2014, 01:21:55 am
looks like your install was partially upgraded, hence retrying fails. I would suggest to restoring back to you db backup and then retry upgrade.

Kurund
Found this reply helpful? Support CiviCRM

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Upgrade from 4.4.3 to 4.4.4 fails
February 19, 2014, 07:03:13 pm
@ericross When a failed upgrade causes a schema integrity issue, follow this procedure restore schema integrity.  HOWEVER that is NOT necessary if you have a valid backup of 4.4.3.  But what you must do is entirely drop the database and then recreate a database of the same name from your backup.  Otherwise invalid tables will still exist if you simply try to drop/create the tables+data back in.  You seem like a technical person so I hope this makes sense.
Try CiviTeacher: the online video tutorial CiviCRM learning library.

ericross

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • civiadmin
    • National Day of Prayer New York
  • CiviCRM version: 4.6.2
  • CMS version: WordPress 4.1.1
  • MySQL version: 5.5.40-36.1
  • PHP version: 5.4.38
Re: Upgrade from 4.4.3 to 4.4.4 fails
February 20, 2014, 06:05:34 am
Importing the backup of 4.4.3 fails at civicrm_address. Hosting group also tried and get the same error so not a privileges problem.


I do have tables and data. Looks like TRIGGER's are missing.


ErrorSQL query:DELIMITER ;; /*!50003 CREATE*//*!50017 DEFINER=`ndpnyorg_cvrm1`@`localhost`*//*!50003 TRIGGER civicrm_address_after_insert after insert ON civicrm_address FOR EACH ROW BEGIN UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.contact_id; END */ ;;MySQL said: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
« Last Edit: February 20, 2014, 06:46:24 am by ericross »
Usability Matters.

ericross

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • civiadmin
    • National Day of Prayer New York
  • CiviCRM version: 4.6.2
  • CMS version: WordPress 4.1.1
  • MySQL version: 5.5.40-36.1
  • PHP version: 5.4.38
Re: Upgrade from 4.4.3 to 4.4.4 fails
February 20, 2014, 03:55:02 pm
I've been through backups to version 4.3.0 on 4/22/2013 and get this same TRIGGER Access Denied error with all of them.


Looks like this is a MySQL issue with export/import.


http://www.mysqlperformanceblog.com/2013/02/11/unexpected-problem-with-triggers-and-mysqldump/
http://www.w3resource.com/mysql/mysql-triggers.php


Since all of my backups include TRIGGERS, it looks like I could manually strip out the TRIGGERS, import and then create TRIGGERS ...



OK, back to the previous suggestion: http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades


Since civicrm.mysql imports cleanly, if I can separate my backup data into one file and custom fields into another I may be able to get back to 4.4.3. This doesn't help me with why the 4.4.4 upgrade failed.
« Last Edit: February 20, 2014, 04:08:25 pm by ericross »
Usability Matters.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Upgrade from 4.4.3 to 4.4.4 fails
February 23, 2014, 04:31:57 pm
I think we backup our Dbs without triggers  - add the --skip-triggers switch to your mysqldump command
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

ericross

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • civiadmin
    • National Day of Prayer New York
  • CiviCRM version: 4.6.2
  • CMS version: WordPress 4.1.1
  • MySQL version: 5.5.40-36.1
  • PHP version: 5.4.38
Re: Upgrade from 4.4.3 to 4.4.4 fails
February 24, 2014, 01:53:39 pm
Thanks Eileen. This was't the best way for me to learn that lesson. I know better, and should have actually tested my ability to recover.

I was able to get running again by manually stripping out triggers from my backup and going back to 4.4.3 but that leaves me with no triggers. Is this the best way to get triggers back?

follow this procedure

A mention of --skip-triggers with mysqldump on this Procedure to Rebuild page might be a good addition.
« Last Edit: February 24, 2014, 02:41:57 pm by ericross »
Usability Matters.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Upgrade from 4.4.3 to 4.4.4 fails
February 24, 2014, 02:06:44 pm
Turning on logging in the UI will recreate all logging related triggers - there are a couple of non-logging triggers - I *think* they get recreated too.

You may need to turn logging off before you can turn it on
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade from 4.4.3 to 4.4.4 fails

This forum was archived on 2017-11-26.