when upgrading from 1.10 to 1.18,every thing goes fine ,except viewing tickets are not working . you can view only individual tickets using direct url . after searching ,i found the following error :Fatal error: Uncaught Error: Call to a member function ignoreVisibilityConstraints() on null
in include/staff/templates/queue-tickets.tmpl.php:10
Stack trace:
#0 scp/tickets.php(569): require_once()
#1 scp/index.php(17): require('/home3/attarsec...')
#2 {main} thrown in include/staff/templates/queue-tickets.tmpl.php on line 10
Upgarde to osticket 1.18 no showing tickets
Sounds like maybe some of the files are corrupted or have incorrect permissions when you uploaded them? Maybe it’s your PHP version? Maybe it’s because you are using v1.18 and not the latest of v1.18.1?
Post a screenshot of Admin Panel > Dashboard > Information.
Cheers.
And clear your browser cache.
i am using the latest version
here is the info:
About this osTicket Installation
Server Information
osTicket Version v1.18.1 (0375576) — Up to date
Web Server Software Apache
MySQL Version 5.7.23
PHP Version 8.2.15
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching
xml XML API
xml-dom Used for HTML email processing
json Improves performance creating and processing JSON
mbstring Highly recommended for non western european language content
phar Highly recommended for plugins and language packs
intl Highly recommended for non western european language content
fileinfo Used to detect file types for uploads
zip Used for ticket and task exporting
APCu Improves overall performance
Zend Opcache Improves overall performance
Then it appears your upgrade didn’t run correctly as it’s basically saying there is no Queue. It tries to get a Queue by ID if contained in the URL, or tries to get the default Queue from the system settings, or it tries to get the first Queue from the list of Public Queues or Queues tied to the specific Agent.
So check your _queue table to see if you have any queues there. If not you will want to restore from backup and redo the upgrade.
Cheers.
i have checked the _queue tables ,found empty except _queue (3 records only) ,even from the previous version 1.10 DB. can i try to copy them from fresh install of (1.18) to current upgraded database ?
- Best Answerset by KevinTheJedi
i have tried to insert from another fresh install for this tables queue ,queue_column,queue_columns,queue_sort,_queue_sorts
working Fine now , Al hamdo lellah rab el alamin . Thanks