I've commented in 9143a511-0d6099a6.patch.sql: -- UPDATE `%TABLE_PREFIX%thread_event` A1 -- LEFT JOIN `%TABLE_PREFIX%_ticket_thread_evt` A2 ON (A1.`thread_id` = A2.`object_id`) -- SET A1.`thread_id` = A2.`id`; -- DROP TABLE `%TABLE_PREFIX%_ticket_thread_evt`;

 and the next error is:  Unknown column 'ticket_id' in 'NEW' Best Regards, João Clérigo

Hello,Finally I've solved my problem. Posting the solution in case anyone is in need as I was.First and very important, do backups of your database and all files, in case anything goes wrong you will have to restore your data back. I've had to restore from backups at least some five times until getting it right.- First, upgrade to the next stable version in 1.9.x (if there is one), to me it was at this time 1.9.16.- Rename/copy your OST database, ex. ostdatabase to ostdatabase_bk (if you used copy then DROP ostdatabase).- Create a new and empty database with the same original name: ostdatabase- From the downloaded ZIP (ex. osTicket-v1.9.16.zip) you can find inside this folder: (\upload\setup\inc\streams\core) in it this SQL file (install-mysql.sql).- Execute the file in the new database ostdatabase. This will create the needed tables empty.- Now, copy ONLY the data from the database ostdatabase_bk (do not create any new objects missing, such as tables, indexes, etc., only data rows).- Download the the new stable version 1.10 (at this time to me was 1.10.1) and upload it.- Goto now to your OST dashboard, and you will be asked to UPGRADE.- Execute upgrade.If everything goes well as it did for me, it should work and now you have the new OST 1.10.