Hi, I just tried to upgrade from V1.11 to the latest 1.14.1. By mistake I messed up my mysqldump and ended up not having a valid DB backup without noticing it. Sure enough, the upgrade crashed, see log below. I tried deleting the table but the upgrader is now blocked and asks to reload the backup.

[core]: Upgrader Error
[/** * @signature 86707325fc571e56242fccc46fd24466 *
@version v1.11.0 * @title Add ticket referral * * This patch adds a table for thread referral as well as thread event states of referred and deleted */ CREATE TABLE ost_thread_referral ( id int(10) unsigned NOT NULL AUTO_INCREMENT, thread_id int(11) unsigned NOT NULL, object_id int(11) unsigned NOT NULL, object_type char(1) NOT NULL, created datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY ref (object_id, object_type, thread_id), KEY thread_id (thread_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8] Table 'ost_thread_referral' already exists

Log Date: Wed, 8 Apr 2020 11:36AM IP Address: 107.179.247.185

My two main questions are:

1- Can I somehow still extract the tickets info and Knowledge base from the current messed up DB and import it to a previous backup from last week?

2- Is there a way to retry the upgrade on the existing DB?

Thanks in advance for your help!

    francisl
    Your errors is ost_thread_referral' already exists, so you need to delete that, when you re-run upgrade it will clear up

    I don't think you can import upgraded version into older version, but i am sure you can extract data out of database and format it way you want

      Before you do anything, I recommend that you take a back up of the DB. Since you cannot undo a partial upgrade you might want to have it in the state it is in now just in case.

      Next re-run the upgrader. If you get an error that says 'table_name' already exists write down the name of the table. Then delete the table at the database level.

      When you invariably get the next error (and you will likely get a few) write down what it is. If it says column already exists delete the column at the database level.

      Each time you run the upgrader you will need to re-perform all the steps that you have written down, until it completes. I'm not sure how many times you will have to go through this process until the upgrader completes. Nor am I sure why the problem occurred in the first place.

      4 days later

      Thank you for your help. My host provider was able to restore a DB backup for me. Then I did re-run the update until it finally worked. Here are the tables I had to drop:

      Table 'ost_thread_referral' already exists
      Table 'ost_queue_export' already exists
      Table 'ost_event' already exists
      Table 'ost_thread_entry_merge' already exists

      I now run 1.14.1. It looks great, but I already found what looks like a bug. I like to do advanced searchs, but now everytime I use that feature, the number is results doesn't work. it always shows 10 pages and about 500 results when the real amount is far less than that. I end up not knowing how many hits my search has and most of pages links are empty... Any thoughts on that?

      Write a Reply...