environment:
osTicket Version v1.12.2 (a5d898b) — Up to date
Web Server Software Apache
MySQL Version 10.4.7
OS Centos 7.x
PHP Version 7.2.21
Step to reproduce:

  1. added custom sorting "Manage Queue Sorting" in the previous version, and now found out
  2. when edit, show error ini apache log

[Mon Aug 26 15:43:06.625580 2019] [php7:error] [pid 30111] [client 117.x.x.x:33004] PHP Fatal error: Uncaught Error: Call to a member function asTable() on null in /PATH/include/staff/templates/queue-sorting.tmpl.php:1\nStack trace:\n#0 /PATH/include/staff/templates/queue-sorting-edit.tmpl.php(30): include()\n#1 /PATH/include/ajax.search.php(271): include('/var/www/suppor...')\n#2 /PATH/include/class.dispatcher.php(145): SearchAjaxAPI->editSort('12')\n#3 /PATH/include/class.dispatcher.php(38): UrlMatcher->dispatch('/sort/edit/12', Array)\n#4 /PATH/include/class.dispatcher.php(120): Dispatcher->resolve('/sort/edit/12', Array)\n#5 /PATH/include/class.dispatcher.php(38): UrlMatcher->dispatch('search/sort/edi...', Array)\n#6 /PATH/include/class.dispatcher.php(120): Dispatcher->resolve('search/sort/edi...', Array)\n#7 /PATH/include/class.dispatcher.php(38): UrlMatcher->dispatch('/tickets/search...', NULL)\n#8 /PATH/scp/ajax.php(289): Dispatcher->resolve('/tickets/search...')\n#9 {main}\n thrown in /PATH/include/staff/templates/queue-sorting.tmpl.php on line 1, referer: https://support.domain.com/scp/queues.php?id=24

    ichtus added custom sorting "Manage Queue Sorting"

    Not sure what this means. You added a modification, or you configures Custom Queues?

    Is there a sql error being logged?

      ntozier configure customer sorting, and getting problem when editing,
      there no error in system Dashboard -> System Logs, if you mean, error above from apache logs

      fyi this table that contain in the database
      MariaDB [dbproject]> select * from db_queue_sort;
      +----+------+----------------------------------+----------------------------------------------+---------------------+
      | id | root | name | columns | updated |
      +----+------+----------------------------------+----------------------------------------------+---------------------+
      | 1 | NULL | Priority + Most Recently Updated | ["-cdata__priority","-lastupdate"] | 2019-03-22 18:55:47 |
      | 2 | NULL | Priority + Most Recently Created | ["-cdata__priority","-created"] | 2019-03-22 18:55:47 |
      | 3 | NULL | Priority + Due Date | ["-cdata__priority","-est_duedate"] | 2019-03-22 18:55:47 |
      | 4 | NULL | Deadline | ["-est_duedate"] | 2019-05-29 13:25:17 |
      | 5 | NULL | Closed Date | ["-closed"] | 2019-03-22 18:55:47 |
      | 6 | NULL | Create Date | ["-created"] | 2019-03-22 18:55:47 |
      | 7 | NULL | Last User Update | ["-lastupdate"] | 2019-05-29 13:23:10 |
      | 8 | T | Department & Due Date | ["-dept_id","-duedate"] | 2019-04-22 09:35:33 |
      | 9 | T | Department | ["dept_id"] | 2019-04-20 16:56:21 |
      | 10 | T | Deadline | ["duedate"] | 2019-05-26 18:20:31 |
      | 11 | T | Priorities | ["-cdata__priority"] | 2019-04-20 16:58:40 |
      | 12 | T | Status | ["status__id"] | 2019-04-20 17:07:42 |
      | 13 | T | Last User Update | ["-lastupdate"] | 2019-05-29 13:21:22 |
      | 14 | T | Create Date | ["-created"] | 2019-04-22 09:35:54 |
      | 15 | T | Last Agent Response | ["-thread__lastresponse"] | 2019-05-29 13:21:07 |
      | 16 | T | Priority + Recently Update | ["-cdata__priority","-lastupdate"] | 2019-05-28 00:22:08 |
      | 17 | T | Priority + Recently Created | ["-cdata__priority","-created"] | 2019-05-28 00:22:45 |
      | 18 | T | Priority + Recently Response | ["-cdata__priority","-thread__lastresponse"] | 2019-05-28 00:23:10 |
      +----+------+----------------------------------+----------------------------------------------+---------------------+
      18 rows in set (0.001 sec)

      Sorry but I do not know what "customer sorting" means. There is nothing like that in osTicket to my knowledge.

      Maybe some screen shots and steps to reproduce the error would be helpful.

      The table that you posted default looks like this (ignore id8)

        ntozier
        I mean, that in the queue sorting, I have been added custom sort, but checking now, this error also happening in all,
        shown blank window when we click config.
        Manage Queue Sorting->

        there is should shown menu to edit, but shown blank window

        You appear to be using a non standard 3rd party theme mod. Please remove it, and retest what you are trying to do.

          a blank white bar usually indicates that your webserver is not handling AJAX requests.

          Are you running SELinux perhaps?

            ntozier it should nothing todo with selinux,
            as in the apache error log show same in the first post, even in the osticket 1.12.2.

            Write a Reply...