Hi All,
I’m attempting to upgrade from Sugar 6.5.9 to Suite 7.1.8 using the migration package applicable to those version #s on the download page. The upgrade seems to go OK until near the very end when on the upgrade wizard status screen it shows the following:
Adding for Leads
Adding for Cases
Adding for Bugs
Adding for ProspectLists
Adding for Prospects
Adding for Project
Adding for ProjectTask
Adding for Campaigns
Adding for EmailMarketing
Adding for Users
Adding for Contacts
Adding for Accounts
Adding for Opportunities
Adding for EmailTemplates
Adding for Notes
Adding for Calls
Adding for Emails
Adding for Meetings
Adding for Tasks
Adding for Users
Adding for Documents
Adding for EAPM
Adding for Calls_Reschedule
Database failure. Please refer to sugarcrm.log for details.
In the log file, this error is repeated numerous times:
Sat Jun 3 05:01:02 2017 [2805][1][FATAL] Retrieving record by id aod_index:1 found Query Failed: SELECT aod_index.* FROM aod_index WHERE aod_index.id = ‘1’ AND aod_index.deleted=0 LIMIT 0,1: MySQL error 1146: Table ‘sugarcrm.aod_index’ doesn’t exist
Indeed, looking in /var/lib/mysql there are no files for the table aod_index.
Did I miss something here? I also checked the migration package for a table def for aod_index, but couldn’t find one (though the CREATE TABLE statements do look to be programmatically constructed, so I’m not 100% on that.
I used the following file to do the upgrade: https://suitecrm.com/files/121/Sugar-CE-to-SuiteCRM/30/SugarCE-Migration-6.5.x-to-Suite-7.1.8.zip
BTW - The installation appears to function, insofar as I can view and search records. There are also no other errors in the log file.
Thanks in advance for your input!
Regards,
Scott