Search not working after upgrade from v1.9.8.1

rwfitzy

I upgraded to v1.18.2 and now the search function is returning no tickets. Here is my system information, I don't see any errors in the browser console.

Server Information
osTicket Version v1.18.2 (53339df) — Up to date
Web Server Software Apache/2.4.58 (Ubuntu)
MySQL Version 10.11.13
PHP Version 8.4.15
PHP Extensions
gdlib Used for image manipulation and PDF printing
iconv Useful for email processing
imap Useful for email processing
ctype Required 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
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone America/New_York
Database Information and Usage
Schema osticketdb (localhost)
Schema Signature 5fb92bef17f3b603659e024c01cc7a59
Space Used 33.75 MiB
Space for Attachments 13.50 MiB
Timezone EST (Interpreted as America/New_York)

rwfitzy

I am actually seeing this in the browser console..

And then this in the error log...
[Thu Dec 18 08:18:05.241602 2025] [php:error] [pid 69199] [client 192.168.1.59:60438] PHP Fatal error: Uncaught InconsistentModelException: Unable to prepare query: Table 'osticketdb.ost__search' doesn't exist

Sure enough osticketdb.ost__search does not exist in the database.

rwfitzy

Okay, I created the missing table from another install and it appears to be working now.