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 |