CiviCRM Community Forums (archive)

I'm tearing my hair out over how to get past this...

I'm trying to upgrade from 2.2.6 to 3.0.1 but it's stalling with the following error:

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => UPDATE civicrm_report_instance
                       SET form_values = REPLACE(form_values,'#',';')  [nativecode=1146 ** Table 'coaiddrupal.civicrm_report_instance' doesn't exist]
    [type] => DB_Error
    [user_info] => UPDATE civicrm_report_instance
                       SET form_values = REPLACE(form_values,'#',';')  [nativecode=1146 ** Table 'coaiddrupal.civicrm_report_instance' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_report_instance
                       SET form_values = REPLACE(form_values,'#',';')  [nativecode=1146 ** Table 'coaiddrupal.civicrm_report_instance' doesn't exist]"]
)

The civicrm_report_instance table does not exist in the DB, but why isn't it being created as part of the upgrade? I'm running the latest version of Drupal and PHP.

Any ideas please?

Steve[/code]

Hi lobo,

Actually I tried a direct 2.2.3 -> 3.0.1 upgrade and that failed with the same error, then I tried doing it incrementally, and it hit the problem going from 2.2.6 to 2.2.7.

I'm glad I did my backups first.

Any other ideas? I'm really stuck with this.

Thanks,
Steve

Greetings everyone,

I am having a similar issue.

I am trying to upgrade from 2.2.3 to 3.0 and I am also getting table column errors. It seems that the table structure changes in the upgrades. I am pretty new at this and maybe there is an obvious solution, but ... since I have current data in the 2.2.3 table structure, how do I get it into the new table structure? Is there a script that migrates the data or is this something that I need to do manually?

In the 3.0 package there are PHP update scripts, but none of them seem to be labeled for a version 2 to 3 upgrade.

Any advice or links to information would be much appreciated. Thank you in advance 

ok, thanks

wow how did those files have that permission?

we'll need to add some sort of check to make sure we can read those files, but that definitely is a great clue and help to us (and other folks)

thanx for the report back

lobo

Note: PHP’s umask() might be a solution (or at least a way to check) here.