CiviCRM Community Forums (archive)

I had sort of the same thing happen upgrading to 3.2.3. I can't remember what version I had before, but it was 3. something. I got this error on upgrade:

Sorry. A non-recoverable error has occurred.
DB Error: no such field

I'm not very good at back-end stuff, I'd sure like some more step-by-step ideas?

Thanks,

Tina

The upgrade checks for one key:

    function upgrade_3_2_1($rev)
    {
        //CRM-6565 check if Activity Index is already exists or not.
        $addActivityTypeIndex = true;
        $indexes = CRM_Core_DAO::executeQuery( 'SHOW INDEXES FROM civicrm_activity' );
        while ( $indexes->fetch( ) ) {
            if( $indexes->Key_name == 'UI_activity_type_id' ){
                $addActivityTypeIndex = false;
            }
        }

But if you don't have that one it assumes you don't have the other offending keys - you could try tinkering with that funciton

Does anyone know where i can get a current 3.2 database schema?  Instructions say "Import the original database structure from the same version of CiviCRM you are currently using: civicrm/sql/civicrm.sql (this file is found relative to your root civicrm directory) " but that seems dated.  there are several schema files there.  do i load several to get a complete structure?  thx. s.

In my upgrade from 3.1.5 to 3.2.3 I apparently had a partial upgrade which left tables which the upgrade script would not touch. Here is what I had to do to get the upgrade to work.

DROP TABLE `civicrm_entity_financial_trxn`;
DROP TABLE `civicrm_financial_account`;
DROP TABLE `civicrm_website`;
DROP TABLE `civicrm_address_format`;
ALTER TABLE `civicrm_activity` DROP INDEX `index_medium_id` ;
ALTER TABLE `civicrm_activity` DROP INDEX `index_is_current_revision` ;
ALTER TABLE `civicrm_activity` DROP INDEX `index_is_deleted` ;

For me the tables were all empty since I had reverted to the 3.1.5 php. Anyone thinking of cutting and pasting these commands in to phpmyadmin would be advised to see if that is true in their case.