I have a Magento 2.4.6 store, it's just a single store, not a multistore
Therefore there's no store view scope on things like products and categories.
If I go into the admin and change the category description, it saves fine in the admin however it doesn't appear on the frontend.
I've gone into the database and into the table catalog_category_entity_text
When I look at that table there are two entries one for store_id 0 and one for store_id 1
If I update the value for store_id 1 then my changes made in the admin show on the frontend.
Any idea why it's behaving like this? It feels like I need to remove one of the values but I'm not sure which?