Error! Writing values of 'System.UInt16' is not supported for parameters having no NpgsqlDbType or DataTypeName. Try setting one of these values to the expected database type..

[PeterKnotek]

App: QueryLogsPostgreSqlApp v1.0
Database: PostgreSQL 17.9
Issue: Filtering DNS logs by Type, RCODE, Protocol, or Class fails

DESCRIPTION:

1. Writing DNS logs to PostgreSQL: ✅ WORKS
2. Reading all logs without filter: ✅ WORKS
3. Filtering logs by Type A, RCODE, etc: ❌ FAILS

ERROR MESSAGE:
"Error! Writing values of 'System.UInt16' is not supported for parameters
having no NpgsqlDbType or DataTypeName. Try setting one of these values
to the expected database type."

ROOT CAUSE:
When filtering logs via Web UI, the app converts filter values to SQL
parameters but does not properly set NpgsqlDbType on the parameters.
The PostgreSQL driver cannot determine the parameter type (UInt16 vs Integer)
and throws an error.

EXPECTED:
Parameters should be mapped with NpgsqlDbType.Integer to ensure proper
type conversion for PostgreSQL.

STEPS TO REPRODUCE:

1. Configure QueryLogsPostgreSqlApp with PostgreSQL
2. Logs are written and visible
3. Click filter "Type" and select "A"
4. Click "Query"
5. Error appears

Have last updates 15.1 - TechnitiumDNS 1.1 - PostgreSQL) Thanks

[ShreyasZare]

Thanks for the feedback. I have just now updated the app to fix the issue. Do update the app to v1.2 and let me know your feedback.

[PeterKnotek]

Thank you very very very very much
You are the best 👍️👍️👍️👍️👍️👍️👍️👍️👍️👍️👍️👍️👍️👍️
It works !!!!!

[ShreyasZare]

Thanks for the feedback!