Keyword search error in order admin
Applies to: AbleCommerce version 7.0.7
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.
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."
To correct the issue, follow the instructions below:
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.
A division of Able Solutions Corporation, headquarters located in Vancouver, WA