
Sifathur, look in the email footer. Verstuurd vanaf mijn iPhone
Op 17 feb. 2019 om 14:58 heeft sifathur rehman
het volgende geschreven: Please unsubscribe me .
-----Original Message----- From: otrs [mailto:otrs-bounces@lists.otrs.org] On Behalf Of Roy Kaldung Sent: Sunday, February 17, 2019 12:21 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Question on successful upgrade
Hi Rob,
On Feb 16, 2019, at 8:39 PM, Rob Mitchell
wrote: I was able to clear up the error by manually running the individual ALTER TABLE statements after running SET FOREIGN_KEY_CHECKS=0; prior to running the sql script (reset this to 1 afterward).
AFAIK Foreign keys are only support with the table / database engine InnoDB. I would recommend converting all tables from MyISAM to InnoDB before upgrading from 3.0
Afterwards I ran select * from information_schema.table_constraints where table_name = 'table_name'; for each of the affected tables and could see that all of the constraints were added correctly. I also checked the table descriptions and ran a select to return * from each of the tables - they are all empty tables, and they were created by the DBUpdate-to-3.1.mysql.sql script.
All that is background information. My question is pretty simple: What are these tables for - they are empty now. Were these schema modifications for future prupose? These are the seven tables created. They're all there and the information_schema.table_constraints show the constraints were correctly applied: gi_webservice_config gi_webservice_config_history gi_debugger_entry gi_object_lock_state smime_signer_cert_relations dynamic_field_value dynamic_field
OTRS 3.1 introduces Dynamic Fields which replaces the FreeTextFields. If there were none of these fields used this could be the explanation for empty dynamic fields tables. The gi_* tables are for the GenericInterface and empty as long you don’t a have a configured web service.
- Roy
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs