Re: [otrs] upgrade from 3.0.11 to 3.1.2 error on: scripts/DBUpdate-to-3.1.mysql.sql

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 wrote:

Hi Ugo,

Have you done the upgrade in some way bypassing this problem or not ?

Br,

Luca Domenella Storage Team Leader