Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Upgrading from 1.9.14 to 1.10 - Unknown column 'ticket_id' in 'NEW'

Hi all,

Upgrading from 1.9.14 to 1.10 gives me this error:

[UPDATE `ost_thread_event` A1 LEFT JOIN `ost__ticket_thread_evt` A2 ON (A1.`thread_id` = A2.`object_id`) SET A1.`thread_id` = A2.`id`] Unknown column 'ticket_id' in 'NEW'

Using:
MySQL 5.6.33
PHP 5.5

Any ideas in how to solve this issue?

Best Regards,
João Clérigo

Comments

  • I've pinged the devs to take a look at this thread.

  • edited November 2016
    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: 

    [UPDATE `ost_thread_event` A1 LEFT JOIN `ost_staff` A2 ON (A2.`username` = A1.`username`) SET A1.`uid` = A2.`staff_id` WHERE A1.`username` != 'SYSTEM'] Unknown column 'ticket_id' in 'NEW' 

    Best Regards, 
    João Clérigo
  • Same error here when updating 1.9.15 to 1.10
  • edited September 29
    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.
Sign In or Register to comment.