CiviCRM Community Forums (archive)

After fighting with a few problems and losing some config data after the upgrade to 2.04, I decided to try to go back to 1.9 by rebuilding my database from my pre-upgrade backup and re-installing the 1.9 files.  However, after doing that, no matter what I try, I can't get past this error:

Unknown column 'ce.contact_id' in 'on clause', 1054

Here is the backtrace:

/home/campus/public_html/members/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 148
, handle,
/home/campus/public_html/members/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 901
/home/campus/public_html/members/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 888
/home/campus/public_html/members/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 563
/home/campus/public_html/members/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1849
/home/campus/public_html/members/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 894
/home/campus/public_html/members/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 324
/home/campus/public_html/members/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1162
/home/campus/public_html/members/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2344
/home/campus/public_html/members/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1566
/home/campus/public_html/members/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 664
/home/campus/public_html/members/sites/all/modules/civimember_roles/civimember_roles.module, executeQuery, 431
/home/campus/public_html/members/sites/all/modules/civimember_roles/civimember_roles.module, _civimember_roles_sync, 61
, civimember_roles_menu,
/home/campus/public_html/members/includes/module.inc, call_user_func_array, 406
/home/campus/public_html/members/includes/menu.inc, module_invoke_all, 1224
/home/campus/public_html/members/includes/menu.inc, _menu_append_contextual_items, 220
/home/campus/public_html/members/includes/menu.inc, menu_get_menu, 441
/home/campus/public_html/members/includes/menu.inc, menu_set_active_item, 425
/home/campus/public_html/members/sites/all/modules/securepages/securepages.module, menu_get_active_item, 245
/home/campus/public_html/members/sites/all/modules/securepages/securepages.module, securepages_match, 24
, securepages_init,
/home/campus/public_html/members/includes/module.inc, call_user_func_array, 406
/home/campus/public_html/members/includes/common.inc, module_invoke_all, 1865
/home/campus/public_html/members/includes/bootstrap.inc, _drupal_bootstrap_full, 922
/home/campus/public_html/members/includes/bootstrap.inc, _drupal_bootstrap, 862
/home/campus/public_html/members/index.php, drupal_bootstrap, 13

and the error:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT status_id, email, cm.contact_id FROM civicrm_membership cm
                    LEFT JOIN civicrm_contact cc ON cm.contact_id = cc.id
                    LEFT JOIN civicrm_email ce ON cc.id = ce.contact_id
                    WHERE contact_type = 'Individual' 
                    AND ce.is_primary = 1
                    AND membership_type_id = 1
                    AND cc.domain_id = 1 AND cc.id = 101 [nativecode=1054 ** Unknown column 'ce.contact_id' in 'on clause']
    [type] => DB_Error
    [user_info] => SELECT status_id, email, cm.contact_id FROM civicrm_membership cm
                    LEFT JOIN civicrm_contact cc ON cm.contact_id = cc.id
                    LEFT JOIN civicrm_email ce ON cc.id = ce.contact_id
                    WHERE contact_type = 'Individual' 
                    AND ce.is_primary = 1
                    AND membership_type_id = 1
                    AND cc.domain_id = 1 AND cc.id = 101 [nativecode=1054 ** Unknown column 'ce.contact_id' in 'on clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT status_id, email, cm.contact_id FROM civicrm_membership cm
                    LEFT JOIN civicrm_contact cc ON cm.contact_id = cc.id
                    LEFT JOIN civicrm_email ce ON cc.id = ce.contact_id
                    WHERE contact_type = 'Individual' 
                    AND ce.is_primary = 1
                    AND membership_type_id = 1
                    AND cc.domain_id = 1 AND cc.id = 101 [nativecode=1054 ** Unknown column 'ce.contact_id' in 'on clause']"]
)

The thing is, this is the same combo of code and database that were working fine before I tried the upgrade, so I don't understand why I'd be getting this error.  What make it worse is that I can't get past it to anything.  No matter what page I go to, I get this error.  How can I get around this?  I'm thinking I need to disable a couple modules, but I can't even get to the admin pages to do it.

Thanks.[/code]