# (Obsolete) Set category tracking level defaults historically

**URL:** https://meta.discourse.org/t/obsolete-set-category-tracking-level-defaults-historically/53165
**Category:** Self-Hosting
**Tags:** how-to
**Created:** [Novembre 21, 2016, 12:45 UTC](https://meta.discourse.org/t/obsolete-set-category-tracking-level-defaults-historically/53165 "2016-11-21T00:45:27Z")
**Posts on this page:** 1
**Showing post:** 50

<div class="post-metadata">

### Author: ![SouperC](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/souperc/32/62875_2.png) [@SouperC](https://meta.discourse.org/u/SouperC)
#### Post date: [Novembre 29, 2018, 9:24 UTC](https://meta.discourse.org/t/obsolete-set-category-tracking-level-defaults-historically/53165/50 "2018-11-29T21:24:57Z")

</div>

Actually… I’m stuck on the query. I need to update category ID 1 to notification level of regular (1).  
From rails… I’m typing

`User.exec_sql("INSERT INTO category_users(category_id, user_id, notification_level) SELECT 1, u.id, 1 FROM users u LEFT JOIN category_users cu ON cu.category_id = 1 AND cu.user_id = u.id WHERE cu.user_id IS NULL;")`

I get response

`<PG::Result:0x000055fadb534428 status=PGRES_COMMAND_OK ntuples=0 nfields=0 cmd_tuples=0>`

Via the GUI/forums, it looks like it hasn’t changed.

---

_[View the full topic](https://meta.discourse.org/t/obsolete-set-category-tracking-level-defaults-historically/53165)._