Unsuccessfully
[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.<br />
<br />
---- Backtrace ----<br />
#0 (raiz)/include/mysqli.php(199): osTicket->logDBError('DB Error #1786', '[CREATE TABLE I...')<br />
#1 (raiz)/include/class.dynamic_forms.php(293): db_query('CREATE TABLE IF...')<br />
#2 (raiz)/include/class.dynamic_forms.php(286): DynamicForm::buildDynamicDataView(Array)<br />
#3 (raiz)/include/staff/users.inc.php(5): DynamicForm::ensureDynamicDataView()<br />
#4 (raiz)/scp/users.php(197): require('/var/www/html/o...')<br />
#5 {main}