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) »
  • Sorry. A non-recoverable error has occurred.
Pages: 1 2 3 [4]

Author Topic: Sorry. A non-recoverable error has occurred.  (Read 16557 times)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 04:12:24 am
Should be more like:

Code: [Select]
INSERT INTO civicrm_navigation(
domain_id,
url,
label,
name,
permission,
permission_operator,
parent_id,
is_active,
has_separator,
weight
)
VALUES (
1, NULL , 'CiviCampaign, 'CiviCampaign', 'administer CiviCampaign,administer CiviCRM', 'AND', @administerID , '1', NULL , @adminCampaignWeight
);
but replace @administerID and @adminCampaignWeight with integers. Not 100% sure what however...

the other approach is to export all the data that you can and then install CiviCRM fresh and import.

OR setup to DBs and make a PHP script to transfer the needed data from the "bad' to the new, good DB.
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.

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 04:18:55 am
Just a reminder: when deleting the old tables I am still getting this message:

#1217 - Cannot delete or update a parent row: a foreign key constraint fails

Could that be blocking the upgrade?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 04:19:59 am
Just keep dropping all tables and eventually they will get dropped. This should not cause problems in the future.

Other option is to delete the entire DB and make a fresh one with the same name. :)
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.

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 05:10:34 am
I have  a 3.4.0 db runnig on 3.4.1. code but I havent ran the upgrade script yet. of course I should, but meanwhile I came accross this message:
Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues. This will be a fatal error in CiviCRM v2.1. Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again.

Could that be an explanation?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 05:13:10 am
Quote from: TheoRichel on December 28, 2011, 05:10:34 am
Could that be an explanation?

Yes!! :)

You have finally, it seems, found the problem. CiviCRM indeed requires InnoDB.
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.

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 05:20:56 am
It seems like switching to Innodb (my Drupal db is Myisam as well) is an even bigger problem as discovering this, or isnt it?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 05:26:36 am
No, it is possible to convert tables to InnoDB. I have done this before. This is only required for the CiviCRM database, however.
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.

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 05:41:17 am
Yes so I discovered myself meanwhile as well, however, when I go into Phpmyadmin all but three tables in the Civicrm db are Innodb. The three tables that are MyIsam are: civicrm_task_action_temp_(and then large numbers).

Might it have to do with the overal db structure? Or an overall setting? I have a Drupal db (MyIsam) a Civicrm dfb (largely InnoDB) but also an Information schema on top of that (which I am not supposed to touch) all tables there are either of Memory type or MyIsam type.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 05:46:48 am
Hmmm, no it's just a per-table setting AFAIK and only with regards to the CiviCRM DB. I'm not 100% sure but I don't think those temp tables are important to be InnoDB, either. I don't think anyway that they are related to any of your errors...
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.

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 06:47:57 am
Still, when so many tables are Innodb, why does CIVICRM nevertheless think they are MyIsam?

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 07:30:43 am
This is a Drupal Back Trace of the last failed upgrade. Any use?

$backTrace = /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 205 , handle, /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Utils/File.php, query, 260 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php, sourceSQLFile, 154 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php, source, 276 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php, processLocales, 292 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php, processSQL, 230 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 223 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 363 , civicrm_invoke, /home/theorichel/domains/grkmain.com/public_html/includes/menu.inc, call_user_func_array, 349 /home/theorichel/domains/grkmain.com/public_html/index.php, menu_execute_active_handler, 17

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 07:56:45 am
If I put the  'original' 3.4.0. code back in place, as well as the backup from the  tables that was made with that version, do I then still need to run the upgrade script?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 10:47:20 am
Quote from: TheoRichel 
Still, when so many tables are Innodb, why does CIVICRM nevertheless think they are MyIsam?

I do not know.

Quote from: TheoRichel on December 28, 2011, 07:56:45 am
If I put the  'original' 3.4.0. code back in place, as well as the backup from the  tables that was made with that version, do I then still need to run the upgrade script?

Seems that you would NOT need to.

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.

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Sorry. A non-recoverable error has occurred.
December 28, 2011, 01:12:49 pm
Well it seems that  I am back with a running version of 3.4.0. There still is a warning however:

warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'civicrm_invoke' was given in /home/theorichel/domains/grkmain.com/public_html/includes/menu.inc on line 349.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Sorry. A non-recoverable error has occurred.
December 29, 2011, 04:48:04 am
Hmm, same error here: http://forum.civicrm.org/index.php?topic=22117.0

Can you flush all Drupal caches, and then if the problem persists, make a new forum thread here with full details of the situation. Then also others will be able to look at it.
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.
Pages: 1 2 3 [4]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Sorry. A non-recoverable error has occurred.

This forum was archived on 2017-11-26.