The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Horde upgrade totally failed, all settings gone

Discussion in 'E-mail Discussions' started by ggouweloos, Jul 23, 2015.

  1. ggouweloos

    ggouweloos Member

    Joined:
    Nov 26, 2008
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Hi, there was an automatic update a couple of hours ago, the Horde update failed:

    Code:
    [2015-07-23 06:27:06 +0200] info [horde_mysqltosqlite] Backing up the pre-11.50 MySQL Horde database.
    [2015-07-23 06:27:07 +0200] info [horde_mysqltosqlite] Backup of the pre-11.50 MySQL Horde database. The backup is available at: /var/cpanel/horde/horde.backup.sql.final
    [2015-07-23 06:27:07 +0200] warn [horde_mysqltosqlite] table horde_core-back_schema_info does not match expected pattern at /usr/local/cpanel/Cpanel/Logger/Persistent.pm line 37
        Cpanel::Logger::warn(Cpanel::Logger::Persistent=HASH(0x850c948), 'table horde_core-back_schema_info does not match expected pattern') called at /usr/local/cpanel/Cpanel/Horde/MySQLToSQLite.pm line 328
        Cpanel::Horde::MySQLToSQLite::cleanup_temp_tables(Cpanel::Horde::MySQLToSQLite=HASH(0x8a6792c)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 125
        main::run('main', '--replace-dest-db') called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 34
        main::try {...} () called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 81
        eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 72
        Try::Tiny::try(CODE(0x850c858), Try::Tiny::Catch=REF(0x85f62f8)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 41
        main::_run('--replace-dest-db') called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 45
    [2015-07-23 06:27:11 +0200] info [horde_mysqltosqlite] The horde database schema does not match the pristine 11.48 horde schema. Attempting to repair it.
    [2015-07-23 06:27:27 +0200] warn [horde_mysqltosqlite] The conversion of Horde MySQL data to SQLite failed: Failed to run the patch, PATCH 1, to horde with with the following errors:
    ## mysqldiff 0.43
    ##
    ## Run on Thu Jul 23 06:27:13 2015
    ##
    ## ---   db: horde
    ## +++   db: horde1148
    
    ALTER TABLE horde_alarms CHANGE COLUMN alarm_uid alarm_uid varchar(255) DEFAULT NULL
    # was varchar(250) NOT NULL
    ALTER TABLE horde_alarms CHANGE COLUMN alarm_dismissed alarm_dismissed int(1) NOT NULL DEFAULT '0'
    # was tinyint(1) NOT NULL DEFAULT '0'
    ALTER TABLE horde_alarms CHANGE COLUMN alarm_id alarm_id varchar(255) NOT NULL
    # was varchar(250) NOT NULL
    ALTER TABLE horde_alarms ADD COLUMN id int(10) unsigned NOT NULL
    CREATE INDEX tmp_horde_alarms_on_id on horde_alarms (id)
    ALTER TABLE horde_alarms CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT
    ALTER TABLE horde_alarms DROP INDEX alarm_snooze_idx
    ALTER TABLE horde_alarms DROP INDEX alarm_end_idx
    ALTER TABLE horde_alarms DROP INDEX alarm_start_idx
    ALTER TABLE horde_alarms DROP INDEX alarm_user_idx
    ALTER TABLE horde_alarms DROP INDEX alarm_id_idx
    ALTER TABLE horde_alarms DROP INDEX alarm_dismissed_idx
    ALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_end (alarm_end)
    ALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_snooze (alarm_snooze)
    ALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_start (alarm_start)
    ALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_uid (alarm_uid)
    ALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_id (alarm_id)
    ALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_dismissed (alarm_dismissed)
    ALTER TABLE horde_alarms ADD PRIMARY KEY (id)
    DROP INDEX tmp_horde_alarms_on_id ON horde_alarms
    ALTER TABLE horde_alarms ENGINE=InnoDB DEFAULT CHARSET=utf8
    ALTER TABLE horde_cache ENGINE=InnoDB DEFAULT CHARSET=utf8
    ###----------------------------------------------------------------------------
    ### BEGIN ERROR: Failed the next statement with error:
    #DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-back_schema_info' at line 1
    # at /usr/local/cpanel/Cpanel/Exception.pm line 151.
    #    Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x8564e48), HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57
    #    Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x8564e48), HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/Exception.pm line 72
    #    Cpanel::Exception::create_raw("Database::Error", "DBD::mysql::db do failed: You have an error in your SQL synta"..., HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/DBI.pm line 105
    #    Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x9459414), "DBD::mysql::db do failed: You have an error in your SQL synta"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 93
    #    Cpanel::DBI::_error_handler("DBD::mysql::db do failed: You have an error in your SQL synta"..., Cpanel::DBI::Mysql::db=HASH(0x9459414), undef) called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280
    #    eval {...} called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280
    #    Cpanel::Horde::RepairSchema::_write_patch(Cpanel::Horde::RepairSchema=HASH(0x9450688), "## mysqldiff 0.43\x{a}## \x{a}## Run on Thu Jul 23 06:27:13 2015\x{a}##\x{a}#"..., "PATCH 1") called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 110
    #    Cpanel::Horde::RepairSchema::repair_horde_1148_mysql(Cpanel::Horde::RepairSchema=HASH(0x9450688)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 223
    #    main::check_and_fix_1148_schema(HASH(0x850cc68)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 128
    #    main::run("main", "--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 34
    #    main::try {...} () called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 81
    #    eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 72
    #    Try::Tiny::try(CODE(0x850c858), Try::Tiny::Catch=REF(0x85f62f8)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 41
    #    main::_run("--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 45
    
    At the end of the logfile there are some more errors:

    Code:
    ALTER TABLE turba_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT
    ALTER TABLE turba_shares_users DROP INDEX turba_shares_users_user_uid_idx
    ALTER TABLE turba_shares_users DROP INDEX turba_shares_users_perm_idx
    ALTER TABLE turba_shares_users DROP INDEX turba_shares_users_share_id_idx
    ALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_perm (perm)
    ALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_user_uid (user_uid)
    ALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_share_id (share_id)
    ALTER TABLE turba_shares_users ADD PRIMARY KEY (id)
    DROP INDEX tmp_turba_shares_users_on_id ON turba_shares_users
    ALTER TABLE turba_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8 at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 299.
    at /usr/local/cpanel/Cpanel/Logger/Persistent.pm line 37
        Cpanel::Logger::warn(Cpanel::Logger::Persistent=HASH(0x850c948), 'The conversion of Horde MySQL data to SQLite failed: Failed to run the patch, PATCH 1, to horde with with the following errors:\x0A## mysqldiff 0.43\x0A## \x0A## Run on Thu Jul 23 06:27:13 2015\x0A##\x0A## ---   db: horde\x0A## +++   db: horde1148\x0A\x0AALTER TABLE horde_alarms CHANGE COLUMN alarm_uid alarm_uid varchar(255) DEFAULT NULL\x0A# was varchar(250) NOT NULL\x0AALTER TABLE horde_alarms CHANGE COLUMN alarm_dismissed alarm_dismissed int(1) NOT NULL DEFAULT \'0\'\x0A# was tinyint(1) NOT NULL DEFAULT \'0\'\x0AALTER TABLE horde_alarms CHANGE COLUMN alarm_id alarm_id varchar(255) NOT NULL\x0A# was varchar(250) NOT NULL\x0AALTER TABLE horde_alarms ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_horde_alarms_on_id on horde_alarms (id)\x0AALTER TABLE horde_alarms CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE horde_alarms DROP INDEX alarm_snooze_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_end_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_start_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_user_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_id_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_dismissed_idx\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_end (alarm_end)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_snooze (alarm_snooze)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_start (alarm_start)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_uid (alarm_uid)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_id (alarm_id)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_dismissed (alarm_dismissed)\x0AALTER TABLE horde_alarms ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_horde_alarms_on_id ON horde_alarms\x0AALTER TABLE horde_alarms ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_cache ENGINE=InnoDB DEFAULT CHARSET=utf8\x0A###----------------------------------------------------------------------------\x0A### BEGIN ERROR: Failed the next statement with error: \x0A#DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'-back_schema_info\' at line 1\x0A# at /usr/local/cpanel/Cpanel/Exception.pm line 151.\x0A#\x09Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x8564e48), HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57\x0A#\x09Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x8564e48), HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/Exception.pm line 72\x0A#\x09Cpanel::Exception::create_raw("Database::Error", "DBD::mysql::db do failed: You have an error in your SQL synta"..., HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/DBI.pm line 105\x0A#\x09Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x9459414), "DBD::mysql::db do failed: You have an error in your SQL synta"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 93\x0A#\x09Cpanel::DBI::_error_handler("DBD::mysql::db do failed: You have an error in your SQL synta"..., Cpanel::DBI::Mysql::db=HASH(0x9459414), undef) called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280\x0A#\x09eval {...} called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280\x0A#\x09Cpanel::Horde::RepairSchema::_write_patch(Cpanel::Horde::RepairSchema=HASH(0x9450688), "## mysqldiff 0.43\\x{a}## \\x{a}## Run on Thu Jul 23 06:27:13 2015\\x{a}##\\x{a}#"..., "PATCH 1") called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 110\x0A#\x09Cpanel::Horde::RepairSchema::repair_horde_1148_mysql(Cpanel::Horde::RepairSchema=HASH(0x9450688)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 223\x0A#\x09main::check_and_fix_1148_schema(HASH(0x850cc68)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 128\x0A#\x09main::run("main", "--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 34\x0A#\x09main::try {...} () called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 81\x0A#\x09eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 72\x0A#\x09Try::Tiny::try(CODE(0x850c858), Try::Tiny::Catch=REF(0x85f62f8)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 41\x0A#\x09main::_run("--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 45\x0A\x0ADROP TABLE horde_core-back_schema_info\x0A### END ERROR\x0A\x0ADROP TABLE horde_datatree\x0ADROP TABLE horde_datatree_attributes\x0AALTER TABLE horde_groups DROP INDEX group_name\x0AALTER TABLE horde_groups ADD UNIQUE index_horde_groups_on_group_name (group_name)\x0AALTER TABLE horde_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_groups_members DROP INDEX group_uid_idx\x0AALTER TABLE horde_groups_members DROP INDEX user_uid_idx\x0AALTER TABLE horde_groups_members ADD INDEX index_horde_groups_members_on_user_uid (user_uid)\x0AALTER TABLE horde_groups_members ADD INDEX index_horde_groups_members_on_group_uid (group_uid)\x0AALTER TABLE horde_groups_members ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_histories DROP INDEX history_action_idx\x0AALTER TABLE horde_histories DROP INDEX history_ts_idx\x0AALTER TABLE horde_histories DROP INDEX history_uid_idx\x0AALTER TABLE horde_histories ADD INDEX index_horde_histories_on_history_ts (history_ts)\x0AALTER TABLE horde_histories ADD INDEX index_horde_histories_on_history_action (history_action)\x0AALTER TABLE horde_histories ENGINE=InnoDB AUTO_INCREMENT=12473 DEFAULT CHARSET=utf8\x0AALTER TABLE horde_locks CHANGE COLUMN lock_type lock_type smallint(5) unsigned NOT NULL\x0A# was tinyint(3) unsigned NOT NULL\x0AALTER TABLE horde_locks ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_perms DROP INDEX perm_name\x0AALTER TABLE horde_perms ADD UNIQUE index_horde_perms_on_perm_name (perm_name)\x0AALTER TABLE horde_perms ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_prefs CHANGE COLUMN pref_uid pref_uid varchar(255) NOT NULL\x0A# was varchar(200) NOT NULL\x0AALTER TABLE horde_prefs DROP INDEX pref_scope_idx\x0AALTER TABLE horde_prefs DROP INDEX pref_uid_idx\x0AALTER TABLE horde_prefs ADD INDEX index_horde_prefs_on_pref_scope (pref_scope)\x0AALTER TABLE horde_prefs ADD INDEX index_horde_prefs_on_pref_uid (pref_uid)\x0AALTER TABLE horde_prefs ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_sessionhandler CHANGE COLUMN session_lastmodified session_lastmodified int(11) NOT NULL\x0A# was bigint(20) NOT NULL\x0AALTER TABLE horde_sessionhandler DROP INDEX session_lastmodified_idx\x0AALTER TABLE horde_sessionhandler ADD INDEX index_horde_sessionhandler_on_session_lastmodified (session_lastmodified)\x0AALTER TABLE horde_signups CHANGE COLUMN signup_date signup_date int(11) NOT NULL\x0A# was varchar(255) NOT NULL\x0AALTER TABLE horde_signups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_syncml_anchors DROP INDEX syncml_anchors_uid_idx\x0AALTER TABLE horde_syncml_anchors DROP INDEX syncml_anchors_syncpartner_idx\x0AALTER TABLE horde_syncml_anchors DROP INDEX syncml_anchors_db_idx\x0AALTER TABLE horde_syncml_anchors ADD INDEX index_horde_syncml_anchors_on_syncml_uid (syncml_uid)\x0AALTER TABLE horde_syncml_anchors ADD INDEX index_horde_syncml_anchors_on_syncml_syncpartner (syncml_syncpartner)\x0AALTER TABLE horde_syncml_anchors ADD INDEX index_horde_syncml_anchors_on_syncml_db (syncml_db)\x0AALTER TABLE horde_syncml_anchors ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_db_idx\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_cuid_idx\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_suid_idx\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_syncpartner_idx\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_uid_idx\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_syncpartner (syncml_syncpartner)\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_cuid (syncml_cuid)\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_suid (syncml_suid)\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_db (syncml_db)\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_uid (syncml_uid)\x0AALTER TABLE horde_syncml_map ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_tokens ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_vfs DROP INDEX vfs_path_idx\x0AALTER TABLE horde_vfs DROP INDEX vfs_name_idx\x0AALTER TABLE horde_vfs ADD INDEX index_horde_vfs_on_vfs_name (vfs_name)\x0AALTER TABLE horde_vfs ADD INDEX index_horde_vfs_on_vfs_path (vfs_path)\x0AALTER TABLE horde_vfs ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE imp_sentmail DROP INDEX sentmail_ts_idx\x0AALTER TABLE imp_sentmail DROP INDEX sentmail_success_idx\x0AALTER TABLE imp_sentmail DROP INDEX sentmail_who_idx\x0AALTER TABLE imp_sentmail ADD INDEX index_imp_sentmail_on_sentmail_who (sentmail_who)\x0AALTER TABLE imp_sentmail ADD INDEX index_imp_sentmail_on_sentmail_ts (sentmail_ts)\x0AALTER TABLE imp_sentmail ADD INDEX index_imp_sentmail_on_sentmail_success (sentmail_success)\x0AALTER TABLE imp_sentmail ENGINE=InnoDB DEFAULT CHARSET=utf8\x0A###----------------------------------------------------------------------------\x0A### BEGIN ERROR: Failed the next statement with error: \x0A#DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'(forward_owner))\' at line 1\x0A# at /usr/local/cpanel/Cpanel/Exception.pm line 151.\x0A#\x09Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x9465b94), HASH(0x947a0cc)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57\x0A#\x09Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x9465b94), HASH(0x947a0cc)) called at /usr/local/cpanel/Cpanel/Exception.pm line 72\x0A#\x09Cpanel::Exception::create_raw("Database::Error", "DBD::mysql::db do failed: You have an error in your SQL synta"..., HASH(0x947a0cc)) called at /usr/local/cpanel/Cpanel/DBI.pm line 105\x0A#\x09Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x9459414), "DBD::mysql::db do failed: You have an error in your SQL synta"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 93\x0A#\x09Cpanel::DBI::_error_handler("DBD::mysql::db do failed: You have an error in your SQL synta"..., Cpanel::DBI::Mysql::db=HASH(0x9459414), undef) called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280\x0A#\x09eval {...} called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280\x0A#\x09Cpanel::Horde::RepairSchema::_write_patch(Cpanel::Horde::RepairSchema=HASH(0x9450688), "## mysqldiff 0.43\\x{a}## \\x{a}## Run on Thu Jul 23 06:27:13 2015\\x{a}##\\x{a}#"..., "PATCH 1") called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 110\x0A#\x09Cpanel::Horde::RepairSchema::repair_horde_1148_mysql(Cpanel::Horde::RepairSchema=HASH(0x9450688)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 223\x0A#\x09main::check_and_fix_1148_schema(HASH(0x850cc68)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 128\x0A#\x09main::run("main", "--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 34\x0A#\x09main::try {...} () called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 81\x0A#\x09eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 72\x0A#\x09Try::Tiny::try(CODE(0x850c858), Try::Tiny::Catch=REF(0x85f62f8)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 41\x0A#\x09main::_run("--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 45\x0A\x0AALTER TABLE ingo_forwards ADD INDEX ((forward_owner))\x0A### END ERROR\x0A\x0AALTER TABLE ingo_forwards DROP PRIMARY KEY\x0AALTER TABLE ingo_forwards ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_lists DROP INDEX list_idx\x0AALTER TABLE ingo_lists ADD INDEX index_ingo_lists_on_list_owner_and_list_blacklist (list_owner,list_blacklist)\x0AALTER TABLE ingo_lists ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_rules DROP INDEX rule_owner_idx\x0AALTER TABLE ingo_rules ADD INDEX index_ingo_rules_on_rule_owner (rule_owner)\x0AALTER TABLE ingo_rules ENGINE=InnoDB AUTO_INCREMENT=493 DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_shares CHANGE COLUMN perm_guest perm_guest int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE ingo_shares CHANGE COLUMN perm_creator perm_creator int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE ingo_shares CHANGE COLUMN perm_default perm_default int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE ingo_shares CHANGE COLUMN share_flags share_flags int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_share_owner_idx\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_perm_creator_idx\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_share_name_idx\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_perm_default_idx\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_perm_guest_idx\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_perm_guest (perm_guest)\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_share_name (share_name)\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_perm_default (perm_default)\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_share_owner (share_owner)\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_perm_creator (perm_creator)\x0AALTER TABLE ingo_shares ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_shares_groups CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE ingo_shares_groups ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_ingo_shares_groups_on_id on ingo_shares_groups (id)\x0AALTER TABLE ingo_shares_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE ingo_shares_groups DROP INDEX ingo_shares_groups_share_id_idx\x0AALTER TABLE ingo_shares_groups DROP INDEX ingo_shares_groups_group_uid_idx\x0AALTER TABLE ingo_shares_groups DROP INDEX ingo_shares_groups_perm_idx\x0AALTER TABLE ingo_shares_groups ADD INDEX index_ingo_shares_groups_on_share_id (share_id)\x0AALTER TABLE ingo_shares_groups ADD INDEX index_ingo_shares_groups_on_perm (perm)\x0AALTER TABLE ingo_shares_groups ADD INDEX index_ingo_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE ingo_shares_groups ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_ingo_shares_groups_on_id ON ingo_shares_groups\x0AALTER TABLE ingo_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_shares_users CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE ingo_shares_users ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_ingo_shares_users_on_id on ingo_shares_users (id)\x0AALTER TABLE ingo_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE ingo_shares_users DROP INDEX ingo_shares_users_user_uid_idx\x0AALTER TABLE ingo_shares_users DROP INDEX ingo_shares_users_share_id_idx\x0AALTER TABLE ingo_shares_users DROP INDEX ingo_shares_users_perm_idx\x0AALTER TABLE ingo_shares_users ADD INDEX index_ingo_shares_users_on_perm (perm)\x0AALTER TABLE ingo_shares_users ADD INDEX index_ingo_shares_users_on_share_id (share_id)\x0AALTER TABLE ingo_shares_users ADD INDEX index_ingo_shares_users_on_user_uid (user_uid)\x0AALTER TABLE ingo_shares_users ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_ingo_shares_users_on_id ON ingo_shares_users\x0AALTER TABLE ingo_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_spam ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_vacations ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_events CHANGE COLUMN event_baseid event_baseid varchar(255) DEFAULT \'\'\x0A# was varchar(255) DEFAULT NULL\x0AALTER TABLE kronolith_events CHANGE COLUMN event_recurdays event_recurdays int(11) DEFAULT NULL\x0A# was smallint(6) DEFAULT NULL\x0AALTER TABLE kronolith_events CHANGE COLUMN event_modified event_modified int(11) DEFAULT \'0\'\x0A# was int(11) NOT NULL\x0AALTER TABLE kronolith_events CHANGE COLUMN event_recurtype event_recurtype int(11) DEFAULT \'0\'\x0A# was smallint(6) DEFAULT \'0\'\x0AALTER TABLE kronolith_events CHANGE COLUMN event_private event_private int(11) NOT NULL DEFAULT \'0\'\x0A# was tinyint(4) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_events CHANGE COLUMN event_recurinterval event_recurinterval int(11) DEFAULT NULL\x0A# was smallint(6) DEFAULT NULL\x0AALTER TABLE kronolith_events DROP INDEX kronolith_calendar_idx\x0AALTER TABLE kronolith_events DROP INDEX kronolith_uid_idx\x0AALTER TABLE kronolith_events ADD INDEX index_kronolith_events_on_calendar_id (calendar_id)\x0AALTER TABLE kronolith_events ADD INDEX index_kronolith_events_on_event_uid (event_uid)\x0AALTER TABLE kronolith_events ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_shares CHANGE COLUMN perm_guest perm_guest int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_shares CHANGE COLUMN perm_creator perm_creator int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_shares CHANGE COLUMN perm_default perm_default int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_shares CHANGE COLUMN share_parents share_parents varchar(4000) DEFAULT NULL\x0A# was text\x0AALTER TABLE kronolith_shares CHANGE COLUMN share_flags share_flags int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_perm_creator_idx\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_share_owner_idx\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_share_name_idx\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_perm_guest_idx\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_perm_default_idx\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_share_owner (share_owner)\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_share_name (share_name)\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_perm_guest (perm_guest)\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_perm_default (perm_default)\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_perm_creator (perm_creator)\x0AALTER TABLE kronolith_shares ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_shares_groups CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE kronolith_shares_groups ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_kronolith_shares_groups_on_id on kronolith_shares_groups (id)\x0AALTER TABLE kronolith_shares_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE kronolith_shares_groups DROP INDEX kronolith_shares_groups_group_uid_idx\x0AALTER TABLE kronolith_shares_groups DROP INDEX kronolith_shares_groups_share_id_idx\x0AALTER TABLE kronolith_shares_groups DROP INDEX kronolith_shares_groups_perm_idx\x0AALTER TABLE kronolith_shares_groups ADD INDEX index_kronolith_shares_groups_on_perm (perm)\x0AALTER TABLE kronolith_shares_groups ADD INDEX index_kronolith_shares_groups_on_share_id (share_id)\x0AALTER TABLE kronolith_shares_groups ADD INDEX index_kronolith_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE kronolith_shares_groups ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_kronolith_shares_groups_on_id ON kronolith_shares_groups\x0AALTER TABLE kronolith_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_shares_users CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE kronolith_shares_users ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_kronolith_shares_users_on_id on kronolith_shares_users (id)\x0AALTER TABLE kronolith_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE kronolith_shares_users DROP INDEX kronolith_shares_users_share_id_idx\x0AALTER TABLE kronolith_shares_users DROP INDEX kronolith_shares_users_perm_idx\x0AALTER TABLE kronolith_shares_users DROP INDEX kronolith_shares_users_user_uid_idx\x0AALTER TABLE kronolith_shares_users ADD INDEX index_kronolith_shares_users_on_share_id (share_id)\x0AALTER TABLE kronolith_shares_users ADD INDEX index_kronolith_shares_users_on_user_uid (user_uid)\x0AALTER TABLE kronolith_shares_users ADD INDEX index_kronolith_shares_users_on_perm (perm)\x0AALTER TABLE kronolith_shares_users ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_kronolith_shares_users_on_id ON kronolith_shares_users\x0AALTER TABLE kronolith_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_sharesng CHANGE COLUMN share_parents share_parents varchar(4000) DEFAULT NULL\x0A# was text\x0AALTER TABLE kronolith_storage ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_kronolith_storage_on_id on kronolith_storage (id)\x0AALTER TABLE kronolith_storage CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE kronolith_storage DROP INDEX kronolith_vfb_email_idx\x0AALTER TABLE kronolith_storage DROP INDEX kronolith_vfb_owner_idx\x0AALTER TABLE kronolith_storage ADD INDEX index_kronolith_storage_on_vfb_email (vfb_email)\x0AALTER TABLE kronolith_storage ADD INDEX index_kronolith_storage_on_vfb_owner (vfb_owner)\x0AALTER TABLE kronolith_storage ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_kronolith_storage_on_id ON kronolith_storage\x0AALTER TABLE kronolith_storage ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE mnemo_memos CHANGE COLUMN memo_private memo_private int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_memos DROP INDEX mnemo_notepad_idx\x0AALTER TABLE mnemo_memos DROP INDEX mnemo_uid_idx\x0AALTER TABLE mnemo_memos ADD INDEX index_mnemo_memos_on_memo_owner (memo_owner)\x0AALTER TABLE mnemo_memos ADD INDEX index_mnemo_memos_on_memo_uid (memo_uid)\x0AALTER TABLE mnemo_memos ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE mnemo_shares CHANGE COLUMN perm_guest perm_guest int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_shares CHANGE COLUMN perm_creator perm_creator int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_shares CHANGE COLUMN perm_default perm_default int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_shares CHANGE COLUMN share_flags share_flags int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_perm_guest_idx\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_share_owner_idx\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_perm_creator_idx\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_perm_default_idx\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_share_name_idx\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_perm_creator (perm_creator)\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_share_owner (share_owner)\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_share_name (share_name)\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_perm_guest (perm_guest)\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_perm_default (perm_default)\x0AALTER TABLE mnemo_shares ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8\x0AALTER TABLE mnemo_shares_groups CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE mnemo_shares_groups ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_mnemo_shares_groups_on_id on mnemo_shares_groups (id)\x0AALTER TABLE mnemo_shares_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE mnemo_shares_groups DROP INDEX mnemo_shares_groups_group_uid_idx\x0AALTER TABLE mnemo_shares_groups DROP INDEX mnemo_shares_groups_perm_idx\x0AALTER TABLE mnemo_shares_groups DROP INDEX mnemo_shares_groups_share_id_idx\x0AALTER TABLE mnemo_shares_groups ADD INDEX index_mnemo_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE mnemo_shares_groups ADD INDEX index_mnemo_shares_groups_on_share_id (share_id)\x0AALTER TABLE mnemo_shares_groups ADD INDEX index_mnemo_shares_groups_on_perm (perm)\x0AALTER TABLE mnemo_shares_groups ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_mnemo_shares_groups_on_id ON mnemo_shares_groups\x0AALTER TABLE mnemo_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE mnemo_shares_users CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE mnemo_shares_users ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_mnemo_shares_users_on_id on mnemo_shares_users (id)\x0AALTER TABLE mnemo_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE mnemo_shares_users DROP INDEX mnemo_shares_users_user_uid_idx\x0AALTER TABLE mnemo_shares_users DROP INDEX mnemo_shares_users_perm_idx\x0AALTER TABLE mnemo_shares_users DROP INDEX mnemo_shares_users_share_id_idx\x0AALTER TABLE mnemo_shares_users ADD INDEX index_mnemo_shares_users_on_user_uid (user_uid)\x0AALTER TABLE mnemo_shares_users ADD INDEX index_mnemo_shares_users_on_share_id (share_id)\x0AALTER TABLE mnemo_shares_users ADD INDEX index_mnemo_shares_users_on_perm (perm)\x0AALTER TABLE mnemo_shares_users ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_mnemo_shares_users_on_id ON mnemo_shares_users\x0AALTER TABLE mnemo_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE nag_shares CHANGE COLUMN perm_guest perm_guest int(2) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_shares CHANGE COLUMN perm_creator perm_creator int(2) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_shares CHANGE COLUMN perm_default perm_default int(2) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_shares CHANGE COLUMN share_flags share_flags int(2) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_shares DROP INDEX nag_shares_share_owner_idx\x0AALTER TABLE nag_shares DROP INDEX nag_shares_perm_default_idx\x0AALTER TABLE nag_shares DROP INDEX nag_shares_perm_guest_idx\x0AALTER TABLE nag_shares DROP INDEX nag_shares_share_name_idx\x0AALTER TABLE nag_shares DROP INDEX nag_shares_perm_creator_idx\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_share_owner (share_owner)\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_perm_guest (perm_guest)\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_perm_default (perm_default)\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_perm_creator (perm_creator)\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_share_name (share_name)\x0AALTER TABLE nag_shares ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8\x0AALTER TABLE nag_shares_groups CHANGE COLUMN perm perm int(2) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE nag_shares_groups DROP INDEX nag_shares_groups_share_id_idx\x0AALTER TABLE nag_shares_groups DROP INDEX nag_shares_groups_group_uid_idx\x0AALTER TABLE nag_shares_groups DROP INDEX nag_shares_groups_perm_idx\x0AALTER TABLE nag_shares_groups ADD INDEX index_nag_shares_groups_on_perm (perm)\x0AALTER TABLE nag_shares_groups ADD INDEX index_nag_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE nag_shares_groups ADD INDEX index_nag_shares_groups_on_share_id (share_id)\x0AALTER TABLE nag_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE nag_shares_users CHANGE COLUMN perm perm int(2) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE nag_shares_users DROP INDEX nag_shares_users_share_id_idx\x0AALTER TABLE nag_shares_users DROP INDEX nag_shares_users_perm_idx\x0AALTER TABLE nag_shares_users DROP INDEX nag_shares_users_user_uid_idx\x0AALTER TABLE nag_shares_users ADD INDEX index_nag_shares_users_on_perm (perm)\x0AALTER TABLE nag_shares_users ADD INDEX index_nag_shares_users_on_user_uid (user_uid)\x0AALTER TABLE nag_shares_users ADD INDEX index_nag_shares_users_on_share_id (share_id)\x0AALTER TABLE nag_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE nag_tasks CHANGE COLUMN task_private task_private int(1) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_tasks CHANGE COLUMN task_completed task_completed int(1) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_tasks DROP INDEX nag_tasklist_idx\x0AALTER TABLE nag_tasks DROP INDEX nag_uid_idx\x0AALTER TABLE nag_tasks DROP INDEX nag_start_idx\x0AALTER TABLE nag_tasks ADD INDEX index_nag_tasks_on_task_owner (task_owner)\x0AALTER TABLE nag_tasks ADD INDEX index_nag_tasks_on_task_start (task_start)\x0AALTER TABLE nag_tasks ADD INDEX index_nag_tasks_on_task_uid (task_uid)\x0AALTER TABLE nag_tasks ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE turba_objects CHANGE COLUMN object_members object_members text\x0A# was blob\x0AALTER TABLE turba_objects DROP INDEX turba_lastname_idx\x0AALTER TABLE turba_objects DROP INDEX turba_email_idx\x0AALTER TABLE turba_objects DROP INDEX turba_owner_idx\x0AALTER TABLE turba_objects DROP INDEX turba_firstname_idx\x0AALTER TABLE turba_objects ADD INDEX index_turba_objects_on_object_lastname (object_lastname)\x0AALTER TABLE turba_objects ADD INDEX index_turba_objects_on_object_email (object_email)\x0AALTER TABLE turba_objects ADD INDEX index_turba_objects_on_object_firstname (object_firstname)\x0AALTER TABLE turba_objects ADD INDEX index_turba_objects_on_owner_id (owner_id)\x0AALTER TABLE turba_objects ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE turba_shares CHANGE COLUMN perm_guest perm_guest int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE turba_shares CHANGE COLUMN perm_creator perm_creator int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE turba_shares CHANGE COLUMN perm_default perm_default int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE turba_shares CHANGE COLUMN share_flags share_flags int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE turba_shares DROP INDEX turba_shares_share_name_idx\x0AALTER TABLE turba_shares DROP INDEX turba_shares_share_owner_idx\x0AALTER TABLE turba_shares DROP INDEX turba_shares_perm_guest_idx\x0AALTER TABLE turba_shares DROP INDEX turba_shares_perm_creator_idx\x0AALTER TABLE turba_shares DROP INDEX turba_shares_perm_default_idx\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_share_owner (share_owner)\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_perm_guest (perm_guest)\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_share_name (share_name)\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_perm_creator (perm_creator)\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_perm_default (perm_default)\x0AALTER TABLE turba_shares ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8\x0AALTER TABLE turba_shares_groups CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE turba_shares_groups ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_turba_shares_groups_on_id on turba_shares_groups (id)\x0AALTER TABLE turba_shares_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE turba_shares_groups DROP INDEX turba_shares_groups_share_id_idx\x0AALTER TABLE turba_shares_groups DROP INDEX turba_shares_groups_perm_idx\x0AALTER TABLE turba_shares_groups DROP INDEX turba_shares_groups_group_uid_idx\x0AALTER TABLE turba_shares_groups ADD INDEX index_turba_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE turba_shares_groups ADD INDEX index_turba_shares_groups_on_perm (perm)\x0AALTER TABLE turba_shares_groups ADD INDEX index_turba_shares_groups_on_share_id (share_id)\x0AALTER TABLE turba_shares_groups ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_turba_shares_groups_on_id ON turba_shares_groups\x0AALTER TABLE turba_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE turba_shares_users CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE turba_shares_users ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_turba_shares_users_on_id on turba_shares_users (id)\x0AALTER TABLE turba_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE turba_shares_users DROP INDEX turba_shares_users_user_uid_idx\x0AALTER TABLE turba_shares_users DROP INDEX turba_shares_users_perm_idx\x0AALTER TABLE turba_shares_users DROP INDEX turba_shares_users_share_id_idx\x0AALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_perm (perm)\x0AALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_user_uid (user_uid)\x0AALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_share_id (share_id)\x0AALTER TABLE turba_shares_users ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_turba_shares_users_on_id ON turba_shares_users\x0AALTER TABLE turba_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8 at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 299.\x0A') called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 38
        main::catch {...} ('Failed to run the patch, PATCH 1, to horde with with the following errors:\x0A## mysqldiff 0.43\x0A## \x0A## Run on Thu Jul 23 06:27:13 2015\x0A##\x0A## ---   db: horde\x0A## +++   db: horde1148\x0A\x0AALTER TABLE horde_alarms CHANGE COLUMN alarm_uid alarm_uid varchar(255) DEFAULT NULL\x0A# was varchar(250) NOT NULL\x0AALTER TABLE horde_alarms CHANGE COLUMN alarm_dismissed alarm_dismissed int(1) NOT NULL DEFAULT \'0\'\x0A# was tinyint(1) NOT NULL DEFAULT \'0\'\x0AALTER TABLE horde_alarms CHANGE COLUMN alarm_id alarm_id varchar(255) NOT NULL\x0A# was varchar(250) NOT NULL\x0AALTER TABLE horde_alarms ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_horde_alarms_on_id on horde_alarms (id)\x0AALTER TABLE horde_alarms CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE horde_alarms DROP INDEX alarm_snooze_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_end_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_start_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_user_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_id_idx\x0AALTER TABLE horde_alarms DROP INDEX alarm_dismissed_idx\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_end (alarm_end)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_snooze (alarm_snooze)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_start (alarm_start)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_uid (alarm_uid)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_id (alarm_id)\x0AALTER TABLE horde_alarms ADD INDEX index_horde_alarms_on_alarm_dismissed (alarm_dismissed)\x0AALTER TABLE horde_alarms ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_horde_alarms_on_id ON horde_alarms\x0AALTER TABLE horde_alarms ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_cache ENGINE=InnoDB DEFAULT CHARSET=utf8\x0A###----------------------------------------------------------------------------\x0A### BEGIN ERROR: Failed the next statement with error: \x0A#DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'-back_schema_info\' at line 1\x0A# at /usr/local/cpanel/Cpanel/Exception.pm line 151.\x0A#\x09Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x8564e48), HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57\x0A#\x09Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x8564e48), HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/Exception.pm line 72\x0A#\x09Cpanel::Exception::create_raw("Database::Error", "DBD::mysql::db do failed: You have an error in your SQL synta"..., HASH(0x9465b30)) called at /usr/local/cpanel/Cpanel/DBI.pm line 105\x0A#\x09Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x9459414), "DBD::mysql::db do failed: You have an error in your SQL synta"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 93\x0A#\x09Cpanel::DBI::_error_handler("DBD::mysql::db do failed: You have an error in your SQL synta"..., Cpanel::DBI::Mysql::db=HASH(0x9459414), undef) called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280\x0A#\x09eval {...} called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280\x0A#\x09Cpanel::Horde::RepairSchema::_write_patch(Cpanel::Horde::RepairSchema=HASH(0x9450688), "## mysqldiff 0.43\\x{a}## \\x{a}## Run on Thu Jul 23 06:27:13 2015\\x{a}##\\x{a}#"..., "PATCH 1") called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 110\x0A#\x09Cpanel::Horde::RepairSchema::repair_horde_1148_mysql(Cpanel::Horde::RepairSchema=HASH(0x9450688)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 223\x0A#\x09main::check_and_fix_1148_schema(HASH(0x850cc68)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 128\x0A#\x09main::run("main", "--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 34\x0A#\x09main::try {...} () called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 81\x0A#\x09eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 72\x0A#\x09Try::Tiny::try(CODE(0x850c858), Try::Tiny::Catch=REF(0x85f62f8)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 41\x0A#\x09main::_run("--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 45\x0A\x0ADROP TABLE horde_core-back_schema_info\x0A### END ERROR\x0A\x0ADROP TABLE horde_datatree\x0ADROP TABLE horde_datatree_attributes\x0AALTER TABLE horde_groups DROP INDEX group_name\x0AALTER TABLE horde_groups ADD UNIQUE index_horde_groups_on_group_name (group_name)\x0AALTER TABLE horde_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_groups_members DROP INDEX group_uid_idx\x0AALTER TABLE horde_groups_members DROP INDEX user_uid_idx\x0AALTER TABLE horde_groups_members ADD INDEX index_horde_groups_members_on_user_uid (user_uid)\x0AALTER TABLE horde_groups_members ADD INDEX index_horde_groups_members_on_group_uid (group_uid)\x0AALTER TABLE horde_groups_members ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_histories DROP INDEX history_action_idx\x0AALTER TABLE horde_histories DROP INDEX history_ts_idx\x0AALTER TABLE horde_histories DROP INDEX history_uid_idx\x0AALTER TABLE horde_histories ADD INDEX index_horde_histories_on_history_ts (history_ts)\x0AALTER TABLE horde_histories ADD INDEX index_horde_histories_on_history_action (history_action)\x0AALTER TABLE horde_histories ENGINE=InnoDB AUTO_INCREMENT=12473 DEFAULT CHARSET=utf8\x0AALTER TABLE horde_locks CHANGE COLUMN lock_type lock_type smallint(5) unsigned NOT NULL\x0A# was tinyint(3) unsigned NOT NULL\x0AALTER TABLE horde_locks ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_perms DROP INDEX perm_name\x0AALTER TABLE horde_perms ADD UNIQUE index_horde_perms_on_perm_name (perm_name)\x0AALTER TABLE horde_perms ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_prefs CHANGE COLUMN pref_uid pref_uid varchar(255) NOT NULL\x0A# was varchar(200) NOT NULL\x0AALTER TABLE horde_prefs DROP INDEX pref_scope_idx\x0AALTER TABLE horde_prefs DROP INDEX pref_uid_idx\x0AALTER TABLE horde_prefs ADD INDEX index_horde_prefs_on_pref_scope (pref_scope)\x0AALTER TABLE horde_prefs ADD INDEX index_horde_prefs_on_pref_uid (pref_uid)\x0AALTER TABLE horde_prefs ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_sessionhandler CHANGE COLUMN session_lastmodified session_lastmodified int(11) NOT NULL\x0A# was bigint(20) NOT NULL\x0AALTER TABLE horde_sessionhandler DROP INDEX session_lastmodified_idx\x0AALTER TABLE horde_sessionhandler ADD INDEX index_horde_sessionhandler_on_session_lastmodified (session_lastmodified)\x0AALTER TABLE horde_signups CHANGE COLUMN signup_date signup_date int(11) NOT NULL\x0A# was varchar(255) NOT NULL\x0AALTER TABLE horde_signups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_syncml_anchors DROP INDEX syncml_anchors_uid_idx\x0AALTER TABLE horde_syncml_anchors DROP INDEX syncml_anchors_syncpartner_idx\x0AALTER TABLE horde_syncml_anchors DROP INDEX syncml_anchors_db_idx\x0AALTER TABLE horde_syncml_anchors ADD INDEX index_horde_syncml_anchors_on_syncml_uid (syncml_uid)\x0AALTER TABLE horde_syncml_anchors ADD INDEX index_horde_syncml_anchors_on_syncml_syncpartner (syncml_syncpartner)\x0AALTER TABLE horde_syncml_anchors ADD INDEX index_horde_syncml_anchors_on_syncml_db (syncml_db)\x0AALTER TABLE horde_syncml_anchors ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_db_idx\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_cuid_idx\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_suid_idx\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_syncpartner_idx\x0AALTER TABLE horde_syncml_map DROP INDEX syncml_uid_idx\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_syncpartner (syncml_syncpartner)\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_cuid (syncml_cuid)\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_suid (syncml_suid)\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_db (syncml_db)\x0AALTER TABLE horde_syncml_map ADD INDEX index_horde_syncml_map_on_syncml_uid (syncml_uid)\x0AALTER TABLE horde_syncml_map ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_tokens ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE horde_vfs DROP INDEX vfs_path_idx\x0AALTER TABLE horde_vfs DROP INDEX vfs_name_idx\x0AALTER TABLE horde_vfs ADD INDEX index_horde_vfs_on_vfs_name (vfs_name)\x0AALTER TABLE horde_vfs ADD INDEX index_horde_vfs_on_vfs_path (vfs_path)\x0AALTER TABLE horde_vfs ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE imp_sentmail DROP INDEX sentmail_ts_idx\x0AALTER TABLE imp_sentmail DROP INDEX sentmail_success_idx\x0AALTER TABLE imp_sentmail DROP INDEX sentmail_who_idx\x0AALTER TABLE imp_sentmail ADD INDEX index_imp_sentmail_on_sentmail_who (sentmail_who)\x0AALTER TABLE imp_sentmail ADD INDEX index_imp_sentmail_on_sentmail_ts (sentmail_ts)\x0AALTER TABLE imp_sentmail ADD INDEX index_imp_sentmail_on_sentmail_success (sentmail_success)\x0AALTER TABLE imp_sentmail ENGINE=InnoDB DEFAULT CHARSET=utf8\x0A###----------------------------------------------------------------------------\x0A### BEGIN ERROR: Failed the next statement with error: \x0A#DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'(forward_owner))\' at line 1\x0A# at /usr/local/cpanel/Cpanel/Exception.pm line 151.\x0A#\x09Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x9465b94), HASH(0x947a0cc)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57\x0A#\x09Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x9465b94), HASH(0x947a0cc)) called at /usr/local/cpanel/Cpanel/Exception.pm line 72\x0A#\x09Cpanel::Exception::create_raw("Database::Error", "DBD::mysql::db do failed: You have an error in your SQL synta"..., HASH(0x947a0cc)) called at /usr/local/cpanel/Cpanel/DBI.pm line 105\x0A#\x09Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x9459414), "DBD::mysql::db do failed: You have an error in your SQL synta"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 93\x0A#\x09Cpanel::DBI::_error_handler("DBD::mysql::db do failed: You have an error in your SQL synta"..., Cpanel::DBI::Mysql::db=HASH(0x9459414), undef) called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280\x0A#\x09eval {...} called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 280\x0A#\x09Cpanel::Horde::RepairSchema::_write_patch(Cpanel::Horde::RepairSchema=HASH(0x9450688), "## mysqldiff 0.43\\x{a}## \\x{a}## Run on Thu Jul 23 06:27:13 2015\\x{a}##\\x{a}#"..., "PATCH 1") called at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 110\x0A#\x09Cpanel::Horde::RepairSchema::repair_horde_1148_mysql(Cpanel::Horde::RepairSchema=HASH(0x9450688)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 223\x0A#\x09main::check_and_fix_1148_schema(HASH(0x850cc68)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 128\x0A#\x09main::run("main", "--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 34\x0A#\x09main::try {...} () called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 81\x0A#\x09eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 72\x0A#\x09Try::Tiny::try(CODE(0x850c858), Try::Tiny::Catch=REF(0x85f62f8)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 41\x0A#\x09main::_run("--replace-dest-db") called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 45\x0A\x0AALTER TABLE ingo_forwards ADD INDEX ((forward_owner))\x0A### END ERROR\x0A\x0AALTER TABLE ingo_forwards DROP PRIMARY KEY\x0AALTER TABLE ingo_forwards ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_lists DROP INDEX list_idx\x0AALTER TABLE ingo_lists ADD INDEX index_ingo_lists_on_list_owner_and_list_blacklist (list_owner,list_blacklist)\x0AALTER TABLE ingo_lists ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_rules DROP INDEX rule_owner_idx\x0AALTER TABLE ingo_rules ADD INDEX index_ingo_rules_on_rule_owner (rule_owner)\x0AALTER TABLE ingo_rules ENGINE=InnoDB AUTO_INCREMENT=493 DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_shares CHANGE COLUMN perm_guest perm_guest int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE ingo_shares CHANGE COLUMN perm_creator perm_creator int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE ingo_shares CHANGE COLUMN perm_default perm_default int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE ingo_shares CHANGE COLUMN share_flags share_flags int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_share_owner_idx\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_perm_creator_idx\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_share_name_idx\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_perm_default_idx\x0AALTER TABLE ingo_shares DROP INDEX ingo_shares_perm_guest_idx\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_perm_guest (perm_guest)\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_share_name (share_name)\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_perm_default (perm_default)\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_share_owner (share_owner)\x0AALTER TABLE ingo_shares ADD INDEX index_ingo_shares_on_perm_creator (perm_creator)\x0AALTER TABLE ingo_shares ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_shares_groups CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE ingo_shares_groups ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_ingo_shares_groups_on_id on ingo_shares_groups (id)\x0AALTER TABLE ingo_shares_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE ingo_shares_groups DROP INDEX ingo_shares_groups_share_id_idx\x0AALTER TABLE ingo_shares_groups DROP INDEX ingo_shares_groups_group_uid_idx\x0AALTER TABLE ingo_shares_groups DROP INDEX ingo_shares_groups_perm_idx\x0AALTER TABLE ingo_shares_groups ADD INDEX index_ingo_shares_groups_on_share_id (share_id)\x0AALTER TABLE ingo_shares_groups ADD INDEX index_ingo_shares_groups_on_perm (perm)\x0AALTER TABLE ingo_shares_groups ADD INDEX index_ingo_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE ingo_shares_groups ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_ingo_shares_groups_on_id ON ingo_shares_groups\x0AALTER TABLE ingo_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_shares_users CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE ingo_shares_users ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_ingo_shares_users_on_id on ingo_shares_users (id)\x0AALTER TABLE ingo_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE ingo_shares_users DROP INDEX ingo_shares_users_user_uid_idx\x0AALTER TABLE ingo_shares_users DROP INDEX ingo_shares_users_share_id_idx\x0AALTER TABLE ingo_shares_users DROP INDEX ingo_shares_users_perm_idx\x0AALTER TABLE ingo_shares_users ADD INDEX index_ingo_shares_users_on_perm (perm)\x0AALTER TABLE ingo_shares_users ADD INDEX index_ingo_shares_users_on_share_id (share_id)\x0AALTER TABLE ingo_shares_users ADD INDEX index_ingo_shares_users_on_user_uid (user_uid)\x0AALTER TABLE ingo_shares_users ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_ingo_shares_users_on_id ON ingo_shares_users\x0AALTER TABLE ingo_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_spam ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE ingo_vacations ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_events CHANGE COLUMN event_baseid event_baseid varchar(255) DEFAULT \'\'\x0A# was varchar(255) DEFAULT NULL\x0AALTER TABLE kronolith_events CHANGE COLUMN event_recurdays event_recurdays int(11) DEFAULT NULL\x0A# was smallint(6) DEFAULT NULL\x0AALTER TABLE kronolith_events CHANGE COLUMN event_modified event_modified int(11) DEFAULT \'0\'\x0A# was int(11) NOT NULL\x0AALTER TABLE kronolith_events CHANGE COLUMN event_recurtype event_recurtype int(11) DEFAULT \'0\'\x0A# was smallint(6) DEFAULT \'0\'\x0AALTER TABLE kronolith_events CHANGE COLUMN event_private event_private int(11) NOT NULL DEFAULT \'0\'\x0A# was tinyint(4) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_events CHANGE COLUMN event_recurinterval event_recurinterval int(11) DEFAULT NULL\x0A# was smallint(6) DEFAULT NULL\x0AALTER TABLE kronolith_events DROP INDEX kronolith_calendar_idx\x0AALTER TABLE kronolith_events DROP INDEX kronolith_uid_idx\x0AALTER TABLE kronolith_events ADD INDEX index_kronolith_events_on_calendar_id (calendar_id)\x0AALTER TABLE kronolith_events ADD INDEX index_kronolith_events_on_event_uid (event_uid)\x0AALTER TABLE kronolith_events ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_shares CHANGE COLUMN perm_guest perm_guest int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_shares CHANGE COLUMN perm_creator perm_creator int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_shares CHANGE COLUMN perm_default perm_default int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_shares CHANGE COLUMN share_parents share_parents varchar(4000) DEFAULT NULL\x0A# was text\x0AALTER TABLE kronolith_shares CHANGE COLUMN share_flags share_flags int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_perm_creator_idx\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_share_owner_idx\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_share_name_idx\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_perm_guest_idx\x0AALTER TABLE kronolith_shares DROP INDEX kronolith_shares_perm_default_idx\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_share_owner (share_owner)\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_share_name (share_name)\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_perm_guest (perm_guest)\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_perm_default (perm_default)\x0AALTER TABLE kronolith_shares ADD INDEX index_kronolith_shares_on_perm_creator (perm_creator)\x0AALTER TABLE kronolith_shares ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_shares_groups CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE kronolith_shares_groups ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_kronolith_shares_groups_on_id on kronolith_shares_groups (id)\x0AALTER TABLE kronolith_shares_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE kronolith_shares_groups DROP INDEX kronolith_shares_groups_group_uid_idx\x0AALTER TABLE kronolith_shares_groups DROP INDEX kronolith_shares_groups_share_id_idx\x0AALTER TABLE kronolith_shares_groups DROP INDEX kronolith_shares_groups_perm_idx\x0AALTER TABLE kronolith_shares_groups ADD INDEX index_kronolith_shares_groups_on_perm (perm)\x0AALTER TABLE kronolith_shares_groups ADD INDEX index_kronolith_shares_groups_on_share_id (share_id)\x0AALTER TABLE kronolith_shares_groups ADD INDEX index_kronolith_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE kronolith_shares_groups ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_kronolith_shares_groups_on_id ON kronolith_shares_groups\x0AALTER TABLE kronolith_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_shares_users CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE kronolith_shares_users ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_kronolith_shares_users_on_id on kronolith_shares_users (id)\x0AALTER TABLE kronolith_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE kronolith_shares_users DROP INDEX kronolith_shares_users_share_id_idx\x0AALTER TABLE kronolith_shares_users DROP INDEX kronolith_shares_users_perm_idx\x0AALTER TABLE kronolith_shares_users DROP INDEX kronolith_shares_users_user_uid_idx\x0AALTER TABLE kronolith_shares_users ADD INDEX index_kronolith_shares_users_on_share_id (share_id)\x0AALTER TABLE kronolith_shares_users ADD INDEX index_kronolith_shares_users_on_user_uid (user_uid)\x0AALTER TABLE kronolith_shares_users ADD INDEX index_kronolith_shares_users_on_perm (perm)\x0AALTER TABLE kronolith_shares_users ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_kronolith_shares_users_on_id ON kronolith_shares_users\x0AALTER TABLE kronolith_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE kronolith_sharesng CHANGE COLUMN share_parents share_parents varchar(4000) DEFAULT NULL\x0A# was text\x0AALTER TABLE kronolith_storage ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_kronolith_storage_on_id on kronolith_storage (id)\x0AALTER TABLE kronolith_storage CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE kronolith_storage DROP INDEX kronolith_vfb_email_idx\x0AALTER TABLE kronolith_storage DROP INDEX kronolith_vfb_owner_idx\x0AALTER TABLE kronolith_storage ADD INDEX index_kronolith_storage_on_vfb_email (vfb_email)\x0AALTER TABLE kronolith_storage ADD INDEX index_kronolith_storage_on_vfb_owner (vfb_owner)\x0AALTER TABLE kronolith_storage ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_kronolith_storage_on_id ON kronolith_storage\x0AALTER TABLE kronolith_storage ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE mnemo_memos CHANGE COLUMN memo_private memo_private int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_memos DROP INDEX mnemo_notepad_idx\x0AALTER TABLE mnemo_memos DROP INDEX mnemo_uid_idx\x0AALTER TABLE mnemo_memos ADD INDEX index_mnemo_memos_on_memo_owner (memo_owner)\x0AALTER TABLE mnemo_memos ADD INDEX index_mnemo_memos_on_memo_uid (memo_uid)\x0AALTER TABLE mnemo_memos ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE mnemo_shares CHANGE COLUMN perm_guest perm_guest int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_shares CHANGE COLUMN perm_creator perm_creator int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_shares CHANGE COLUMN perm_default perm_default int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_shares CHANGE COLUMN share_flags share_flags int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_perm_guest_idx\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_share_owner_idx\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_perm_creator_idx\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_perm_default_idx\x0AALTER TABLE mnemo_shares DROP INDEX mnemo_shares_share_name_idx\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_perm_creator (perm_creator)\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_share_owner (share_owner)\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_share_name (share_name)\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_perm_guest (perm_guest)\x0AALTER TABLE mnemo_shares ADD INDEX index_mnemo_shares_on_perm_default (perm_default)\x0AALTER TABLE mnemo_shares ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8\x0AALTER TABLE mnemo_shares_groups CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE mnemo_shares_groups ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_mnemo_shares_groups_on_id on mnemo_shares_groups (id)\x0AALTER TABLE mnemo_shares_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE mnemo_shares_groups DROP INDEX mnemo_shares_groups_group_uid_idx\x0AALTER TABLE mnemo_shares_groups DROP INDEX mnemo_shares_groups_perm_idx\x0AALTER TABLE mnemo_shares_groups DROP INDEX mnemo_shares_groups_share_id_idx\x0AALTER TABLE mnemo_shares_groups ADD INDEX index_mnemo_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE mnemo_shares_groups ADD INDEX index_mnemo_shares_groups_on_share_id (share_id)\x0AALTER TABLE mnemo_shares_groups ADD INDEX index_mnemo_shares_groups_on_perm (perm)\x0AALTER TABLE mnemo_shares_groups ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_mnemo_shares_groups_on_id ON mnemo_shares_groups\x0AALTER TABLE mnemo_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE mnemo_shares_users CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE mnemo_shares_users ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_mnemo_shares_users_on_id on mnemo_shares_users (id)\x0AALTER TABLE mnemo_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE mnemo_shares_users DROP INDEX mnemo_shares_users_user_uid_idx\x0AALTER TABLE mnemo_shares_users DROP INDEX mnemo_shares_users_perm_idx\x0AALTER TABLE mnemo_shares_users DROP INDEX mnemo_shares_users_share_id_idx\x0AALTER TABLE mnemo_shares_users ADD INDEX index_mnemo_shares_users_on_user_uid (user_uid)\x0AALTER TABLE mnemo_shares_users ADD INDEX index_mnemo_shares_users_on_share_id (share_id)\x0AALTER TABLE mnemo_shares_users ADD INDEX index_mnemo_shares_users_on_perm (perm)\x0AALTER TABLE mnemo_shares_users ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_mnemo_shares_users_on_id ON mnemo_shares_users\x0AALTER TABLE mnemo_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE nag_shares CHANGE COLUMN perm_guest perm_guest int(2) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_shares CHANGE COLUMN perm_creator perm_creator int(2) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_shares CHANGE COLUMN perm_default perm_default int(2) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_shares CHANGE COLUMN share_flags share_flags int(2) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_shares DROP INDEX nag_shares_share_owner_idx\x0AALTER TABLE nag_shares DROP INDEX nag_shares_perm_default_idx\x0AALTER TABLE nag_shares DROP INDEX nag_shares_perm_guest_idx\x0AALTER TABLE nag_shares DROP INDEX nag_shares_share_name_idx\x0AALTER TABLE nag_shares DROP INDEX nag_shares_perm_creator_idx\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_share_owner (share_owner)\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_perm_guest (perm_guest)\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_perm_default (perm_default)\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_perm_creator (perm_creator)\x0AALTER TABLE nag_shares ADD INDEX index_nag_shares_on_share_name (share_name)\x0AALTER TABLE nag_shares ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8\x0AALTER TABLE nag_shares_groups CHANGE COLUMN perm perm int(2) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE nag_shares_groups DROP INDEX nag_shares_groups_share_id_idx\x0AALTER TABLE nag_shares_groups DROP INDEX nag_shares_groups_group_uid_idx\x0AALTER TABLE nag_shares_groups DROP INDEX nag_shares_groups_perm_idx\x0AALTER TABLE nag_shares_groups ADD INDEX index_nag_shares_groups_on_perm (perm)\x0AALTER TABLE nag_shares_groups ADD INDEX index_nag_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE nag_shares_groups ADD INDEX index_nag_shares_groups_on_share_id (share_id)\x0AALTER TABLE nag_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE nag_shares_users CHANGE COLUMN perm perm int(2) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE nag_shares_users DROP INDEX nag_shares_users_share_id_idx\x0AALTER TABLE nag_shares_users DROP INDEX nag_shares_users_perm_idx\x0AALTER TABLE nag_shares_users DROP INDEX nag_shares_users_user_uid_idx\x0AALTER TABLE nag_shares_users ADD INDEX index_nag_shares_users_on_perm (perm)\x0AALTER TABLE nag_shares_users ADD INDEX index_nag_shares_users_on_user_uid (user_uid)\x0AALTER TABLE nag_shares_users ADD INDEX index_nag_shares_users_on_share_id (share_id)\x0AALTER TABLE nag_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE nag_tasks CHANGE COLUMN task_private task_private int(1) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_tasks CHANGE COLUMN task_completed task_completed int(1) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE nag_tasks DROP INDEX nag_tasklist_idx\x0AALTER TABLE nag_tasks DROP INDEX nag_uid_idx\x0AALTER TABLE nag_tasks DROP INDEX nag_start_idx\x0AALTER TABLE nag_tasks ADD INDEX index_nag_tasks_on_task_owner (task_owner)\x0AALTER TABLE nag_tasks ADD INDEX index_nag_tasks_on_task_start (task_start)\x0AALTER TABLE nag_tasks ADD INDEX index_nag_tasks_on_task_uid (task_uid)\x0AALTER TABLE nag_tasks ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE turba_objects CHANGE COLUMN object_members object_members text\x0A# was blob\x0AALTER TABLE turba_objects DROP INDEX turba_lastname_idx\x0AALTER TABLE turba_objects DROP INDEX turba_email_idx\x0AALTER TABLE turba_objects DROP INDEX turba_owner_idx\x0AALTER TABLE turba_objects DROP INDEX turba_firstname_idx\x0AALTER TABLE turba_objects ADD INDEX index_turba_objects_on_object_lastname (object_lastname)\x0AALTER TABLE turba_objects ADD INDEX index_turba_objects_on_object_email (object_email)\x0AALTER TABLE turba_objects ADD INDEX index_turba_objects_on_object_firstname (object_firstname)\x0AALTER TABLE turba_objects ADD INDEX index_turba_objects_on_owner_id (owner_id)\x0AALTER TABLE turba_objects ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE turba_shares CHANGE COLUMN perm_guest perm_guest int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE turba_shares CHANGE COLUMN perm_creator perm_creator int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE turba_shares CHANGE COLUMN perm_default perm_default int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE turba_shares CHANGE COLUMN share_flags share_flags int(11) NOT NULL DEFAULT \'0\'\x0A# was smallint(6) NOT NULL DEFAULT \'0\'\x0AALTER TABLE turba_shares DROP INDEX turba_shares_share_name_idx\x0AALTER TABLE turba_shares DROP INDEX turba_shares_share_owner_idx\x0AALTER TABLE turba_shares DROP INDEX turba_shares_perm_guest_idx\x0AALTER TABLE turba_shares DROP INDEX turba_shares_perm_creator_idx\x0AALTER TABLE turba_shares DROP INDEX turba_shares_perm_default_idx\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_share_owner (share_owner)\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_perm_guest (perm_guest)\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_share_name (share_name)\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_perm_creator (perm_creator)\x0AALTER TABLE turba_shares ADD INDEX index_turba_shares_on_perm_default (perm_default)\x0AALTER TABLE turba_shares ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8\x0AALTER TABLE turba_shares_groups CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE turba_shares_groups ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_turba_shares_groups_on_id on turba_shares_groups (id)\x0AALTER TABLE turba_shares_groups CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE turba_shares_groups DROP INDEX turba_shares_groups_share_id_idx\x0AALTER TABLE turba_shares_groups DROP INDEX turba_shares_groups_perm_idx\x0AALTER TABLE turba_shares_groups DROP INDEX turba_shares_groups_group_uid_idx\x0AALTER TABLE turba_shares_groups ADD INDEX index_turba_shares_groups_on_group_uid (group_uid)\x0AALTER TABLE turba_shares_groups ADD INDEX index_turba_shares_groups_on_perm (perm)\x0AALTER TABLE turba_shares_groups ADD INDEX index_turba_shares_groups_on_share_id (share_id)\x0AALTER TABLE turba_shares_groups ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_turba_shares_groups_on_id ON turba_shares_groups\x0AALTER TABLE turba_shares_groups ENGINE=InnoDB DEFAULT CHARSET=utf8\x0AALTER TABLE turba_shares_users CHANGE COLUMN perm perm int(11) NOT NULL\x0A# was smallint(6) NOT NULL\x0AALTER TABLE turba_shares_users ADD COLUMN id int(10) unsigned NOT NULL\x0ACREATE INDEX tmp_turba_shares_users_on_id on turba_shares_users (id)\x0AALTER TABLE turba_shares_users CHANGE COLUMN id id int(10) unsigned NOT NULL AUTO_INCREMENT\x0AALTER TABLE turba_shares_users DROP INDEX turba_shares_users_user_uid_idx\x0AALTER TABLE turba_shares_users DROP INDEX turba_shares_users_perm_idx\x0AALTER TABLE turba_shares_users DROP INDEX turba_shares_users_share_id_idx\x0AALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_perm (perm)\x0AALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_user_uid (user_uid)\x0AALTER TABLE turba_shares_users ADD INDEX index_turba_shares_users_on_share_id (share_id)\x0AALTER TABLE turba_shares_users ADD PRIMARY KEY (id)\x0ADROP INDEX tmp_turba_shares_users_on_id ON turba_shares_users\x0AALTER TABLE turba_shares_users ENGINE=InnoDB DEFAULT CHARSET=utf8 at /usr/local/cpanel/Cpanel/Horde/RepairSchema.pm line 299.\x0A') called at /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/Try/Tiny.pm line 104
        Try::Tiny::try(CODE(0x850c858), Try::Tiny::Catch=REF(0x85f62f8)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 41
        main::_run('--replace-dest-db') called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 45
    
     
  2. lorio

    lorio Well-Known Member

    Joined:
    Feb 25, 2004
    Messages:
    243
    Likes Received:
    3
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    There seem to be many converting problems with horde from MySQL to sqlite. Unusual for the stable branch.

    I got only empty sqlite databases on all accounts on all servers.
    Trying to convert every acount via console didn't worked either.

    ends with a "Recieved SIGPIPE while converting data for <SNIPforcpanelaccountname>"

    The first error in the logfile of the first mysql->sqlite converting via upcp was this

    Trying to to the complete converting via console
    didn't worked either.

    When the first conversion via ucpcp was applied the logfile shows

    The "The horde database schema does not match the pristine 11.48 horde schema. Attempting to repair it. " looks suspicious to me.
     
    #2 lorio, Jul 25, 2015
    Last edited: Jul 25, 2015
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you let us know if the issue was addressed with internal case CPANEL-411? It's included as of cPanel version
    11.50.0.29:

    Fixed case CPANEL-411: Horde conversion "Failed to run patch" error.

    Thank you.
     
Loading...

Share This Page