After the upgrade April 4 I get an error on the active of deleting a contact:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_activity_participants1.field_activity_participants_target_type' in 'where clause': SELECT DISTINCT field_data_field_activity_participants0.entity_type AS entity_type, field_data_field_activity_participants0.entity_id AS entity_id, field_data_field_activity_participants0.revision_id AS revision_id, field_data_field_activity_participants0.bundle AS bundle FROM {field_data_field_activity_participants} field_data_field_activity_participants0 INNER JOIN {field_data_field_activity_participants} field_data_field_activity_participants1 ON field_data_field_activity_participants1.entity_type = field_data_field_activity_participants0.entity_type AND field_data_field_activity_participants1.entity_id = field_data_field_activity_participants0.entity_id WHERE (field_data_field_activity_participants0.field_activity_participants_target_id = :db_condition_placeholder_0) AND (field_data_field_activity_participants1.field_activity_participants_target_type = :db_condition_placeholder_1) AND (field_data_field_activity_participants0.deleted = :db_condition_placeholder_2) AND (field_data_field_activity_participants0.entity_type = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => crm_core_contact [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => crm_core_activity ) в функции field_sql_storage_field_storage_query() (строка 577 в файле C:\Users\User\Sites\____\modules\field\modules\field_sql_storage\field_sql_storage.module).
| Comment | File | Size | Author |
|---|---|---|---|
| #6 | contactdeletefix-1516068-6.patch | 2.82 KB | dpovshed |
| #5 | contactdeletefix-1516068-5.patch | 3.06 KB | dpovshed |
| #4 | contactdeletefix-1516068-4.patch | 3.37 KB | dpovshed |
Comments
Comment #0.0
LexusIrus commentedPDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_activity_participants1.field_activity_participants_target_type' in 'where clause': SELECT DISTINCT field_data_field_activity_participants0.entity_type AS entity_type, field_data_field_activity_participants0.entity_id AS entity_id, field_data_field_activity_participants0.revision_id AS revision_id, field_data_field_activity_participants0.bundle AS bundle FROM {field_data_field_activity_participants} field_data_field_activity_participants0 INNER JOIN {field_data_field_activity_participants} field_data_field_activity_participants1 ON field_data_field_activity_participants1.entity_type = field_data_field_activity_participants0.entity_type AND field_data_field_activity_participants1.entity_id = field_data_field_activity_participants0.entity_id WHERE (field_data_field_activity_participants0.field_activity_participants_target_id = :db_condition_placeholder_0) AND (field_data_field_activity_participants1.field_activity_participants_target_type = :db_condition_placeholder_1) AND (field_data_field_activity_participants0.deleted = :db_condition_placeholder_2) AND (field_data_field_activity_participants0.entity_type = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => crm_core_contact [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => crm_core_activity ) в функции field_sql_storage_field_storage_query() (строка 577 в файле C:\Users\User\Sites\____\modules\field\modules\field_sql_storage\field_sql_storage.module).
Comment #1
dealancer commentedConfirm issue exists.
Comment #2
dealancer commentedComment #3
dpovshed commentedWork in progress, stay tuned!
Comment #4
dpovshed commentedThe root of the problem was in incorrect handling Activities/Contact link.
Please review the attached patch. It should allow update main participants list or gracefully delete Activites when the only involved contact removed.
Comment #5
dpovshed commentedPlease check the renewed version attached!
Comment #6
dpovshed commentedRecreated patch to reflect current dev version
Comment #7
dealancer commentedGreat! Thanks!
Comment #8.0
(not verified) commentedPDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_activity_participants1.field_activity_participants_target_type' in 'where clause': SELECT DISTINCT field_data_field_activity_participants0.entity_type AS entity_type, field_data_field_activity_participants0.entity_id AS entity_id, field_data_field_activity_participants0.revision_id AS revision_id, field_data_field_activity_participants0.bundle AS bundle FROM {field_data_field_activity_participants} field_data_field_activity_participants0 INNER JOIN {field_data_field_activity_participants} field_data_field_activity_participants1 ON field_data_field_activity_participants1.entity_type = field_data_field_activity_participants0.entity_type AND field_data_field_activity_participants1.entity_id = field_data_field_activity_participants0.entity_id WHERE (field_data_field_activity_participants0.field_activity_participants_target_id = :db_condition_placeholder_0) AND (field_data_field_activity_participants1.field_activity_participants_target_type = :db_condition_placeholder_1) AND (field_data_field_activity_participants0.deleted = :db_condition_placeholder_2) AND (field_data_field_activity_participants0.entity_type = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => crm_core_contact [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => crm_core_activity ) в функции field_sql_storage_field_storage_query() (строка 577 в файле C:\Users\User\Sites\____\modules\field\modules\field_sql_storage\field_sql_storage.module).