Attachments corrupted by c3_ticket_exporter

[malberghini]

We are upgrading from 2.7 to 4.0 and have run into trouble with attachments being corrupted in the process. Here's the situation:

1. I upgraded 2.7 to 3.6. Attachments are fine at this point.

2. I run the c3_ticket_exporter as described in the upgrade docs.

3. Import all the tickets into Cerb4 and they are all corrupted, and lose filename extensions.

I have tried opening one of the msg files produced by the exporter, and the attachments are there in the message, but when I pull one out it is corrupted. So it looks like c3_ticket_exporter is corrupting messages, then the import process is taking those and shaving off the filename extensions.

[bcavish]

hi there,

When you imported all of the tickets into cerb4 did you first change the web ownerships and the modded privs to your web owner and 777 before trying to parse the messages? I can see the messages corrupting if they are owned by the wrong user.

[malberghini]

I have tried importing messages with permissions set to 777 and they are still corrupted and lose file extensions.

[bcavish]

After upgrading your other helpdesk to version 3.6, if you run the upgrade.php database verification script does it show any errors? Are you using the built java module or your own version of java?

[malberghini]

The 3.6 DB verification gives the following warnings:

WARNING: queue_addresses.address_unique is a needed index and does not exist.

Verifying queue_addresses.queue_address ... WARNING: field_key is () should be (MUL): not found!

WARNING: thread_attachments.search is a needed index and does not exist.

The version of java is the standard version with out RedHat install:
/usr/bin/java -version
java version "1.6.0_03"
Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
Java HotSpot(TM) Server VM (build 1.6.0_03-b05, mixed mode)