Keyword search error in order admin

Applies to: AbleCommerce version 7.0.7

Date:  05/23/2011

7/07/11 - Service Release 1 is available.  You can skip this patch and apply AbleCommerce 7.0.7 SR1a instead.  

Description of Issue:

The 7.0.7 upgrade scripts do not add the new tables to the Full Text Catalog.

Symptom:

Performing a keyword search from the order admin, like trying to enter in a customer last name, you may get an error on the page that says:

"Exception has been thrown by the target of an invocation."

If you navigate to a different screen in admin and try to come back to the "order" page, you may get a full error page containing similar information and with a page heading that reads:

"Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'ac_OrderShipments' because it is not full-text indexed."

Fix:

To correct the issue, follow the instructions below:

1. Go to the Configure > Store page.

2. Turn OFF the FTS option and then turn it back ON.

Turning off FTS will remove the existing indexes. Turning FTS back on will recreate them. It should also at that time create the index that is missing from the ac_Orders table.