I have run all settings from agents, accounts, teams, departments, help topics and the error persists
The department is the same for all help topics
It has shown me the following error:
[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)) asemail , 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)) asnotes 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]
Column 'user_id' cannot be null <br />
<br />
---- Backtrace ---- <br />
0 (root) /include/mysqli.php (200): osTicket-> logDBError ('DB Error # 1048', '[CREATE TABLE I ...') <br />
1 (root) /include/class.dynamic_forms.php (299): db_query ('CREATE TABLE IF ...') <br />
2 (root) /include/class.dynamic_forms.php (292): DynamicForm :: buildDynamicDataView (Array) <br />
3 (root) /include/ajax.users.php (84): DynamicForm :: ensureDynamicDataView () <br />
4 (root) /include/class.dispatcher.php (145): UsersAjaxAPI-> search ('local') <br />
5 (root) /include/class.dispatcher.php (38): UrlMatcher-> dispatch ('/ local', Array) <br />
6 (root) /include/class.dispatcher.php (120): Dispatcher-> resolve ('/ local', Array) <br />
7 (root) /include/class.dispatcher.php (38): UrlMatcher-> dispatch ('/ users / local', NULL) <br />
8 (root) /scp/ajax.php (308): Dispatcher-> resolve ('/ users / local') <br />
9 {main}
Thanks
