I've update my CentOS 7 platform, where I've a 1.10.7 running, to match the prerequisites for 1.12.3
(php 7.3 mysql 5.5.64-MariaDB) then I run the process for upgrading. But I receive the following error when running the update process.

[/** * @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

The update scripts seem to create tables that already exist in the DB

any similar experience ? Any help ?

@pboscolo0660

Try renaming the current table to something like ost_thread_referral_backup and run the upgrader again.

Cheers.

Of course if I rename this the errore move to other tables. The problem is that the updater tool seems recreating table that obviously exists. Is like the updating procedure is "installing" rather that updating the software.

If I install 1.10.4 from scratch and update to 1.10.4... OK
If I apply the update to my working 1.10.4 installation... I have this problem. What could be so dirty in my working installation ?

Write a Reply...