Skip to main content

Horde upgrade totally failed, all settings gone

ggouweloos
Hi, there was an automatic update a couple of hours ago, the Horde update failed:
[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:
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

Comments

2 comments

Date Votes
  • lorio
    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. /usr/local/cpanel/3rdparty/bin/perl -MCpanel::Horde::MySQLToSQLite -e 'Cpanel::Horde::MySQLToSQLite->new->convert_user("cpanelaccountname")'
    ends with a "Recieved SIGPIPE while converting data for " The first error in the logfile of the first mysql->sqlite converting via upcp was this ### 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 '(forward_owner))' at line 1 # at /usr/local/cpanel/Cpanel/Exception.pm line 151. # Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x2368470), HASH(0x3d9b7e8)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57 # Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x2368470), HASH(0x3d9b7e8)) 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(0x3d9b7e8)) called at /usr/local/cpanel/Cpanel/DBI.pm line 105 # Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x3d98f80), "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(0x3d98f80), 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(0x3d7b0c0), "## mysqldiff 0.43\x{a}## \x{a}## Run on Fri Jul 24 23:07:32 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(0x3d7b0c0)) called at /usr/local/cpanel/scripts/horde_mysqltosqlite line 223 # main::check_and_fix_1148_schema(HASH(0x2300d90)) 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/lib64/perl5/cpanel_lib/Try/Tiny.pm line 81 # eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/Try/Tiny.pm line 72 # Try::Tiny::try(CODE(0x3cf9a58), Try::Tiny::Catch=REF(0x247f6e8)) 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 ALTER TABLE ingo_forwards ADD INDEX ((forward_owner)) ### END ERROR
    Trying to to the complete converting via console /scripts/horde_mysqltosqlite
    didn't worked either. When the first conversion via ucpcp was applied the logfile shows [horde_mysqltosqlite] Backing up the pre-11.50 MySQL Horde database. [horde_mysqltosqlite] Backup of the pre-11.50 MySQL Horde database. The backup is available at: /var/cpanel/horde/horde.backup.sql.final [horde_mysqltosqlite] The horde database schema does not match the pristine 11.48 horde schema. Attempting to repair it. [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:
    The "The horde database schema does not match the pristine 11.48 horde schema. Attempting to repair it. " looks suspicious to me.
    0
  • cPanelMichael
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post