MySQL error 1146: Table 'sugarcrm.aod_index' doesn't exist

[kdavidson]

I just migrated over from sugarcrm. After I ran the installation, I did a Quick Repair and Rebuild. I also ran Rebuild Relationships.

Everything looks good, seemed flawless.

I then attempted to search for a contact using the global search and received the following message:

Use standard SugarCRM searchDatabase failure. Please refer to sugarcrm.log for details.

So I checked the error log:

Error inserting into table: aod_index: Query Failed: INSERT INTO aod_index (id,name,date_$
VALUES (‘71270379-2b4b-3f33-1336-53e4cd49b8ed’,‘Index’,‘2014-08-08 13:15:00’,‘2014-08-08 13:15:00’,'c6d90463-0e54-8cd6-43a7-4b7$

Of course, I checked the database and this table is not present.

I will point out that since I upgraded to sugarcrm 6.5.x, i lost the ability to search for contacts using the global search. No matter what I put in the search, it always pulled all of the contacts in the system.

Any help - much appreciated!!

[Will]

Hi there,

When you run a Quick Repair & Rebuild, you need to scroll to the footer of the page and Execute any changes.

Thanks,

Will.