Inconsistent order of comments #333

Closed
opened 2026-02-04 18:34:14 +03:00 by OVERLORD · 1 comment
Owner

Originally created by @christophenne on GitHub (Jun 12, 2023).

Hi,

I have noticed weird behavior that suddenly appeared for the first time, after using planka for months: So far, when I added a comment to a card, it appears at the top (i.e. it is the new first comment). But since not too long ago, the new comments appear at the very bottom as the last comment.

I investigated a little bit, and the cause could be, that the postgresql counter for the database IDs has exceeded the value of 10^18. Looking into the websocket via the dev console, I found that the incoming response has the comments in the correct order, in my case:

image

It is correctly sorted by createdAt descending.

On the UI however, the very last comment (with ID "100...") is put the very bottom, and this seems to happen at all cards with all new comments since my counter has exceeded this value. Maybe the UI component sorts the comments by id descending, but interprets the id as a string - which would make the id starting with "1" the last item - just a wild guess for now.

Originally created by @christophenne on GitHub (Jun 12, 2023). Hi, I have noticed weird behavior that suddenly appeared for the first time, after using planka for months: So far, when I added a comment to a card, it appears at the top (i.e. it is the new first comment). But since not too long ago, the new comments appear at the very bottom as the last comment. I investigated a little bit, and the cause could be, that the postgresql counter for the database IDs has exceeded the value of 10^18. Looking into the websocket via the dev console, I found that the incoming response has the comments in the correct order, in my case: ![image](https://github.com/plankanban/planka/assets/7556574/2e7a46a6-664c-4727-8e87-97c6fc38d444) It is correctly sorted by createdAt descending. On the UI however, the very last comment (with ID "100...") is put the very bottom, and this seems to happen at all cards with all new comments since my counter has exceeded this value. Maybe the UI component sorts the comments by id descending, but interprets the id as a string - which would make the id starting with "1" the last item - just a wild guess for now.
OVERLORD added the bug label 2026-02-04 18:34:14 +03:00
Author
Owner

@meltyshev commented on GitHub (Jun 12, 2023):

Thanks for reporting this! You are absolutely right 🙈 I'll try to fix it right now. It should happen to all users today, since the id counter is date dependent.

@meltyshev commented on GitHub (Jun 12, 2023): Thanks for reporting this! You are absolutely right 🙈 I'll try to fix it right now. It should happen to all users today, since the id counter is date dependent.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/planka#333