Hi,

Im testing the upgrade procedure from out ours 2.0.4 to 3.1.2.

I passed thought all the steps:

2.0.4 -> 2.1.x

2.1.x -> 2.2.x

2.2.x -> 2.3.x

2.3.x -> 2.4.x

2.4.x –> 3.0.11

And from 3.0.11 to 3.1.2 when i do the following: cat scripts/DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs

I get this error:

ERROR 1050 (42S01) at line 169: Table 'smime_signer_cert_relations' already exists

Our DBA looked at the sql script and also seen the the instructions go ahead but they stopped when they are trying to create a table with foreign keys.

The problem looks to be that the engine is MyISAM and that myisam do not support foreign keys. We are using mysql 5.5 (stable)

Now the question is: how can i go ahead ? I change the engine from myisam to innodb for this table or did i miss something ?

Please let me know.

Best regards,

Luca Domenella

Storage Team Leader

P: +39 06 54070440 ext: 16

E: luca.domenella@bwinparty.com

bwin Italia

Via Adolfo Ravà, 124

00142 Roma (rm)

Italy

www.bwinparty.com

This email and any attachments are confidential, and may be legally privileged and protected by copyright. If you are not the intended recipient dissemination or copying of this email is prohibited. If you have received this in error, please notify the sender by replying by email and then delete the email completely from your system.

Any views or opinions are solely those of the sender. This communication is not intended to form a binding contract unless expressly indicated to the contrary and properly authorised. Any actions taken on the basis of this email are at the recipient's own risk.