Usernames issue (not updating on import causing duplicated userID entries)

[eiger8]

Hello @mkdryden

After importing the chat history the usernames are not updated by UserID accordingly, causing the stats to show not correctly (i.e. with empty fields).

When the user appears in chat, and writes some messages the username gets updated (by UserID), but this action is leading to user record duplication

Here is stdout in container when running /stats corr

[mkdryden]

So it is totally normal to have multiple entries in the user_names table for a given user id, as it keeps track of historical display names. When mapping user ids to display names when doing stats, it is supposed to take the most recent one.

The error at the bottom is because the dataframe has duplicate indices. I will have to investigate closer and see what the index is supposed to be there, but I don't seem to be able to reproduce this issue with freshly dumped chat logs on my end.

[eiger8]

What data or any other help do you need from me to investigate the issue?

[mkdryden]

A database dump would probably be the most helpful, if you can make one that reproduces this issue. Knowing how your server is running would be good to know as well, particularly the install method (source using poetry, pip, docker).

[eiger8]

A database dump would probably be the most helpful, if you can make one that reproduces this issue. Knowing how your server is running would be good to know as well, particularly the install method (source using poetry, pip, docker).

I am running bot in docker. Config is almost like default one in repo but has persistant volumes for DB and bot (for importing, experiments). Chat is private so full DB dump will not be possible.