ERROR: activity_common/vote.go:60 pq: invalid input syntax for type bigint: ""

[brocaar]

Describe the bug

In the logs, this error is occurring many times:

activity_common/vote.go:60      pq: invalid input syntax for type bigint: ""

To Reproduce

I'm not sure what activity triggers this error, but in the log history of the answer process, I see this error occurring many times.

Platform

• Linux (AMD64)
• Version 1.7.1 (built with plugins)
• PostgreSQL v17.7

[brocaar]

@LinkinStars do you have an idea why this is happening? This is a very regular error message I see in the logs.

[LinkinStars]

@LinkinStars do you have an idea why this is happening? This is a very regular error message I see in the logs.

@brocaar Thank you for feedback. This issue occurs when accessing comments while not logged in. Due to differences in how MySQL and PostgreSQL handle data, MySQL automatically removes empty strings while PostgreSQL does not, resulting in this error. We will fix this issue in the next version.