Another issue on migrating to 6.3 from 6.2

Having trouble installing Group-Office? No worries. Help is on the way.

Moderator: Developers

relocation
Posts: 1
Joined: Tue Jul 03, 2018 1:12 pm

Another issue on migrating to 6.3 from 6.2

Postby relocation » Fri Nov 23, 2018 4:59 pm

Hello,

I'm currently trying to migrate my GO 6.2.107 installation to 6.3.53 PHP 7.0 version. I am using a DiskStation with the WebStation, PHP7.0, MariaDB10 and Apache2.4 as services. When I'm performing the upgrade either one of the following errors show up:

For the first error I duplicated the existing database and started the upgrade.
Upgrading Group-Office
DROP TABLE IF EXISTS `go_mail_counter`;
Converting ab_addressbooks to utf8mb4
Converting ab_addresslist_companies to utf8mb4
Converting ab_addresslist_contacts to utf8mb4
Converting ab_addresslists to utf8mb4
Converting ab_companies to utf8mb4
Converting ab_contacts to utf8mb4
Converting ab_contacts_vcard_props to utf8mb4
Converting ab_default_email_account_templates to utf8mb4
Converting ab_default_email_templates to utf8mb4
Converting ab_email_templates to utf8mb4
Converting ab_search_queries to utf8mb4
Converting ab_sent_mailing_companies to utf8mb4
Converting ab_sent_mailing_contacts to utf8mb4
Converting ab_sent_mailings to utf8mb4
Converting ab_settings to utf8mb4
Converting bm_bookmarks to utf8mb4
Converting bm_categories to utf8mb4
Converting cal_calendar_user_colors to utf8mb4
Converting cal_calendars to utf8mb4
Converting cal_categories to utf8mb4
Converting cal_events to utf8mb4
Converting cal_events_declined to utf8mb4
Converting cal_exceptions to utf8mb4
Converting cal_group_admins to utf8mb4
Converting cal_groups to utf8mb4
Converting cal_participants to utf8mb4
Converting cal_settings to utf8mb4
Converting cal_views to utf8mb4
Converting cal_views_calendars to utf8mb4
Converting cal_visible_tasklists to utf8mb4
Converting cf_ab_companies to utf8mb4
Converting cf_ab_contacts to utf8mb4
Converting cf_blocks to utf8mb4
Converting cf_cal_calendars to utf8mb4
Converting cf_cal_events to utf8mb4
Converting cf_categories to utf8mb4
Converting cf_disable_categories to utf8mb4
Converting cf_enabled_blocks to utf8mb4
Converting cf_enabled_categories to utf8mb4
Converting cf_fields to utf8mb4
Converting cf_fs_files to utf8mb4
Converting cf_fs_folders to utf8mb4
Converting cf_go_users to utf8mb4
Converting cf_no_notes to utf8mb4
Converting cf_select_options to utf8mb4
Converting cf_select_tree_options to utf8mb4
Converting cf_site_content to utf8mb4
Converting cf_site_sites to utf8mb4
Converting cf_ta_tasks to utf8mb4
Converting cf_ti_tickets to utf8mb4
Converting cf_tree_select_options to utf8mb4
Converting co_categories to utf8mb4
Converting co_comments to utf8mb4
Converting dav_events to utf8mb4
Converting dav_tasks to utf8mb4
Converting em_accounts to utf8mb4
Converting em_accounts_collapsed to utf8mb4
Converting em_accounts_sort to utf8mb4
Converting em_aliases to utf8mb4
Converting em_contacts_last_mail_times to utf8mb4
Converting em_filters to utf8mb4
Converting em_folders to utf8mb4
Converting em_folders_expanded to utf8mb4
Converting em_labels to utf8mb4
Converting em_links to utf8mb4
Converting em_messages_cache to utf8mb4
Converting em_portlet_folders to utf8mb4
Converting emp_folders to utf8mb4
Converting fav_addressbook to utf8mb4
Converting fav_calendar to utf8mb4
Converting fav_tasklist to utf8mb4
Converting fs_bookmarks to utf8mb4
Converting fs_filehandlers to utf8mb4
Converting fs_files to utf8mb4
Converting fs_folder_pref to utf8mb4
Converting fs_folders to utf8mb4
Converting fs_new_files to utf8mb4
Converting fs_notification_messages to utf8mb4
Converting fs_notifications to utf8mb4
Converting fs_shared_cache to utf8mb4
Converting fs_shared_root_folders to utf8mb4
Converting fs_status_history to utf8mb4
Converting fs_statuses to utf8mb4
Converting fs_templates to utf8mb4
Converting fs_versions to utf8mb4
Converting go_acl to utf8mb4
Converting go_acl_items to utf8mb4
Converting go_address_format to utf8mb4
Converting go_advanced_searches to utf8mb4
Converting go_cache to utf8mb4
Converting go_cf_setting_tabs to utf8mb4
Converting go_clients to utf8mb4
Converting go_countries to utf8mb4
Converting go_cron to utf8mb4
Converting go_cron_groups to utf8mb4
Converting go_cron_users to utf8mb4
Converting go_db_sequence to utf8mb4
Converting go_groups to utf8mb4
Converting go_holidays to utf8mb4
Converting go_link_descriptions to utf8mb4
Converting go_link_folders to utf8mb4
Converting go_links_ab_addresslists to utf8mb4
Converting go_links_ab_companies to utf8mb4
Converting go_links_ab_contacts to utf8mb4
Converting go_links_cal_events to utf8mb4
Converting go_links_em_links to utf8mb4
Converting go_links_fs_files to utf8mb4
Converting go_links_fs_folders to utf8mb4
Converting go_links_go_users to utf8mb4
Converting go_links_no_notes to utf8mb4
Converting go_links_ta_tasks to utf8mb4
Converting go_links_ti_tickets to utf8mb4
Converting go_log to utf8mb4
Converting go_model_types to utf8mb4
Converting go_modules to utf8mb4
Converting go_reminders to utf8mb4
Converting go_reminders_users to utf8mb4
Converting go_saved_exports to utf8mb4
Converting go_saved_search_queries to utf8mb4
Converting go_search_cache to utf8mb4
Converting go_search_sync to utf8mb4
Converting go_settings to utf8mb4
Converting go_state to utf8mb4
Converting go_users to utf8mb4
Converting go_users_groups to utf8mb4
Converting go_working_weeks to utf8mb4
Converting ld_credit_types to utf8mb4
Converting ld_credits to utf8mb4
Converting ld_leave_days to utf8mb4
Converting ld_year_credits to utf8mb4
Converting no_categories to utf8mb4
Converting no_notes to utf8mb4
Converting pr2_default_resources to utf8mb4
Converting pr2_employees to utf8mb4
Converting pr2_expenses to utf8mb4
Converting pr2_hours to utf8mb4
Converting pr2_income to utf8mb4
Converting pr2_portlet_statuses to utf8mb4
Converting pr2_projects to utf8mb4
Converting pr2_resources to utf8mb4
Converting pr2_standard_tasks to utf8mb4
Converting pr2_statuses to utf8mb4
Converting pr2_tasks to utf8mb4
Converting pr2_templates to utf8mb4
Converting pr2_templates_events to utf8mb4
Converting pr2_timers to utf8mb4
Converting pr2_types to utf8mb4
Converting site_menu to utf8mb4
Converting site_menu_item to utf8mb4
Converting site_multifile_files to utf8mb4
Converting smi_certs to utf8mb4
Converting smi_pkcs12 to utf8mb4
Converting su_announcements to utf8mb4
Converting su_latest_read_announcement_records to utf8mb4
Converting su_notes to utf8mb4
Converting su_rss_feeds to utf8mb4
Converting su_visible_calendars to utf8mb4
Converting su_visible_lists to utf8mb4
Converting sync_addressbook_user to utf8mb4
Converting sync_calendar_user to utf8mb4
Converting sync_devices to utf8mb4
Converting sync_note_categories_user to utf8mb4
Converting sync_settings to utf8mb4
Converting sync_tasklist_user to utf8mb4
Converting ta_categories to utf8mb4
Converting ta_portlet_tasklists to utf8mb4
Converting ta_settings to utf8mb4
Converting ta_tasklists to utf8mb4
Converting ta_tasks to utf8mb4
Converting ti_groups to utf8mb4
Converting ti_messages to utf8mb4
Converting ti_rates to utf8mb4
Converting ti_settings to utf8mb4
Converting ti_statuses to utf8mb4
Converting ti_templates to utf8mb4
Converting ti_tickets to utf8mb4
Converting ti_types to utf8mb4
Converting zpa_devices to utf8mb4
UPDATE go_settings SET value=0 where name = 'version';
ALTER TABLE `go_modules` ADD `package` VARCHAR(100) NULL DEFAULT NULL AFTER `id`;
ALTER TABLE `go_modules` CHANGE `id` `id` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
RENAME TABLE `go_modules` TO `core_module`;
ALTER TABLE `core_module` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `core_module` CHANGE `id` `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE `core_module` DROP PRIMARY KEY;
ERROR: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `PRIMARY`; check that it exists Query ALTER TABLE `core_module` DROP PRIMARY KEY;ERROR: A fatal upgrade error occurred. You will not be able to continue upgrading this database! Please report this error message.
For the second error I used the existing, up-to-date, database.
Before this one pops up, the diskstations returns a 500 error page. After re-starting the installation this error shows up:
Upgrading Group-Office
Skipping module users because it's not available.
Excuting query: update core_module set package='community', version=0 where name='notes'
legacy/notes updated from 27 to 28
Error: Invalid column name 'clientName'. Not a column of any table: core_entity

#0 /volume1/web/groupoffice/go/core/db/QueryBuilder.php(363): go\core\db\QueryBuilder->buildColumn(Array, '')
#1 /volume1/web/groupoffice/go/core/db/QueryBuilder.php(342): go\core\db\QueryBuilder->buildCondition(Array, '')
#2 /volume1/web/groupoffice/go/core/db/QueryBuilder.php(241): go\core\db\QueryBuilder->buildWhere(Array, '')
#3 /volume1/web/groupoffice/go/core/db/Connection.php(369): go\core\db\QueryBuilder->buildSelect(Object(go\core\db\Query))
#4 /volume1/web/groupoffice/go/core/db/Query.php(386): go\core\db\Connection->select(Object(go\core\db\Query))
#5 /volume1/web/groupoffice/go/core/db/Query.php(401): go\core\db\Query->execute()
#6 /volume1/web/groupoffice/go/core/orm/EntityType.php(98): go\core\db\Query->single()
#7 /volume1/web/groupoffice/go/core/orm/Entity.php(284): go\core\orm\EntityType::findByClassName('go\\modules\\core...')
#8 /volume1/web/groupoffice/go/core/jmap/Entity.php(56): go\core\orm\Entity::getType()
#9 /volume1/web/groupoffice/go/core/acl/model/AclEntity.php(53): go\core\jmap\Entity->internalSave()
#10 /volume1/web/groupoffice/go/core/orm/Entity.php(135): go\core\acl\model\AclEntity->internalSave()
#11 /volume1/web/groupoffice/install/upgrade.php(286): go\core\orm\Entity->save()
#12 /volume1/web/groupoffice/install/upgrade.php(307): upgrade()
#13 {main}
I already set the max execution time higher in the php.ini. I also did a database check in my 6.2.107.

Can anybody help me?

Who is online

Users browsing this forum: No registered users and 2 guests