Problems when trying to insert an image in wysiwyg editor (Firefox)
Inserting an image into the editor works in Chrome but not in Firefox. Sometimes it fails silently, but sometimes you get the following error:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_date_and_time0.nid' in 'where clause': SELECT field_data_field_date_and_time0.entity_type AS entity_type, field_data_field_date_and_time0.entity_id AS entity_id, field_data_field_date_and_time0.revision_id AS revision_id, field_data_field_date_and_time0.bundle AS bundle FROM {field_data_field_date_and_time} field_data_field_date_and_time0 WHERE (field_data_field_date_and_time0.deleted = :db_condition_placeholder_0) AND (field_data_field_date_and_time0.entity_type = :db_condition_placeholder_1) AND (field_data_field_date_and_time0.bundle IN (:db_condition_placeholder_2)) AND(( ( EXISTS (SELECT na.nid AS nid FROM {node_access} na WHERE (( (na.gid = :db_condition_placeholder_3) AND (na.realm = :db_condition_placeholder_4) )OR( (na.gid = :db_condition_placeholder_5) AND (na.realm = :db_condition_placeholder_6) )OR( (na.gid = :db_condition_placeholder_7) AND (na.realm = :db_condition_placeholder_8) ))AND (na.grant_view >= :db_condition_placeholder_9) AND (field_data_field_date_and_time0.entity_id = na.nid) )) AND (field_data_field_date_and_time0.entity_type = :db_condition_placeholder_10) )OR (field_data_field_date_and_time0.entity_type <> :db_condition_placeholder_11) )AND ( EXISTS (SELECT na.nid AS nid FROM {node_access} na WHERE (( (na.gid = :db_condition_placeholder_12) AND (na.realm = :db_condition_placeholder_13) )OR( (na.gid = :db_condition_placeholder_14) AND (na.realm = :db_condition_placeholder_15) )OR( (na.gid = :db_condition_placeholder_16) AND (na.realm = :db_condition_placeholder_17) ))AND (na.grant_view >= :db_condition_placeholder_18) AND (field_data_field_date_and_time0.nid = na.nid) )) ORDER BY field_data_field_date_and_time0.field_date_and_time_value DESC; Array ( [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => node [:db_condition_placeholder_2] => event [:db_condition_placeholder_3] => 0 [:db_condition_placeholder_4] => all [:db_condition_placeholder_5] => 50 [:db_condition_placeholder_6] => view_unpublished_author [:db_condition_placeholder_7] => 1 [:db_condition_placeholder_8] => view_unpublished_content [:db_condition_placeholder_9] => 1 [:db_condition_placeholder_10] => node [:db_condition_placeholder_11] => node [:db_condition_placeholder_12] => 0 [:db_condition_placeholder_13] => all [:db_condition_placeholder_14] => 50 [:db_condition_placeholder_15] => view_unpublished_author [:db_condition_placeholder_16] => 1 [:db_condition_placeholder_17] => view_unpublished_content [:db_condition_placeholder_18] => 1 ) in field_sql_storage_field_storage_query() (line 652 of /home/ruby/public_html/spd/modules/field/modules/field_sql_storage/field_sql_storage.module)
Comments
Just tested this with this issue and it worked. I upgraded CKeditor to fix the issue about missing alignment buttons (which was a missing plugin issue) and it seems to have fixed this problem also.
Add new comment