Friction

Workaround · Integrations · Blocks work

Disable prepared statements to run multi-statement queries

1 source thread · first seen 2026-10

Every GitHub thread behind this item is closed (latest 2026-10). The problem may be fixed in current versions; check the source threads below before relying on it.

Summary

Turning off prepared statements avoids the reported syntax error, but the author says this is not viable for dozens of queries because it requires manual quoting and removes SQL injection protection.

Affects
Self-hosted users with MySQL or MariaDB datasources
Workaround
Turn off Use Prepared Statement, though the author says this is not viable for dozens of queries.

Evidence

Excerpts are copied word for word from the source; follow the link to read it in full.

“With "Use Prepared Statement" OFF, the syntax error disappears”

Report this item