Skip to content

Category topic_count not incremented on SQL seed imports

Bulk SQL inserts skip the application layer, so nav badges drift.

Either a trigger or a nightly UPDATE categories SET topic_count = (SELECT count(*)).

5 replies

Please leave the permalink up. We have inbound links from status emails.

Permalink

Fix landed in v2.9.1. Cause was the list cache key using the raw query string type.

Permalink

Reproduced on staging. Logs match. Assigning to engineering.

Permalink

Thanks — leaving this up for the next team that searches the same string.

Permalink

Weekly winners

Investigating

Category topic_count not incremented on SQL seed imports

Bulk SQL inserts skip the application layer, so nav badges drift.

Either a trigger or a nightly UPDATE categories SET topic_count = (SELECT count(*)).

Replies 5

Alex Rivera
StaffRegular

@alex_eng

Please leave the permalink up. We have inbound links from status emails.

Elena Rostova
ModMember

@elena_support

Verified after deploy. Closing as fixed on our tenant.

Jordan Hale

@jordan_design

Fix landed in v2.9.1. Cause was the list cache key using the raw query string type.

Leo Mensah

@leo_ops

Reproduced on staging. Logs match. Assigning to engineering.

Alex Rivera
StaffRegular

@alex_eng

Thanks — leaving this up for the next team that searches the same string.

Join the conversation

Sign in or create an account to share your thoughts, solutions, or feedback.