Hello, I am getting the following error every minute:
DB Error #1786
[CREATE TABLE IF NOT EXISTS ost_user__cdata (PRIMARY KEY (user_id)) DEFAULT CHARSET=utf8 AS SELECT entry.object_id as user_id, MAX(IF(field.id='1', coalesce(ans.value_id, ans.value), NULL)) as email, MAX(IF(field.id='2', coalesce(ans.value_id, ans.value), NULL)) as name, MAX(IF(field.id='3', coalesce(ans.value_id, ans.value), NULL)) as phone, MAX(IF(field.id='4', coalesce(ans.value_id, ans.value), NULL)) as notes FROM ost_form_entry entry JOIN ost_form_entry_values ans ON ans.entry_id = entry.id JOIN ost_form_field field ON field.id=ans.field_id WHERE entry.object_type='U' GROUP BY entry.object_id] Statement violates GTID consistency: CREATE TABLE ... SELECT.
---- Backtrace ----
#0 (root)/include/mysqli.php(200): osTicket->logDBError()
#1 (root)/include/class.dynamic_forms.php(299): db_query()
#2 (root)/include/class.dynamic_forms.php(292): DynamicForm::buildDynamicDataView()
#3 (root)/include/staff/users.inc.php(5): DynamicForm::ensureDynamicDataView()
#4 (root)/scp/users.php(212): require('/var/www/html/o...')
#5 {main}
My setup is this:
Any help would be really appreciated. Thanks.
