Good afternoon,

Began encountering an error while attempting to manually sort helpdesk topics. Receiving HTTP Error 500 when attempting to save.
Apache log states:
[Mon Jun 06 20:23:40.253350 2022] [php:error] [pid 2821] [client 10.33.1.186:21500] PHP Fatal error: Uncaught TypeError: array_intersect(): Argument #1 ($array) must be of type array, null given in /var/www/html/scp/helptopics.php:68\nStack trace:\n#0 /var/www/html/scp/helptopics.php(68): array_intersect()\n#1 {main}\n thrown in /var/www/html/scp/helptopics.php on line 68, referer: http://helpdesk.[domainredact].org/scp/helptopics.php

I had just deleted a HelpTopic and custom form so I'm not sure if the problem is correlated. When I attempt to delete a list that was attached to the custom form I receive an error that it may still be in use?

System:
osTicket: v1.16.3 (e148727)
Ubuntu 20.04.4 LTS
Apache/2.4.41
MySQL Version 10.3.34
PHP Version 8.0.19

I have tried restarting the server and apache.

Any ideas appreciated.

Can you please check your SQL error logs and see if there also an error there.

Checked the logs at /var/log/mysql/error.log and error.log.1 and both were blank

Checked Config file at /etc/mysql/mariadb.conf.d/50-server.cnf and the error log line was already uncommented to /var/log/mysql/error.log

The MariaDB log_error global variable is also set to /var/log/mysql/error.log

Ubuntu MariaDB Log Guide

Thanks,
Andrew

7 days later

Just wanted to add that I'm able to run an update query on the sort field without error as far as I can tell and the change is reflected on the web, but still receive the 500 error when trying to sort from the webpage.

Sort number 4 is missing, assuming that was the helptopic I deleted.

I have the same issue, deleted one of the default topics, added 4 new ones, changed to manually and got the 500 error.

Temporarily fixed by manually editing line 240 of include/class.config.php

Original: 'help_topic_sort_mode' => 'a',
Edit: 'help_topic_sort_mode' => 'm',

UPDATE: the previously mentioned change gets lost if you do any edits the help topics in the GUI so it needs to be re applied.

Temporarily fixed by manually editing line 240 of include/class.config.php
Original: 'help_topic_sort_mode' => 'a',
Edit: 'help_topic_sort_mode' => 'm',

cheers

a month later
Write a Reply...