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. - Mike On Wed, Mar 7, 2012 at 15:11, Steven Carr <sjc...@gmail.com> wrote: > My OTRS install (3.0.11) seems to have a mix of MyISAM/InnoDB - would be > nice if developers stuck to one engine, and if they are going to change to > use relationship features in InnoDB, then change all tables. > > Steve > > +------------------------------+--------+-------+-----------+-----------------+ > | Table Name | Engine | Rows | Size | > Collation | > +------------------------------+--------+-------+-----------+-----------------+ > | article | MyISAM | 1593 | 129.74 Mb | > utf8_general_ci | > | article_attachment | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | article_flag | MyISAM | 1467 | 0.13 Mb | > utf8_general_ci | > | article_plain | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | article_search | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | article_sender_type | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | article_type | MyISAM | 11 | 0.01 Mb | > utf8_general_ci | > | auto_response | MyISAM | 4 | 0.02 Mb | > utf8_general_ci | > | auto_response_type | MyISAM | 5 | 0.01 Mb | > utf8_general_ci | > | customer_company | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | customer_preferences | MyISAM | 30 | 0.01 Mb | > utf8_general_ci | > | customer_user | MyISAM | 4 | 0.01 Mb | > utf8_general_ci | > | faq_attachment | MyISAM | 1 | 0.05 Mb | > utf8_general_ci | > | faq_category | MyISAM | 2 | 0.00 Mb | > utf8_general_ci | > | faq_category_group | MyISAM | 4 | 0.00 Mb | > utf8_general_ci | > | faq_history | MyISAM | 19 | 0.00 Mb | > utf8_general_ci | > | faq_item | MyISAM | 4 | 0.01 Mb | > utf8_general_ci | > | faq_language | MyISAM | 2 | 0.01 Mb | > utf8_general_ci | > | faq_log | MyISAM | 94 | 0.02 Mb | > utf8_general_ci | > | faq_state | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | faq_state_type | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | faq_voting | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | follow_up_possible | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | generic_agent_jobs | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | groups | MyISAM | 9 | 0.01 Mb | > utf8_general_ci | > | group_customer_user | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | group_role | MyISAM | 18 | 0.01 Mb | > utf8_general_ci | > | group_user | MyISAM | 1 | 0.00 Mb | > utf8_general_ci | > | link_object | MyISAM | 2 | 0.00 Mb | > utf8_general_ci | > | link_relation | MyISAM | 7 | 0.01 Mb | > utf8_general_ci | > | link_state | MyISAM | 2 | 0.01 Mb | > utf8_general_ci | > | link_type | MyISAM | 2 | 0.01 Mb | > utf8_general_ci | > | mail_account | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | notifications | MyISAM | 20 | 0.01 Mb | > utf8_general_ci | > | notification_event | MyISAM | 2 | 0.01 Mb | > utf8_general_ci | > | notification_event_item | MyISAM | 12 | 0.01 Mb | > utf8_general_ci | > | package_repository | MyISAM | 5 | 8.44 Mb | > utf8_general_ci | > | personal_queues | MyISAM | 4 | 0.00 Mb | > utf8_general_ci | > | postmaster_filter | MyISAM | 14 | 0.01 Mb | > utf8_general_ci | > | process_id | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | queue | MyISAM | 8 | 0.02 Mb | > utf8_general_ci | > | queue_auto_response | MyISAM | 4 | 0.01 Mb | > utf8_general_ci | > | queue_preferences | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | queue_standard_response | MyISAM | 5 | 0.01 Mb | > utf8_general_ci | > | roles | MyISAM | 6 | 0.01 Mb | > utf8_general_ci | > | role_user | MyISAM | 6 | 0.01 Mb | > utf8_general_ci | > | salutation | MyISAM | 1 | 0.01 Mb | > utf8_general_ci | > | search_profile | MyISAM | 26 | 0.01 Mb | > utf8_general_ci | > | service | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | service_customer_user | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | service_preferences | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | service_sla | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | sessions | MyISAM | 0 | 0.01 Mb | > utf8_general_ci | > | signature | MyISAM | 1 | 0.01 Mb | > utf8_general_ci | > | sla | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | sla_preferences | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | standard_attachment | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | standard_response | MyISAM | 1 | 0.01 Mb | > utf8_general_ci | > | standard_response_attachment | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | support_bench_test | MyISAM | 30000 | 0.63 Mb | > utf8_general_ci | > | survey | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | survey_answer | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | survey_question | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | survey_queue | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | survey_request | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | survey_vote | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | system_address | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | ticket | MyISAM | 1437 | 0.76 Mb | > utf8_general_ci | > | ticket_flag | InnoDB | 1330 | 0.28 Mb | > utf8_general_ci | > | ticket_history | MyISAM | 8191 | 1.89 Mb | > utf8_general_ci | > | ticket_history_type | MyISAM | 40 | 0.01 Mb | > utf8_general_ci | > | ticket_index | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | ticket_lock_index | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | ticket_lock_type | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | ticket_loop_protection | MyISAM | 1 | 0.01 Mb | > utf8_general_ci | > | ticket_priority | MyISAM | 5 | 0.01 Mb | > utf8_general_ci | > | ticket_state | MyISAM | 9 | 0.01 Mb | > utf8_general_ci | > | ticket_state_type | MyISAM | 7 | 0.01 Mb | > utf8_general_ci | > | ticket_type | MyISAM | 1 | 0.01 Mb | > utf8_general_ci | > | ticket_watcher | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | time_accounting | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | users | MyISAM | 2 | 0.01 Mb | > utf8_general_ci | > | user_preferences | MyISAM | 80 | 0.01 Mb | > utf8_general_ci | > | valid | MyISAM | 3 | 0.01 Mb | > utf8_general_ci | > | virtual_fs | InnoDB | 0 | 0.05 Mb | > utf8_general_ci | > | virtual_fs_db | InnoDB | 0 | 0.03 Mb | > utf8_general_ci | > | virtual_fs_preferences | InnoDB | 0 | 0.05 Mb | > utf8_general_ci | > | web_upload_cache | MyISAM | 0 | 0.00 Mb | > utf8_general_ci | > | xml_storage | MyISAM | 772 | 0.08 Mb | > utf8_general_ci | > +------------------------------+--------+-------+-----------+-----------------+ > > > > > On 7 March 2012 13:33, Luca Domenella <luca.domene...@bwinparty.com> wrote: >> >> Hi Ugo, >> >> Have you done the upgrade in some way bypassing this problem or not ? >> >> Br, >> >> Luca Domenella >> Storage Team Leader >> > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
