Hi,
We are having issues while we are upgrading to 8.0.0 from 7.9.4 onsite instance.
Here is our stack
PHP Version 7.1
Mysql Version - 5.7.5
Elastic server version -5.6.11
Apache - 2.4.8
Php Modules Installed
[PHP Modules]
bcmath
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
ftp
gd
gettext
hash
iconv
imap
intl
json
libxml
mbstring
mcrypt
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib
When we are in the process of Upgrading, we get the following error in Sugarcrm.log
Fri Sep 7 10:33:51 2018 [18443][a38f72dc-2085-e9bf-7043-535789b2c38a][FATAL] Query Failed: ALTER TABLE acl_actions ADD INDEX idx_del_category_name_acltype_aclaccess (deleted,category,name,acltype,aclaccess): MySQL error 1071: Specified key was too long; max key length is 1000 bytes
Fri Sep 7 10:34:01 2018 [21026][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone="UTC" in php.ini!
Fri Sep 7 10:34:01 2018 [21026][1][FATAL] An exception occurred while executing 'INSERT INTO audit_events (id, type, parent_id, module_name, source, data, date_created) VALUES (?, ?, ?, ?, ?, ?, ?)' with params ["89183738-b289-11e8-81e1-427017e2a9f9", "update", "8917f638-b289-11e8-ba1b-427017e2a9f9", "SchedulersJobs", "null", "[{\"field_name\":\"assigned_user_id\",\"data_type\":\"id\",\"before\":null,\"after\":\"1\"}]", "2018-09-07 10:34:01"]:
Table 'crm.audit_events' doesn't exist
Fri Sep 7 10:34:01 2018 [21026][1][FATAL] An exception occurred while executing 'SELECT outbound_email.id, outbound_email.name, outbound_email.type, outbound_email.user_id, outbound_email.email_address_id, outbound_email.mail_sendtype, outbound_email.mail_smtptype, outbound_email.mail_smtpserver, outbound_email.mail_smtpport, outbound_email.mail_smtpuser, outbound_email.mail_smtppass, outbound_email.mail_smtpauth_req, outbound_email.mail_smtpssl, outbound_email.deleted, jt0_email_addresses.email_address FROM outbound_email LEFT JOIN email_addresses jt0_email_addresses ON (outbound_email.email_address_id = jt0_email_addresses.id) AND (jt0_email_addresses.deleted = ?) WHERE (outbound_email.id = ?) AND (outbound_email.deleted = ?) LIMIT 1' with params [0, "acec0c2c-39be-01ed-50d1-49da12897fa6", 0]:
Unknown column 'outbound_email.email_address_id' in 'field list'
Attached is the upgrade wizard log file.