Support

Akeeba Ticket System

#39265 Private or Public / shutdown Subject search results

Posted in ‘Akeeba Ticket System for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
4.3.3
PHP version
8.x
Akeeba Ticket System version
5.2.8

Latest post by tampe125 on Friday, 28 July 2023 02:39 CDT

FrankVo

Hi Nicholas,

1.
have set default ticket status to 'Prívate' but all tickets come in my emailbox as 'Public' and I have to set it mannualy to 'Private' in admin.
I cannot find how to set it standard to always 'Private'.
I have set it at all places I could find as 'Private', but still......in admin it is 'Public' and in mailbox it comes as 'Public'. 

2.
How can I remove the automatically search function when I fill the 'Title' field ?

Thanx in advance.

 

tampe125
Akeeba Staff

Hello,

1. On category settings, please enable the option "Auto-select Private" . By the way, can you please double check that the user you're using to create tickets has the permission to create private tickets?

2. If you want to disable it globally, please get inside component options, InstaSearch tab and set the field "InstantSearch method" to None.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

FrankVo

Okay, Thanx

Next issue is when I want to change the sorting of tickets to 'Status Acending/Descending' (at ATS/Tickets in admin) I get a fatal PhP error. As below:

...........................................................................................................................................................................................................................................................................

Akeeba Ticket System - An unhandled Exception has been detected 500 Unknown column 't.state' in 'order clause'

File <root>/administrator/components/com_ats/src/View/Tickets/HtmlView.php Line 94

 The content below this point is for developers and power users.

Joomla 4.3.3 – PHP 8.0.27 on Linux

Debug information

Exception type: Joomla\CMS\MVC\View\GenericDataException

#0 /home/supportdesk/domains/supportdesk4all.nl/public_html/libraries/src/MVC/Controller/BaseController.php(645): Akeeba\Component\ATS\Administrator\View\Tickets\HtmlView->display()
#1 /home/supportdesk/domains/supportdesk4all.nl/public_html/administrator/components/com_ats/src/Mixin/ControllerEventsTrait.php(74): Joomla\CMS\MVC\Controller\BaseController->display()
#2 /home/supportdesk/domains/supportdesk4all.nl/public_html/libraries/src/Dispatcher/ComponentDispatcher.php(143): Akeeba\Component\ATS\Administrator\Controller\TicketsController->execute()
#3 /home/supportdesk/domains/supportdesk4all.nl/public_html/administrator/components/com_ats/src/Dispatcher/Dispatcher.php(74): Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()
#4 /home/supportdesk/domains/supportdesk4all.nl/public_html/libraries/src/Component/ComponentHelper.php(361): Akeeba\Component\ATS\Administrator\Dispatcher\Dispatcher->dispatch()
#5 /home/supportdesk/domains/supportdesk4all.nl/public_html/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent()
#6 /home/supportdesk/domains/supportdesk4all.nl/public_html/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch()
#7 /home/supportdesk/domains/supportdesk4all.nl/public_html/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\AdministratorApplication->doExecute()
#8 /home/supportdesk/domains/supportdesk4all.nl/public_html/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#9 /home/supportdesk/domains/supportdesk4all.nl/public_html/administrator/index.php(32): require_once('/home/supportde...')
#10 {main}
System information
Operating System (reported by PHP) Linux
PHP version (as reported by your server) 8.0.27
PHP Built On Linux web0151.zxcs.nl 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64
PHP SAPI litespeed
Server identity Apache/2
Browser identity Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36
Joomla! version 4.3.3
Database driver name mysqli
Database driver type mysql
Database server version 10.4.27-MariaDB-cll-lve
Database collation latin1_swedish_ci
Database connection collation utf8mb4_general_ci
PHP Memory limit 2048M
Peak Memory usage 17.97M
PHP Timeout (seconds) 300
Request information $_GET
Array
(
    [option] => com_ats
    [view] => tickets
)
$_POST
Array
(
    [filter] => Array
        (
            [search] => 
            [user] => 
            [assigned_to] => 
            [status] => 
            [public] => 
            [enabled] => 
            [since] => 
            [to] => 
        )

    [list] => Array
        (
            [fullordering] => t.state ASC
            [limit] => 20
        )

    [batch] => Array
        (
            [assigned_to] => 
            [status] => 
            [category_id] => 
            [tag] => 
        )

    [task] => 
    [boxchecked] => 0
    [9cedc706d8e8ccef81af84d0e2fbb97f] => 1
)
$_COOKIE
Array
(
    [astroid-default-tab] => #astroid-tab-basic
    [atumSidebarState] => open
    [joomla_user_state] => logged_in
    [9c9e2b6146e5979c3c7f305604486a61] => dfvut3gei16i27ar6il7dlcmu5
    [4022a839d728ce419479ebb7d4504f17] => t4rtm3bvt36g37v365clq3sa7r
)
$_REQUEST
Array
(
    [option] => com_ats
    [view] => tickets
    [filter] => Array
        (
            [search] => 
            [user] => 
            [assigned_to] => 
            [status] => 
            [public] => 
            [enabled] => 
            [since] => 
            [to] => 
        )

    [list] => Array
        (
            [fullordering] => t.state ASC
            [limit] => 20
        )

    [batch] => Array
        (
            [assigned_to] => 
            [status] => 
            [category_id] => 
            [tag] => 
        )

    [task] => 
    [boxchecked] => 0
    [9cedc706d8e8ccef81af84d0e2fbb97f] => 1
)
Session state
Array
(
    [session] => Array
        (
            [timer] => Array
                (
                    [start] => 1690466761
                    [last] => 1690466948
                    [now] => 1690466956
                )

            [counter] => 15
            [token] => c4f162b9077a13f4b6e5367331b0e444
        )

    [registry] => Array
        (
            [data] => Array
                (
                    [com_ats] => Array
                        (
                            [tickets] => Array
                                (
                                    [ordercol] => 
                                    [list] => Array
                                        (
                                            [fullordering] => t.state ASC
                                            [limit] => 20
                                        )

                                    [filter] => Array
                                        (
                                            [search] => 
                                            [user] => 
                                            [assigned_to] => 
                                            [status] => 
                                            [public] => 
                                            [enabled] => 
                                            [since] => 
                                            [to] => 
                                        )

                                )

                        )

                    [com_config] => Array
                        (
                            [edit] => Array
                                (
                                    [component] => Array
                                        (
                                            [com_ats] => Array
                                                (
                                                    [data] => 
                                                )

                                        )

                                )

                        )

                )

            [initialized] => 
            [separator] => .
        )

    [user] => Array
        (
            [id] => 694
            [name] => Frank
            [username] => adminxl
            [email] => [email protected]
            [password] => $2y$10$4hd23R03AS/JdLMqxhNSTugc8C0unoBU4Bjt.A/ILnNOEWBATaMLC
            [password_clear] => 
            [block] => 0
            [sendEmail] => 1
            [registerDate] => 2023-06-27 13:21:31
            [lastvisitDate] => 2023-07-27 14:06:16
            [activation] => 0
            [params] => {"admin_style":"","admin_language":"","language":"","editor":"","timezone":"","a11y_mono":"0","a11y_contrast":"0","a11y_highlight":"0","a11y_font":"0"}
            [groups] => Array
                (
                    [8] => 8
                )

            [guest] => 0
            [lastResetTime] => 
            [resetCount] => 0
            [requireReset] => 0
            [aid] => 
            [typeAlias] => 
            [otpKey] => 
            [otep] => 
            [authProvider] => 
        )

    [plg_system_webauthn] => Array
        (
            [returnUrl] => https://supportdesk4all.nl/administrator/index.php
        )

    [com_users] => Array
        (
            [mfa_checked] => 1
        )

    [application] => Array
        (
            [queue] => Array
                (
                )

        )

)
PHP Settings
memory_limit 2048M
upload_max_filesize 512M
post_max_size 512M
display_errors  
short_open_tag 1
file_uploads 1
output_buffering 1
open_basedir  
session.save_path /opt/alt/php80/var/lib/php/session
session.auto_start 0
disable_functions  
xml 1
zlib 1
zip 1
mbstring 1
fileinfo 1
gd 1
iconv 1
intl 1
max_input_vars 20000
Loaded PHP Extensions
bcmath  
bz2  
calendar  
ctype  
curl
Array
(
    [cURL support] => enabled
    [cURL Information] => 7.84.0
    [Age] => 9
    [AsynchDNS] => Yes
    [CharConv] => No
    [Debug] => No
    [GSS-Negotiate] => No
    [IDN] => Yes
    [IPv6] => Yes
    [krb4] => No
    [Largefile] => Yes
    [libz] => Yes
    [NTLM] => Yes
    [NTLMWB] => Yes
    [SPNEGO] => Yes
    [SSL] => Yes
    [SSPI] => No
    [TLS-SRP] => Yes
    [HTTP2] => Yes
    [GSSAPI] => Yes
    [KERBEROS5] => Yes
    [UNIX_SOCKETS] => Yes
    [PSL] => No
    [HTTPS_PROXY] => Yes
    [MULTI_SSL] => No
    [BROTLI] => No
    [Protocols] => dict, file, ftp, ftps, gopher, gophers, http, https, imap, imaps, ldap, ldaps, mqtt, pop3, pop3s, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp
    [Host] => x86_64-redhat-linux-gnu
    [SSL Version] => OpenSSL/1.1.1p
    [ZLib Version] => 1.2.7
    [libSSH Version] => libssh2/1.10.0
    [Directive] => Array
        (
            [0] => Local Value
            [1] => Master Value
        )

    [curl.cainfo] => Array
        (
            [0] => no value
            [1] => no value
        )

)
date  
dom  
exif  
fileinfo  
filter  
ftp
Array
(
    [FTP support] => enabled
    [FTPS support] => enabled
)
gd  
gettext  
gmp  
hash  
iconv  
imap  
intl  
json  
libxml  
mbstring  
mysqli  
mysqlnd  
openssl
Array
(
    [OpenSSL support] => enabled
    [OpenSSL Library Version] => OpenSSL 1.1.1p  21 Jun 2022
    [OpenSSL Header Version] => OpenSSL 1.1.1p  21 Jun 2022
    [Openssl default config] => /opt/alt/openssl11/etc/pki/tls/openssl.cnf
    [Directive] => Array
        (
            [0] => Local Value
            [1] => Master Value
        )

    [openssl.cafile] => Array
        (
            [0] => no value
            [1] => no value
        )

    [openssl.capath] => Array
        (
            [0] => no value
            [1] => no value
        )

)
pcntl  
pcre  
PDO  
pdo_mysql  
pdo_sqlite  
Phar  
posix  
readline  
Reflection  
session
Array
(
    [Session Support] => enabled
    [Registered save handlers] => files user
    [Registered serializer handlers] => php_serialize php php_binary
    [Directive] => Array
        (
            [0] => Local Value
            [1] => Master Value
        )

    [session.auto_start] => Array
        (
            [0] => Off
            [1] => Off
        )

    [session.cache_expire] => Array
        (
            [0] => 180
            [1] => 180
        )

    [session.cache_limiter] => Array
        (
            [0] => none
            [1] => nocache
        )

    [session.cookie_domain] => Array
        (
            [0] => no value
            [1] => no value
        )

    [session.cookie_httponly] => Array
        (
            [0] => 1
            [1] => no value
        )

    [session.cookie_lifetime] => Array
        (
            [0] => 0
            [1] => 0
        )

    [session.cookie_path] => Array
        (
            [0] => /
            [1] => /
        )

    [session.cookie_samesite] => Array
        (
            [0] => no value
            [1] => no value
        )

    [session.cookie_secure] => Array
        (
            [0] => 1
            [1] => 0
        )

    [session.gc_divisor] => Array
        (
            [0] => 1000
            [1] => 1000
        )

    [session.gc_maxlifetime] => Array
        (
            [0] => 900
            [1] => 1440
        )

    [session.gc_probability] => Array
        (
            [0] => 1
            [1] => 1
        )

    [session.lazy_write] => Array
        (
            [0] => On
            [1] => On
        )

    [session.name] => Array
        (
            [0] => 4022a839d728ce419479ebb7d4504f17
            [1] => PHPSESSID
        )

    [session.referer_check] => Array
        (
            [0] => no value
            [1] => no value
        )

    [session.save_handler] => Array
        (
            [0] => user
            [1] => files
        )

    [session.save_path] => Array
        (
            [0] => /opt/alt/php80/var/lib/php/session
            [1] => /opt/alt/php80/var/lib/php/session
        )

    [session.serialize_handler] => Array
        (
            [0] => php
            [1] => php
        )

    [session.sid_bits_per_character] => Array
        (
            [0] => 5
            [1] => 5
        )

    [session.sid_length] => Array
        (
            [0] => 26
            [1] => 26
        )

    [session.upload_progress.cleanup] => Array
        (
            [0] => On
            [1] => On
        )

    [session.upload_progress.enabled] => Array
        (
            [0] => On
            [1] => On
        )

    [session.upload_progress.freq] => Array
        (
            [0] => 1%
            [1] => 1%
        )

    [session.upload_progress.min_freq] => Array
        (
            [0] => 1
            [1] => 1
        )

    [session.upload_progress.name] => Array
        (
            [0] => PHP_SESSION_UPLOAD_PROGRESS
            [1] => PHP_SESSION_UPLOAD_PROGRESS
        )

    [session.upload_progress.prefix] => Array
        (
            [0] => upload_progress_
            [1] => upload_progress_
        )

    [session.use_cookies] => Array
        (
            [0] => 1
            [1] => 1
        )

    [session.use_only_cookies] => Array
        (
            [0] => 1
            [1] => 1
        )

    [session.use_strict_mode] => Array
        (
            [0] => 0
            [1] => 0
        )

    [session.use_trans_sid] => Array
        (
            [0] => 0
            [1] => 0
        )

)
shmop  
SimpleXML  
soap  
sockets  
SPL  
sqlite3  
standard  
tokenizer
Array
(
    [Tokenizer Support] => enabled
)
xml  
xmlreader  
xmlwriter  
xsl  
zip  
zlib  
Enabled Extensions Directory Status
administrator/components Writeable
administrator/components/com_joomlaupdate Writeable
administrator/language Writeable
administrator/language/en-GB Writeable
administrator/language/nl-NL Writeable
administrator/language/overrides Writeable
administrator/manifests/packages Writeable
administrator/manifests/files Writeable
administrator/manifests/libraries Writeable
administrator/modules Writeable
administrator/templates Writeable
components Writeable
images Writeable
images/banners Writeable
images/headers Writeable
images/sampledata Writeable
images/tp_sport Writeable
language Writeable
language/en-GB Writeable
language/nl-NL Writeable
language/overrides Writeable
libraries Writeable
media Writeable
modules Writeable
plugins Writeable
plugins/finder Writeable
plugins/ats Writeable
plugins/webservices Writeable
plugins/system Writeable
plugins/extension Writeable
plugins/privacy Writeable
plugins/workflow Writeable
plugins/editors-xtd Writeable
plugins/editors Writeable
plugins/multifactorauth Writeable
plugins/filesystem Writeable
plugins/media-action Writeable
plugins/api-authentication Writeable
plugins/installer Writeable
plugins/user Writeable
plugins/fields Writeable
plugins/authentication Writeable
plugins/captcha Writeable
plugins/actionlog Writeable
plugins/task Writeable
plugins/quickicon Writeable
plugins/sampledata Writeable
plugins/content Writeable
plugins/console Writeable
plugins/behaviour Writeable
templates Writeable
configuration.php Unwriteable
administrator/cache [COM_ADMIN_CACHE_DIRECTORY] Writeable
media/cache [COM_ADMIN_MEDIA_CACHE_DIRECTORY] Writeable
/home/supportdesk/domains/supportdesk4all.nl/public_html/administrator/logs [COM_ADMIN_LOG_DIRECTORY] Writeable
/home/supportdesk/domains/supportdesk4all.nl/public_html/tmp [COM_ADMIN_TEMP_DIRECTORY] Writeable

tampe125
Akeeba Staff

Thank you for the report, that's just a typo, we're going to fix it in the next release.

In the meantime you can click on the header of the table to sort by the Status

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!