In this post, you’ll learn more about the MariaDB Error 1766 ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1766 – ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION with the sqlState HY000
Error Description for the MariaDB Error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
The system variable %s cannot be set when there is an ongoing transaction.