Please can someone tell me where I can find and set the parameter values (like "Title show")  for categories in the database?

In particular I want to reset the values and set to inherit them from an other category.

in jos_k2_categories.params I can't find them

p.s. I asked the same question in discussion community.getk2.org/forum/topics/reset-default-category

 

Create a new category with default settings

using phpmyadmin go to the category table and copy the text from the newly created category.params field

past it into the params field of the category you want to change.

goto the back end and set it to inherit from where you want it to....

thanks for the quick reply

the problem was (I paste a previous post):

"Inheritance only affects Joomla! frontend layout, not the parameters of the category that inherits."
 

and for updating I've used this:

UPDATE jos_k2_categories AS target LEFT JOIN jos_k2_categories AS source ON source.id = 3      SET target.params = source.params    WHERE target.id = 109;