[core]: Upgrader Error

huynd

Hello OsTicket team and everybody,
I'm system admin from Vietnam. I have the plan to migrate database osticket from current server to the new server with new version osticket.
Server osticket current (called Server A): PHP5.6.40, MariaDB 5.5, OsTicket ver 1.12
I created the new server (called Server B): PHP5.6.40, MariaDB5.6, OsTicket ver 1.14
I used mysqldump command line to backup the database named osticket_db on server A. And then, I restore this database on server B when i installed the new version OsTicket already on server B.
So, I login OsTicket on new server. It forced me upgrade the OsTicket, I clicked upgrade but it got the error:
"[CREATE_TABLE ost_thread_entry_merge (id. init(11) unsigned NOT NULL
auto_increment, thread_entry_id init (11) unsigned NOT NULL, data text,
PRIMARY KEY (id), KEY thread_entry_id (thread_entry_id) )
ENGINE=InnoDB DEFAULT CHARSET=utf8] Table 'ost_thread_entry_merge' already exist"

Please help me to resolve this, thank all.

KevinTheJedi

@huynd

Well, somehow you already have the ost_thread_entry_merge table when it shouldn’t exist yet. You most likely installed the merge feature before it became a part of core and now that it’s a part of core it’s causing upgrade issues. You will need to restore from backup, rename the table (or delete the table if you don’t care about current merges), then re-attempt the upgrade.

Cheers.

huynd

KevinTheJedi
Hello Kevin,
I just renamed the table "ost_thread_entry_merge" and re-try upgrade, but it got the new error like this:

[ALTER TABLE ost_ticket ADD ticket_pid int(11) unsigned DEFAULT NULL
AFTER ticket_id, ADD sort int(11) unsigned NOT NULL DEFAULT '0'
AFTER flags] Duplicate column name 'ticket_pid'

KevinTheJedi

@huynd

Repeat the same steps but this time rename the ost_ticket.pid column as well.

Cheers.

BRYANSY115

Hi osticket team. Am quite a need your help. Have the same issue with thread starter. Our old osticket version os 1.12 and i tried to replicate and migrated the sql file to new server.

at first the error is this

"[CREATE_TABLE ost_thread_entry_merge (id. init(11) unsigned NOT NULL
auto_increment, thread_entry_id init (11) unsigned NOT NULL, data text,
PRIMARY KEY (id), KEY thread_entry_id (thread_entry_id) )
ENGINE=InnoDB DEFAULT CHARSET=utf8] Table 'ost_thread_entry_merge' already exist"

so i did follow the rename ost_thread_entry_merge

then the next error is the same with the topic.

[ALTER TABLE ost_ticket ADD ticket_pid int(11) unsigned DEFAULT NULL
AFTER ticket_id, ADD sort int(11) unsigned NOT NULL DEFAULT '0'
AFTER flags] Duplicate column name 'ticket_pid'

os i did follow rename the ost_ticket then the problem is here i cannot upgrade because it searching for ost_ticket

[]EXECUTE stmt] Table 'osticketDB.ost_ticket' doesn't exist

i need to revert it back the renamed ost_ticket. Am quite a bit lost on this one.

BRYANSY115

i tried to delete " ticket_pid " and "ticket_id" and "sort" and "flags". so i thought it will work. but the error is this

[ALTER TABLE ost_ticket ADD ticket_pid int(11) unsigned DEFAULT NULL AFTER ticket_id, ADD sort int(11) unsigned NOT NULL DEFAULT '0' AFTER flags] Unknown column 'ticket_id' in 'ost_ticket'

BRYANSY115

i dont know if its luck or somethings else. i did delete those tables then i restore sql using mysql workbench then boila it work.