[dev] Localized and stripped return value of FetchrowArray?

Hi, the following SQL query returns (ceate_time) e.g. 2012-05-22 11:26:39 - in the SQL query box for instance. [Kernel/System/Ticket.pm in OTRS 3.1.5] 2535return if !$Self-{DBObject}-Prepare( 2536SQL = 'SELECT article_sender_type_id, article_type_id, create_time FROM '

Re: [dev] Localized and stripped return value of FetchrowArray?

Hi Michael, Michael Scheer schreef op 2012-05-25 08:52: the following SQL query returns (ceate_time) e.g. 2012-05-22 11:26:39 - in the SQL query box for instance. ... BUT in the RowArray $Row[2] is 22.05.2012 - it's lacking the time and has german time format. Could it be that you use

[dev] : How to find the link btw ticket and dynamic_field value ?

Hi I migrated from otrs 3.0.9 to 3.1.5. All sounds fine, after I migrated the DB (postgres 8.4), but I didn't find how the ticket are linked to the dynamic fields created. This information are vital for me, because I have many automated reports using specific sql select. So before to migrate the

[dev] Upgrading OTRS from 3.0.9 to 3.1.5

Hi Guys, Can anyone help me convert the following code for MSSQL? ALTER IGNORE TABLE ticket_flag ADD CONSTRAINT ticket_flag_per_user UNIQUE INDEX (ticket_id, ticket_key, create_by); Thanks in advance! Aaron ___ OTRS mailing list: dev - Webpage:

Re: [dev] Upgrading OTRS from 3.0.9 to 3.1.5

Aaron G. Angeles schreef op 2012-05-25 16:19: Can anyone help me convert the following code for MSSQL? ALTER IGNORE TABLE ticket_flag ADD CONSTRAINT ticket_flag_per_user UNIQUE INDEX (ticket_id, ticket_key, create_by); Hi Aaron; you should not have to! Check