Hi all,

I also seen that the script create a table gi_webservice_config and try to add a FK. Awfully our DB is MyISAM… So its not supported

In the otrs3 db schema for mysql, do i need to change the default DB ENGINE from MyISAM to INNODB ?

Please let me know how to fix that

Br,


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.



Da: Luca Domenella <Luca.Domenella@bwinparty.com>
Risposta: "otrs@otrs.org" <otrs@otrs.org>
Data: Wed, 7 Mar 2012 11:22:22 +0000
A: "otrs@otrs.org" <otrs@otrs.org>
Oggetto: [otrs] upgrade from 3.0.11 to 3.1.2 error on: scripts/DBUpdate-to-3.1.mysql.sql

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.


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