Comments - Incorrect integer value
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
''means you are setting priority to a string, not an integer. You should use NULL (without quotes) instead, or, to set it to the default 0, leave priority out of the query altogether.If you are unable to make these changes and can only make changes in MariaDB, not the code, then you have two options.
You can either change the column type to a string, though be aware that this may have consequences elsewhere in the code.
Alternatively, you can disable strict mode, which will accept the query as is, with a warning, and replace the string with the default, 0. Again, this change may have consequences elsewhere in the code.
Thank you