CiviCRM Community Forums (archive)

I have imported an sql file from a CSOD backup into a "dummy site" with a goal towards exporting the data for import into our real site.

The CSOD site was broken for most of the time we had it and we were and still are unable to export our data. They fixed the backup module but not the export problem, so all I have is an sql that hasn't done me a whole lot of good so far. PHPMyadmin does not seem to really like this file very much and I'm not even sure if it imported properly. The file is 37.9 MB but cpanel says it is 1.31 every time igt gets installed.

Anyways, this is what I get after I enable CiviCRM:


Sorry. A non-recoverable error has occurred.

Database Error Code: Unknown column 'is_test' in 'where clause', 1054

Return to home page.


Error Details:


Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => select count(civicrm_activity.id) from civicrm_activity
                  left join civicrm_activity_target on
                            civicrm_activity.id = civicrm_activity_target.activity_id
                  left join civicrm_activity_assignment on
                            civicrm_activity.id = civicrm_activity_assignment.activity_id
                  where  ( source_contact_id = 1 or target_contact_id = 1 or assignee_contact_id = 1 )
                  and is_test = 0 and 1 and 1 [nativecode=1054 ** Unknown column 'is_test' in 'where clause']
    [type] => DB_Error
    [user_info] => select count(civicrm_activity.id) from civicrm_activity
                  left join civicrm_activity_target on
                            civicrm_activity.id = civicrm_activity_target.activity_id
                  left join civicrm_activity_assignment on
                            civicrm_activity.id = civicrm_activity_assignment.activity_id
                  where  ( source_contact_id = 1 or target_contact_id = 1 or assignee_contact_id = 1 )
                  and is_test = 0 and 1 and 1 [nativecode=1054 ** Unknown column 'is_test' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="select count(civicrm_activity.id) from civicrm_activity
                  left join civicrm_activity_target on
                            civicrm_activity.id = civicrm_activity_target.activity_id
                  left join civicrm_activity_assignment on
                            civicrm_activity.id = civicrm_activity_assignment.activity_id
                  where  ( source_contact_id = 1 or target_contact_id = 1 or assignee_contact_id = 1 )
                  and is_test = 0 and 1 and 1 [nativecode=1054 ** Unknown column 'is_test' in 'where clause']"]
)




Thanks Speleo. That advice got me a couple of steps further.

Thru PHPmyadmin, it seems like the 1.7 to 1.8, and then 1.8 to 1.9 db updates went smoothly, but attempts to run the upgrade script from there get me a PAGE NOT FOUND error. I tried a couple of different combos, like removing index.php from the link, but same PAGE NOT FOUND.

Couldn't find what seemed like any appropriate file in the civicrm dir to point browser to either.

What (or where) are the instructions for completing this step in PHPmyadmin?:

*Dump the data ONLY from your existing 1.9 database to a file:


Does this mean an export .... or I should empty the tables .. ?

Dave, I don't understand what you mean aboot checkboxes, but I did figure out it was a 1.7 db. Did the 17 to 18, then the 18 to 19, and I just now followed the instructions I linked to above for 19 to 2.0.

The upgrade script gave me this:

Sorry. A non-recoverable error has occurred.
Database consistency check failed.

Return to home page.

Return to home page gives me this:

Fatal error: Call to a member function getConfigObject() on a non-object in /home/ccag/public_html/test/sites/all/modules/civicrm/CRM/Core/Config/Defaults.php on line 205