DarkTexas

Just a tip for next time, you don't ever need to delete a table unless it's absolutely required. To remove all data you can simply run the TRUNCATE command. This clears all data from the table at once.

Cheers.

gonzalosuarez2001

Setting isonline to 1 is all you need to do to put osTicket Online. If you cannot access your helpdesk after doing so then check all possible logs (general server logs, webserver error logs, PHP error logs, MySQL/MariaDB error logs, osTicket System Logs, Browser Console logs, etc.) for any related errors. If you mean you can access the login page but can't login then that either means you are not an Admin (only Admins can login during Upgrade Pending state) or likely your Agent account is limited to an external authentication source which will likely not work as your system isn't upgraded yet. You will need to go to the db and set your backend to NULL so you can login using your local osTicket password. If you don't have a local password you will need to set one using a bcrypt hash using 8 rounds of entropy. There are many free sites online that can generate one for you.

In case you haven't seen it, we do have Upgrade Documentation here:

• https://docs.osticket.com/en/latest/Getting%20Started/Upgrade%20and%20Migration.html

Cheers.

KevinTheJedi

Thank you so much for your assistance.
optimizer_search_depth=0 did the trick. Now, the longest run time for an SQL query is about 6 seconds.

In reply to

You would've seen that v1.18.1 only supports PHP 8.1-8.2.

You are correct. I overlooked this. I just set up a quick and dirty test environment. I will wait until osTicket supports PHP 8.3 and then create a fresh server setup for production.