MySQL Forums :: Views :: Cannot update a View

Your view cannot be updated. Have a look at this article - Updatable and Insertable Views

Also, I'd suggest you to rewrite your query. Something like this -

SELECT t1.* FROM
  jos_community_fields_values_copy t1
JOIN (SELECT
        User_ID
      FROM
        jos_community_fields_values_copy
      WHERE
        field_id = '4'AND Value = 'UK'
        OR
        field_id = '5'AND Value = 'Active') t2
ON t1.User_ID = t2.User_ID;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/