We are testing for the company I work for to use osticket
in localhost everything is ok but in the host it does not show the content of the tables: tickets and system reports
Thank you
OST does not show list of open tickets and system reports
Your screen shot shows you in the Admin panel.
Tickets are displayed in the Agent Panel -> Tickets
No, tickets do not show in any panel
Configure everything on the host once again because I could not solve the error, if the problem still persists I will have to consult again
Thank you
Then perhaps your account does not have access to the department that tickets are being created in.
14 days later
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
Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.
Environment details? (see Admin panel -> Dashboard -> Information)