Database error upon upgrade to 7.10 or 7.11

[aimran50]

Issue

Upgrade from 7.8 to 7.10 or 7.11 fails

Expected Behavior

Upgrade should work

Actual Behavior

This error is shown:
Database failure. Please refer to suitecrm.log for details.

Thu Jun 6 19:31:38 2019 [1276][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteP/modules is not a file or a dir.
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '34498c98-1fcc-3052-2dfa-5a429c7d9b60'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Prospects'
AND ear.bean_id = '80dc64cf-2663-16ec-6818-5a5cf99ee9a7'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Prospects'
AND ear.bean_id = 'b9c0a124-589e-d585-ea3d-5a5cf76de86b'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:12 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Prospects'
AND ear.bean_id = '9dfa380b-5ff3-6ca5-f5dc-5a5cf757ba74'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:13 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:13 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Prospects'
AND ear.bean_id = '518e0223-cc13-3b5a-ae40-5a5cf6dedc65'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:13 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:13 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Contacts'
AND ear.bean_id = '65e263b5-2494-53b4-0ff5-5cb4aa3290fb'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:13 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:13 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Accounts'
AND ear.bean_id = 'aff34d61-c4fa-e3ea-a186-58ebf547772e'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '34498c98-1fcc-3052-2dfa-5a429c7d9b60'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Prospects'
AND ear.bean_id = '80dc64cf-2663-16ec-6818-5a5cf99ee9a7'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Prospects'
AND ear.bean_id = 'b9c0a124-589e-d585-ea3d-5a5cf76de86b'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Prospects'
AND ear.bean_id = '9dfa380b-5ff3-6ca5-f5dc-5a5cf757ba74'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Prospects'
AND ear.bean_id = '518e0223-cc13-3b5a-ae40-5a5cf6dedc65'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Contacts'
AND ear.bean_id = '65e263b5-2494-53b4-0ff5-5cb4aa3290fb'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:15 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Accounts'
AND ear.bean_id = 'aff34d61-c4fa-e3ea-a186-58ebf547772e'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:16 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:16 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:16 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:16 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:16 2019 [1276][-none-][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:16 2019 [1276][-none-][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:16 2019 [1276][-none-][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:16 2019 [1276][-none-][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:16 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:16 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:18 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:18 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:20 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:20 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:35 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:35 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:37 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:37 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:44 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:44 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:47 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:47 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:51 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:51 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:40:54 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:54 2019 [1276][1][FATAL] Executing repair query: Query Failed: ALTER TABLE campaigns modify COLUMN name varchar(255) NULL , add COLUMN survey_id char(36) NULL , ADD INDEX idx_survey_id (survey_id): MySQL error 1292: Incorrect date value: '0000-00-00' for column 'end_date' at row 7
Thu Jun 6 19:40:54 2019 [1276][1][FATAL] Exception handling in C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\MVC\Controller\SugarController.php:400
Thu Jun 6 19:40:54 2019 [1276][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Jun 6 19:40:54 2019 [1276][1][FATAL] backtrace:
#0 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\database\DBManager.php(353): sugar_die('Database failur...')
#1 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\database\DBManager.php(328): DBManager->registerError('Executing repai...', 'Executing repai...', true)
#2 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\database\MysqliManager.php(179): DBManager->checkError('Executing repai...', true)
#3 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\modules\Administration\repairDatabase.php(93): MysqliManager->query('ALTER TABLE cam...', true, 'Executing repai...')
#4 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\MVC\View\SugarView.php(818): include_once('C:\Bitnami\wamp...')
#5 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\MVC\View\views\view.classic.php(72): SugarView->includeClassicFile('modules/Adminis...')
#6 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\MVC\View\SugarView.php(211): ViewClassic->display()
#7 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\MVC\Controller\SugarController.php(435): SugarView->process()
#8 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\MVC\Controller\SugarController.php(375): SugarController->processView()
#9 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\include\MVC\SugarApplication.php(113): SugarController->execute()
#10 C:\Bitnami\wampstack-7.1.12-0\apps\suitecrm\htdocs\index.php(52): SugarApplication->execute()
#11 {main}
Thu Jun 6 19:40:56 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:40:56 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:41:58 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:41:58 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:43:00 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:43:00 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'
Thu Jun 6 19:44:01 2019 [1276][1][FATAL] Mysqli_query failed.
Thu Jun 6 19:44:01 2019 [1276][1][FATAL] Query Failed: SELECT
ea.email_address,
ea.email_address_caps,
ea.invalid_email,
ea.opt_out,
ea.confirm_opt_in,
ea.date_created,
ea.date_modified,
ear.id,
ear.email_address_id,
ear.bean_id,
ear.bean_module,
ear.primary_address,
ear.reply_to_address,
ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE
ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC: MySQL error 1054: Unknown column 'ea.confirm_opt_in' in 'field list'

Possible Fix

Steps to Reproduce

1. Use wizard based upgrade. No special steps. Happens each time.

Context

For pasta two years we have made several attempts to upgrade from 7.8 and it fails each time. This is really bad.

Tis is very HIGH priority as 7.8 EOL is near and we have to upgrade.

Your Environment

• SuiteCRM Version used:
• Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)):
  Firefox and IE
• Environment name and version (e.g. MySQL, PHP 7):
  Bitnami WAMP
• Operating System and version (e.g Ubuntu 16.04):
  Windows Server

[Dillon-Brown]

Hi @aimran50, what version of 7.8 were you upgrading from? I would potentially try adding the unknown confirm_opt_in field manually to the database and see if that fixes things.

[pgorod]

Another tip: when you run a Quick Repair and Rebuild, scroll down to the bottom to check if there is a button there saying "sync database with vardefs". If there is, press it.

[connorshea]

This also happened to us when we upgraded from 7.9.17 to 7.10.16.

I think its been fixed by simply running a Quick Repair and Rebuild, though.