Today, I found a bug on the my website
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
My website is where users can add their poems and share them with the world....
The problem is that when a user likes a poem, the age restriction set by the author when adding the poem is removed.
Here are the technical details: there is an "update" event that triggers when an author edits a poem. During this event, the system deletes the old age restrictions and adds new ones if they were changed. However, there's an issue: the ratings for poems are stored in the same table as the poems. When a user likes or dislikes a poem, the rating field is updated (+1 or -1). The system treats this as an "update" and triggers the event. As a result, the age restrictions for the poem are removed, even though they were not changed.
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
136
1 min 36 sec read
The conversation doesn't have to end here! Feel free to leave a comment below and rate this post — your
feedback really helps me improve the blog and make it more interesting for you. You can also find me
on Telegram, where I've got a
channel,
a group
where we can chat and discuss all sorts of things, and even a
bot
to check out. Feel free to drop by and say hello!
Comments (0)
0 comments
·
0 replies
Newest first
-
Newest first
-
Oldest first
No comments yet
Be the first to share a thought — your note can help the next reader.