mirror of
https://github.com/SuiteCRM/SuiteCRM.git
synced 2026-03-02 19:16:58 -05:00
Database error upon upgrade to 7.10 or 7.11 #3756
Labels
No labels
Area: API
Area: Campaigns
Area: Cases
Area: Clean Up
Area: Clean Up: Performance
Area: Dashlets
Area: Databases
Area: Developer Tools
Area: Elasticsearch
Area: Elasticsearch
Area: Emails
Area: Emails:Campaigns
Area: Emails:Cases
Area: Emails:Compose
Area: Emails:Config
Area: Emails:Templates
Area: Environment
Area: Installation
Area: Language
Area: Mobile
Area: Module
Area: PDFs
Area: PHP8
Area: Reports
Area: Studio
Area: Styling
Area: Upgrading
Area: Workflow
Area:Activity Stream
Area:Calls
Area:Import
Area:Projects
Area:Search
Area:Surveys
Area:Themes
Area:Users
Branch:Hotfix
Good First Issue
Hacktoberfest
Help Wanted
PR:Community Contribution
PR:Type:Enhancement
Priority:Critical
Priority:Important
Priority:Moderate
Severity: Major
Severity: Minor
Severity: Moderate
Status: Requires Code Review
Status: Requires Updates
Status: Stale
Status: Team Investigating
Status:Assessed
Status:Fix Proposed
Status:Needs Assessed
Status:Requires Automated Tests
Type: Bug
Type:Deprecated
Type:Discussion
Type:Duplicate
Type:Invalid
Type:Question
Type:Suggestion
Type:Suggestion
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/SuiteCRM-SuiteCRM#3756
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @aimran50 on GitHub (Jun 6, 2019).
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
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
Firefox and IE
Bitnami WAMP
Windows Server
@Dillon-Brown commented on GitHub (Jun 7, 2019):
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 commented on GitHub (Jun 7, 2019):
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 commented on GitHub (Jun 18, 2019):
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.