already sent (animated) stickers won't be converted after lottieconverter is set up

[Matze1224]

As I've discovered there's a way to convert animated stickers instead of just getting a raw zipped json file after running the bridge for a longer time, stickers received in the pre-setup time won't be converted if there will be sent again in the post-setup time. This must be correlate with the reuse of already uploaded files (should be traced back to #40 - but no, I've run this bridge just since v0.9.x).

At least all new sent stickers should be converted and displayed correctly after setup.

How can this be handled at best? Clearing entries in the telegram_file database table while the bridge is down? Extra migration script to clear/convert such files in the Matrix Media Repo? Some detection in the code to reupload the converted sticker if there is an pre-setup uploaded sticker?

btw. it was really hard to find out there's a way for animated stickers if you compile LottieConverter and install it in your $PATH. No reference in the docs that you might need it.

[Hukadan]

I had a similar problem and ended up deleting the files with the mime_type set to 'application/gzip' from the telegram_file table. I am not sure this is the right way to handle the problem though.

[Matze1224]

I thought about this, too, because the only thing that would happen is that the bridge reuploads the deleted files again (at least how it sounds like) if it didn't just hit the old sticker files.

[Matze1224]

I've now did a DELETE FROM telegram_file WHERE mime_type = 'application/gzip'; in the postgres database, too. Stopped the bridge before out of safety concerns. Works now - sending already sent stickers are now shown correctly.

Would be good to still tackle the issue and get at least the LottieConverter setup and workaround documented.