Re: Question on successful upgrade

Sifathur, look in the email footer.

Verstuurd vanaf mijn iPhone

> Op 17 feb. 2019 om 14:58 heeft sifathur rehman <[email protected]> het volgende geschreven:
> 
> Please unsubscribe me .
> 
> -----Original Message-----
> From: otrs [mailto:[email protected]] 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 <[email protected]> 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


---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs