[$40] 'Watching' count doesn't tally with actual watch list

[sdgun]

Steps
Log in as sdguntcqa or adgunvfor users or from any user
Go to watching page
Check the number of watching categories and the actual count

'Watching' count doesn't tally with actual watch list
also for some users, it takes some time to update the count after first log in

[jmgasper]

Challenge https://www.topcoder.com/challenges/45c758f7-5f58-4d34-af71-1ed91b7ef3fa has been created for this ticket.

This is an automated message for ghostar via Topcoder X

[jmgasper]

Challenge https://www.topcoder.com/challenges/45c758f7-5f58-4d34-af71-1ed91b7ef3fa has been assigned to obog.

This is an automated message for ghostar via Topcoder X

[atelomycterus]

@sdgun

** User sdguntcqa**
Total count is equal to 5 (3 categories, 2 bookmarks). The user registered for a challenge (https://vanilla.topcoder-dev.com/group/185), bookmarked 2 discussions and unregistered from the challenge. User unregistered in 20 November. Count of Bookmarks is not correct. Count of Bookmarks should be 0.

We've fixed count of bookmarks after unregistering from challenges in 17 December (#299 (comment)).

Using REST API should fix the count of Bookmarks. (add sdguntcqa to the group and remove from the group). Let me know if you need help with that.

https://vanilla.topcoder-dev.com/discussion/1751/baze-my-discussion
https://vanilla.topcoder-dev.com/discussion/1753

** User sdgunvfor **
It looks like a bug. The new column was added and count of watched categories should be calculated after updating User table.
but the value is null for some users including sdgunvfor. I'll fix it.

Updated: I've checked sql query, no errors. I couldn't reproduce it locally.

@jmgasper Please apply PR-#531. Thanks. I'll verify it after deploying. Count of watched categories should be recalculated if the column value is null.

[atelomycterus]

@jmgasper Vanilla hasn't been started after deploying. I don't see any errors in logs:

2021-04-03 20:31:47,354 INFO stopped: apached (exit status 0)
[03-Apr-2021 20:31:47] NOTICE: Terminating ...
[03-Apr-2021 20:31:47] NOTICE: exiting, bye-bye!
2021-04-03 20:31:47,366 INFO stopped: php-fpmd (exit status 0)
2021-04-03 20:31:48,366 INFO waiting for syslogd to die
[SYSLOG] syslog-ng[43]: syslog-ng shutting down; version='3.13.2'
2021-04-03 20:31:48,468 INFO stopped: syslogd (exit status 0)

Please apply PR-#532. I commented a sql query. This query should be run before Vanilla bootstrap. I am not sure but it might cause an issue.

[jmgasper]

@atelomycterus - Deploying now

[jmgasper]

@atelomycterus - The deploy is done and the app is working agin.