edit: How could i use Views bulk operations for the change of a field's value? Instead of directly editing mysql? I have a content type, f.e mycontentype, which has titles, like:

Title - library1
another title - library1
yet another title - library1

so i went in the db and with a MySQL command, i updated all titles to

another title
yet another title

My issue here is that in a view, i have as a field, the

Content: mycontenttype

which i have set to the formatter as title link.

This brinks as the title the old title Title - library1, but when this link is clicked, we go the the node where the title is shown correctly.

if in the formatter i choose full content, i get again all data updated, including the correct title.

Of course i have cleared all caches, i have run update.php,

any ideas?

  • 2
    For one, its not good to edit the database directly. There are plenty of triggers that happen when you save an entity in the UI/code through the framework. Two, it could be cached by that view or you did not edit any possible revision table as well. The view result could also be cached. – Kevin Sep 17 '19 at 13:44
  • how could i remove all cached content from the views? "Two, it could be cached by that view" and "The view result could also be cached"? i used the TRUNCATE with all cache named tables, but i get no different behavior.. i am afraid i have to work on mysql directly, since i need to remove a field's data that was inserted wrong, in a batch process. f.e. i have many nodes, which have a certain value in a field, and i must set this value to none, for all nodes that have the same error value... – S. L. Sep 17 '19 at 14:34
  • Did u edit the node to check that the field value did indeed change? – No Sssweat Sep 17 '19 at 15:57
  • Yes, as per @Kevin's comment look at the revision table as well. – Alfred Armstrong Sep 18 '19 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.