Upgrading from 6.3.99 > 6.4.247

[juicetoon]

Upgrade output will be logged into: log/upgrade/20240201_063619.log

Failed to disable 'innodb_strict_mode': SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
Skipping module customfields because it's not available.
Skipping module groups because it's not available.
Skipping module members because it's not available.
Skipping module modules because it's not available.
Skipping module receipts because it's not available.
Skipping module search because it's not available.
Skipping module users because it's not available.
Skipping module links because it's not available.
[legacy/sync] Excuting query: ALTER TABLE `sync_addressbook_user` DROP INDEX `user_id`;
Error: Exception in /var/www/contact/go/core/Installer.php at line 646: 42S02: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'groupofficecom.sync_addressbook_user' doesn't exist
Query: ALTER TABLE `sync_addressbook_user` DROP INDEX `user_id`;
Package: legacy
Module: sync
Module installed version: 43
Module source version: 44
ABORTING: Please contact support

Running into this error when upgrading from the latest release of 6.3 to the latest release of 6.4.

Tried manually disabling 'innodb_strict_mode' with no luck. Thanks in advance!

[michalcharvat]

Well it looks like there are two errors - one is strict mode - not sure how did you disable it - and second is missing sync_addressbook_user. You have two options - disable that module in database or recreate that table if that fix your problem. 6.3/6.4 is far away :) use GO 6.3 create statement from /modules/sync/install/install.sql and let me know whats the next problem