Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-9675

DB Error for civicrm_pcp_block when creating contribution page after multilingual upgrade.

    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]"] )

        Attachments

          Activity

            People

            • Assignee:
              rohan Rohan S. Chavan
              Reporter:
              rohan Rohan S. Chavan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: