Thread header-message deletion time is being updated when a sub-message is deleted as well

criscmaia / gsdslack

GSD Slack

https://sciencegsd.slack.com/messages

0 stars 0 forks source link

Thread header-message deletion time is being updated when a sub-message is deleted as well #7

Closed criscmaia closed 7 years ago

btmatthew commented 7 years ago

"UPDATE channelMessages AS t1 INNER JOIN (" + "SELECT userTimezoneOffset FROM channelMessages WHERE slackMessageId = ? LIMIT 1)" + " AS t2 SET t1.deletedLocaltime = DATE_ADD(UTC_TIMESTAMP(), INTERVAL (3600 * t2.userTimezoneOffset) SECOND)" + " WHERE slackMessageId = ?;"

check your sql query it is the only thing that could be wrong.

btmatthew commented 7 years ago

nvm Slack was being funny again and kept on sending multiple delete requests. Fixed that can you test that?

criscmaia commented 7 years ago

Fixed