I'm setting up a website using Craft Cms.
Everything was working fine on local dev, but now I moved it to a development server, I'm getting an error every time I try to create a new entry (or section).
When devMode == false I get:
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.. The SQL statement executed was: INSERT INTO
craft_searchindex
(elementId
,attribute
,fieldId
,locale
,keywords
) VALUES (:elementId, :attribute, :fieldId, :locale, :keywords) ON DUPLICATE KEY UPDATEkeywords
= :keywords. Bound with :elementId='61', :attribute='field', :fieldId='1', :locale='en', :keywords=''