Znuny Open Source Ticketsystem

ALTER TABLE standard_template_attachment ENGINE = InnoDB;
result is
ALTER TABLE standard_template_attachment ENGINE = InnoDB; failed : Invalid default value for 'change_time'

as you can see I need to change the default for change_time
then migration runs fine

Thanks Roy, You're right, I've tried to migrate all tables but all fields "create_time" and "change_time" across multiple tables have invalid default values (00.00.00 etc). I'm changing all defaults to CURRENT_TIMESTAMP Is there any way to automate this process or I'll have to do...

I'm testing the upgrade and migratinon of a 5.0.16 to 6.016 I?ve installed a new ubuntu 18.04.02, installed a fresh 6.0.16 and tested fine the aplication running. I've dumped the old DB ~5Gb and double checked the conversion to utf8 cat otrs.backup.sql | replace CHARSET=latin1 CHARSET=utf8 > otrs.ut...

Did you upgrade just the notification_event_message table or the whole DB?

do you have a script to upgrade to utf8mb4 ?

God, thank you, I've been asked for this for months!

devi creare prima una azienda, io come id uso @dominio

e poi creare gli utenti, indicando come companyid = @dominio
da quel punto on poi rimane tutto collegato, per il pregresso, devi modificare i ticket vecchi, con un genericagent, reimpostando sia il customerid che lo userID