CiviCRM Community Forums (archive)

the system told me that the upgrade is not completed.

Now I can see the main main page of CiviCRM and the versione is 4.2.0 but if I Click on any link appears the error that I posted before:


Database Error Code: Unknown column 'cp.payment_processor' in 'field list', 1054
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => 
    SELECT cr.payment_processor_id as ppID1, cp.payment_processor as ppID2, con.is_test
      FROM civicrm_membership mem
INNER JOIN civicrm_membership_payment mp  ON ( mem.id = mp.membership_id )
INNER JOIN civicrm_contribution       con ON ( mp.contribution_id = con.id )
 LEFT JOIN civicrm_contribution_recur cr  ON ( mem.contribution_recur_id = cr.id )
 LEFT JOIN civicrm_contribution_page  cp  ON ( con.contribution_page_id  = cp.id )
     WHERE mp.membership_id = 421 LIMIT 1 [nativecode=1054 ** Unknown column 'cp.payment_processor' in 'field list']
    [type] => DB_Error
    [user_info] => 
    SELECT cr.payment_processor_id as ppID1, cp.payment_processor as ppID2, con.is_test
      FROM civicrm_membership mem
INNER JOIN civicrm_membership_payment mp  ON ( mem.id = mp.membership_id )
INNER JOIN civicrm_contribution       con ON ( mp.contribution_id = con.id )
 LEFT JOIN civicrm_contribution_recur cr  ON ( mem.contribution_recur_id = cr.id )
 LEFT JOIN civicrm_contribution_page  cp  ON ( con.contribution_page_id  = cp.id )
     WHERE mp.membership_id = 421 LIMIT 1 [nativecode=1054 ** Unknown column 'cp.payment_processor' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
    SELECT cr.payment_processor_id as ppID1, cp.payment_processor as ppID2, con.is_test
      FROM civicrm_membership mem
INNER JOIN civicrm_membership_payment mp  ON ( mem.id = mp.membership_id )
INNER JOIN civicrm_contribution       con ON ( mp.contribution_id = con.id )
 LEFT JOIN civicrm_contribution_recur cr  ON ( mem.contribution_recur_id = cr.id )
 LEFT JOIN civicrm_contribution_page  cp  ON ( con.contribution_page_id  = cp.id )
     WHERE mp.membership_id = 421 LIMIT 1 [nativecode=1054 ** Unknown column 'cp.payment_processor' in 'field list']"]
)



If I click on Administrator I have this.... but if I click on DB upgrade again I have tha white page

I go back to 4.1.6 and I try to 4.2.0. I'll let you know
thanks

I don't follow what you are asking, but what you can do is:

1. Export your data in your current site
2. Install a fresh CiviCRM 4.3.5
3. Import your data into the new CiviCRM install