Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.1.0
-
Fix Version/s: 4.1.0
-
Component/s: CiviContribute, CiviEvent
-
Labels:None
Description
After doing multilingual upgrade to 4.1.0 ,when try to create the contribution page or event page with pcp option it gives DB Error.
DB Error: no such table
Database Error Code: Table 'drupal622_civicrm.civicrm_pcp_block_en_US' doesn't exist, 1146
Additional Details: Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -18 [message] => DB Error: no such table [mode] => 16 [debug_info] => SELECT civicrm_contribution_page_en_US.id as id, civicrm_contribution_page_en_US.contribution_type_id as settings, amount_block_is_active as amount, civicrm_membership_block_en_US.id as membership, civicrm_uf_join.id as custom, civicrm_contribution_page_en_US.thankyou_title as thankyou, civicrm_tell_friend_en_US.id as friend, civicrm_pcp_block_en_US.id as pcp, civicrm_contribution_widget.id as widget, civicrm_premiums_en_US.id as premium FROM civicrm_contribution_page_en_US LEFT JOIN civicrm_membership_block_en_US ON ( civicrm_membership_block_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_membership_block_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_membership_block_en_US.is_active = 1 ) LEFT JOIN civicrm_uf_join ON ( civicrm_uf_join.entity_id = civicrm_contribution_page_en_US.id AND civicrm_uf_join.entity_table = 'civicrm_contribution_page' AND module = 'CiviContribute' AND civicrm_uf_join.is_active = 1 ) LEFT JOIN civicrm_tell_friend_en_US ON ( civicrm_tell_friend_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_tell_friend_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_tell_friend_en_US.is_active = 1) LEFT JOIN civicrm_pcp_block_en_US ON ( civicrm_pcp_block_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_pcp_block_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_pcp_block_en_US.is_active = 1 ) LEFT JOIN civicrm_contribution_widget ON ( civicrm_contribution_widget.contribution_page_id = civicrm_contribution_page_en_US.id AND civicrm_contribution_widget.is_active = 1 ) LEFT JOIN civicrm_premiums_en_US ON ( civicrm_premiums_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_premiums_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_premiums_en_US.premiums_active = 1 ) WHERE civicrm_contribution_page_en_US.id IN ( 4 ) [nativecode=1146 ** Table 'drupal622_civicrm.civicrm_pcp_block_en_US' doesn't exist] [type] => DB_Error [user_info] => SELECT civicrm_contribution_page_en_US.id as id, civicrm_contribution_page_en_US.contribution_type_id as settings, amount_block_is_active as amount, civicrm_membership_block_en_US.id as membership, civicrm_uf_join.id as custom, civicrm_contribution_page_en_US.thankyou_title as thankyou, civicrm_tell_friend_en_US.id as friend, civicrm_pcp_block_en_US.id as pcp, civicrm_contribution_widget.id as widget, civicrm_premiums_en_US.id as premium FROM civicrm_contribution_page_en_US LEFT JOIN civicrm_membership_block_en_US ON ( civicrm_membership_block_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_membership_block_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_membership_block_en_US.is_active = 1 ) LEFT JOIN civicrm_uf_join ON ( civicrm_uf_join.entity_id = civicrm_contribution_page_en_US.id AND civicrm_uf_join.entity_table = 'civicrm_contribution_page' AND module = 'CiviContribute' AND civicrm_uf_join.is_active = 1 ) LEFT JOIN civicrm_tell_friend_en_US ON ( civicrm_tell_friend_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_tell_friend_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_tell_friend_en_US.is_active = 1) LEFT JOIN civicrm_pcp_block_en_US ON ( civicrm_pcp_block_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_pcp_block_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_pcp_block_en_US.is_active = 1 ) LEFT JOIN civicrm_contribution_widget ON ( civicrm_contribution_widget.contribution_page_id = civicrm_contribution_page_en_US.id AND civicrm_contribution_widget.is_active = 1 ) LEFT JOIN civicrm_premiums_en_US ON ( civicrm_premiums_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_premiums_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_premiums_en_US.premiums_active = 1 ) WHERE civicrm_contribution_page_en_US.id IN ( 4 ) [nativecode=1146 ** Table 'drupal622_civicrm.civicrm_pcp_block_en_US' doesn't exist] [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT civicrm_contribution_page_en_US.id as id, civicrm_contribution_page_en_US.contribution_type_id as settings, amount_block_is_active as amount, civicrm_membership_block_en_US.id as membership, civicrm_uf_join.id as custom, civicrm_contribution_page_en_US.thankyou_title as thankyou, civicrm_tell_friend_en_US.id as friend, civicrm_pcp_block_en_US.id as pcp, civicrm_contribution_widget.id as widget, civicrm_premiums_en_US.id as premium FROM civicrm_contribution_page_en_US LEFT JOIN civicrm_membership_block_en_US ON ( civicrm_membership_block_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_membership_block_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_membership_block_en_US.is_active = 1 ) LEFT JOIN civicrm_uf_join ON ( civicrm_uf_join.entity_id = civicrm_contribution_page_en_US.id AND civicrm_uf_join.entity_table = 'civicrm_contribution_page' AND module = 'CiviContribute' AND civicrm_uf_join.is_active = 1 ) LEFT JOIN civicrm_tell_friend_en_US ON ( civicrm_tell_friend_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_tell_friend_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_tell_friend_en_US.is_active = 1) LEFT JOIN civicrm_pcp_block_en_US ON ( civicrm_pcp_block_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_pcp_block_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_pcp_block_en_US.is_active = 1 ) LEFT JOIN civicrm_contribution_widget ON ( civicrm_contribution_widget.contribution_page_id = civicrm_contribution_page_en_US.id AND civicrm_contribution_widget.is_active = 1 ) LEFT JOIN civicrm_premiums_en_US ON ( civicrm_premiums_en_US.entity_id = civicrm_contribution_page_en_US.id AND civicrm_premiums_en_US.entity_table = 'civicrm_contribution_page' AND civicrm_premiums_en_US.premiums_active = 1 ) WHERE civicrm_contribution_page_en_US.id IN ( 4 ) [nativecode=1146 ** Table 'drupal622_civicrm.civicrm_pcp_block_en_US' doesn't exist]"] )