On 2012-03-07 12:21, Michiel Beijen wrote:
Hi Steven,
We do not use a specific engine. This means that we'll use whatever
engine your MySQL uses as default. For instance on Windows the default
engine is InnoDB, and I guess more and more InnoDB is becoming the
default storage engine for MySQL.
So I guess you simply set up MySQL with MyISAM as a storage engine,
then installed OTRS, then the MySQL default storage engine switched to
InnoDB beause of an OS or MySQL upgrade, then you upgraded OTRS and
now you'll have tables with different storage engines in one database.
So I'll understand your issue but you should probably complain with
your OS vendor, and not with OTRS.
As for the foreign keys: MyISAM does not USE foreign keys but you can
specify one. It will just not be enforced. This to support people like
us who have ONE create table statement for MySQL regardless of the
storage engine. Ref:
http://dev.mysql.com/doc/refman/5.1/en/ansi-diff-foreign-keys.html
The error message you have is that the table
"smime_signer_cert_relations" is already there, and the upgrade script
tries to create it a second time and then fails. This table is added
in OTRS 3.1, and you should really only have that after you ran the
update script "DBUpdate-to-3.1.mysql.sql" -- my idea is you simply
tried to run this script two times.
If you can reproduce this error, obviously I would be interested to
know how you got this.
I'll definitely try to reproduce the issue I got.
Thanks,
Ugo
---------------------------------------------------------------------
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
