Hmm its failing pretty early. Your upgrade log is failing at <your_instance>/upgrade/scripts/post/2_Rebuild.php which is very early in the upgrade process. Some notes:
MySQL error 1071: Specified key was too long; max key length is 1000 bytes
'1000 limit' is consistent with <=5.6. In 5.7 this limit has increased to 3072 which should be plenty enough to index a utf-8 varchar(255). The fact that you are getting it on 5.7 means you likely have some non-default setting in your mysql instance or perhaps dont actually have 5.7 installed? You could always try reinstalling MySQL or removing any weird settings you have in my.cnf to see if this goes away.
Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone="UTC" in php.ini!
This is a really important one and should have been set when you first installed Sugar. Find your php.ini (for example on Debian/RHEL its at etc/php.ini) and add the line for your time zone. my setting is:
[Date]
date.timezone = "America/New_York"
You can find a list of supported plain text time zones here: PHP: List of Supported Timezones - Manual
Unknown column 'outbound_email.email_address_id' in 'field list'
here is my output for the outbound_email table. It doesnt exist in my 8.0 instance either but I'm not sure thats stopping you.
mysql> describe outbound_email;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| id | char(36) | NO | PRI | NULL | |
| name | varchar(50) | YES | | NULL | |
| type | varchar(15) | YES | | user | |
| user_id | char(36) | NO | | NULL | |
| mail_sendtype | varchar(8) | YES | | smtp | |
| mail_smtptype | varchar(20) | YES | | other | |
| mail_smtpserver | varchar(100) | YES | | NULL | |
| mail_smtpport | int(5) | YES | | 0 | |
| mail_smtpuser | varchar(100) | YES | | NULL | |
| mail_smtppass | varchar(100) | YES | | NULL | |
| mail_smtpauth_req | tinyint(1) | YES | | 0 | |
| mail_smtpssl | int(1) | YES | | 0 | |
+-------------------+--------------+------+-----+---------+-------+
12 rows in set (0.00 sec)
If you wanted to, you could add the field just to make the error go away. In MySQL or PHPmyAdmin perform the following:
Table 'crm.audit_events' doesn't exist
My instance doesnt have this table either. I dont this this is stopping you either.
I had the same issue. In addition to the above tables, my instance was also missing the erased_fields table;
CREATE TABLE `erased_fields` (
`bean_id` char(36) NOT NULL,
`table_name` varchar(128) NOT NULL,
`data` text,
PRIMARY KEY (`bean_id`,`table_name`)
)
I had the same issue. In addition to the above tables, my instance was also missing the erased_fields table;
CREATE TABLE `erased_fields` (
`bean_id` char(36) NOT NULL,
`table_name` varchar(128) NOT NULL,
`data` text,
PRIMARY KEY (`bean_id`,`table_name`)
)