Znuny Open Source Ticketsystem

According to source code , the ticket gets locked when an agent assigns a new owner to a ticket. While this is reasonable in general as stated in the znuny docs : Ticket ownership can be transferred between agents using Znuny’s agent interface. The primary way to reassign ownership is via the “Owner...

Did you verify that special characters e.g. diacritic symbols are well migrated too? E.g. Umlauts, cyrillic, latin diacritic symbols and so on do your fulltext searches still do a good job with your special chars? did the attachments work like a charm still? Yes to all :D As you were mentioning the...

Hey Kai,

this is great to hear! Thanks for the feedback!

Best
Gregor

I'm trying to create a new system address and queue in Znuny using command line tools, but I’m running into a circular dependency issue. When I try to add a system address, it requires a queue: bin/otrs.Console.pl Admin::SystemAddress::Add --name testAddress --email-address test@example.com Error: p...

Yes, I successfully completed the migration from MySQL to PostgreSQL using CloneDB 6.5.2. However, during the process, I encountered a bug in the CloneDB package that required an adjustment in the Base.pm file. The issue was in line 290 of the Base.pm file: https://github.com/znuny/OTRSCloneDB/blob/...

I've decided to switch from using pgloader to CloneDB for my database migration. I completed the migration steps from OTRS 6.0 to Znuny versions 6.1, 6.2, 6.3, 6.4, and finally 6.5.11, and then used CloneDB to handle the MySQL to PostgreSQL migration (https://github.com/znuny/OTRSCloneDB/tree/rel-6....

Hi Roy, yes, I created a pgloader config file with CAST type int to integer, type datetime to timestamp, longtext to text As you know, the postgresql schema does not use BYTEA but all fields which are binary in mysql/mariaDB (LONGBLOB) are TEXT in pgsql. However, pgloader can transfer longblob only ...

When we have to deal with binary data like a jpg in standard_attachment.content, the problem is how to get this binary data over to the TEXT field in postgresql (the schema sql for postgresql defines this field to be of type TEXT). pgloader handles LONGBLOB (which is used in the mysql schema) fields...

Hi all, I intend to migrate from otrs 6.0.18 to znuny 6.5 and thereby also to switch from mariaDB to postgres. I already tried the DB migration with the help of pgloader and noticed that some type casts should be set in the pgloader config file (e.g. datetime from mariaDB is migrated to 'datetime wi...