Sorry. A non-recoverable error has occurred.

[TheoRichel]

Hi,

I  get the error Sorry. A non-recoverable error has occurred. after running the upgrade script for an upgrade to CiviCRM 3.4.7. I have no idea where to look now. Any suggestions? Thanks

BTW: I am on Drupal 6

[Hershel]

When that happens there is normally an error message, but it's hidden. Usually you can click to open it, but if you can't, then do View Source and you can see the error in there and you could post that so we can see what it is.

[TheoRichel]

Thank you. I didnt know that option. here is the code the error button is supposed to produce:
<code><script type="text/javascript" src="/sites/all/modules/civicrm/js/jquery/jquery.crmaccordions.js"></script>
</head>
<body>
<div id="crm-container" lang="en" xml:lang="en">
<div class="messages status">  <div class="icon red-icon alert-icon"></div>
 <span class="status-fatal">Sorry. A non-recoverable error has occurred.</span>
    <div class="crm-section crm-error-message"></div>
            <hr style="solid 1px" />
        <div class="crm-section crm-error-message">DB Error: no such field</div>
                <div class="crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block">
         <div class="crm-accordion-header">
          <div class="icon crm-accordion-pointer"></div>
           Error Details         </div><!-- /.crm-accordion-header -->
         <div class="crm-accordion-body">
                                        <div class="crm-section">Database Error Code: Unknown column 'content' in 'field list', 1054</div>
                                        <div class="crm-section">Additional Details: <p><pre>Array
(
    [callback] =&gt; Array
        (
           

• =&gt; CRM_Core_Error
[1] =&gt; handle
        )

   

Code: [Select]

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => UPDATE civicrm_dashboard_contact SET content = NULL [nativecode=1054 ** Unknown column 'content' in 'field list']
    [type] => DB_Error
    [user_info] => UPDATE civicrm_dashboard_contact SET content = NULL [nativecode=1054 ** Unknown column 'content' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_dashboard_contact SET content = NULL [nativecode=1054 ** Unknown column 'content' in 'field list']"]
)
</pre></p><p></p></div></code>

[Donald Lobo]

what version were u upgrading from?

lobo

[TheoRichel]

3.4

[TheoRichel]

Sorry to be pushy, but I cannot use CiviCRM now and this is a production site, is there someone who can explain this error or tell me how to get rid of it?
Many thanks

[xavier]

Hi, it means that some database update didn't happen. The upgrade didn't make any error?

1) you can try to run the upgrade again, see if it works.
2) you can fix the hard way, and see what part of the sql update didn't happen, and run them manually. I would not recommend this road unless you are very comfortable with sql and the civi structure.


Do you have a backup of the db before the upgrade? you might want to start again
X+

[TheoRichel]

Thank you.
If I do the upgrade again, I get the message: Sorry. A non-recoverable error has occurred.
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.

But this also happened before. I dropped the Civicrm tables (which wasnt easy since they seem to be dependent upon each other) and when the database was empty (no tables) I reloaded the 3.4 backup and ran upgrade again. This theen ends with the first non recoverable error that i reported about.

Could this have something to do with the problem in phpmyadmin when I try to delete all civicrm tables?
In Drupal my modules still indicate CivicRM v 3.4 (all Civicrm modules are disabled except the main CivicRM module).

[TheoRichel]

In order to be able to reload the older backup I need to delete the tables in the db. However, when I try to do that, I get the message:

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

I can  however delete some other tables, and by working that way I can release the tables that are not 'free'. So step by step I can drop the tables, but this might not be the right way to do it.

[xavier]

What I did for sql/civicrm_drop.mysql
was to add a
SET FOREIGN_KEY_CHECKS=0;
drop everything
SET FOREIGN_KEY_CHECKS=1;


use sql/civicrm/drop, should work, and disabling the foreign key check definitely works

X+

[TheoRichel]

Thanks again. It doesnt work however, but that may have to do with my database structure. I have two databases, one for Drupal ('_grk') and one for CIVICRM. When I switch off foreign key constraints in the Civicrm db the command gets executed allright, but has no consequences, the error message about FK constraints remains when I try to delete a table.
However  I have also an annex database called 'Information schema' that contains  a table 'Table Constraints' with several declarations of both primary keys as well as foreign keys and both for my Drupal database as well as for my Civicrm database. I suppose I should execute the command here, but I am unsure about the syntaxis. A phpmyadmin-screenshot is attached.

[Hershel]

In my experience, if you select all CiviCRM tables and DROP them,  yes, you get an error, but many do get dropped. Repeat that process 4 or 5 times and they will all get dropped.

Other option is to simply delete the entire database and then recreate it--that always works.
 

[TheoRichel]

Yes that way of deletion works, but then I reupload my backup into the empty database and the upgrade then fails. I think it has to do with the fact that in a separate db 'Information schema' there is a table called Table Constraints which contains primary keys, foreign keys and unique keys for both the databases (Drupal and Civicrm). There are 250 records with foreign keys alone for Civicrm. I could delete them manually, but since this is apparently a sort of superdatabase, controlling the two below. I am affraid to destroy something, especially since 'foreign keys' do mean  (or not?) that they have a link with another database.

I do have backups though, but so far no one has explained existence of the Information Schema database to me.

[Donald Lobo]

please check the mysql forums and/or docs for more info on the "information schema" database. that is a mysql maintained and managed DB

lobo

[Hershel]

My guess is that you will need to manually debug to upgrade. I have run such upgrades, where due to SQL errors, I had to manually edit the upgrade files until it ran. I never saw this with such a late version of CiviCRM, but that's the only suggestion I can offer.