7.0.6 Order Manager Glitch

[krittleb]

We just had our site upgraded to 7.0.6 and have run into a problem.

It appears that the "keyword search" on the order manager page in admin has changed. The drop-down box options have completely changed to options such as billing information, shipping information, etc.

Every search function on the page is working fine except for the new keyword search. We can search by order number, order date, order status, etc. with no problems.

However, when we do a keyword search by trying to enter in a customer last name, we get a little error text box on the page that says "Exception has been thrown by the target of an invocation." If we then navigate to a different screen in admin and try to come back to the "order" page, we instead get a yellow 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."

I am hoping there is an easy fix that doesn't involve database access (do not have access to database) as our developers are quite pricey and we would like to try to fix this ourselves.

Any ideas or anyone else have this problem when upgrading??

[jmestep]

Make sure your database is set up to use full text search.

[krittleb]

We are running through AWCS which does not allow us access to the database. I assume I will have to contact them?

[jmestep]

That would be best. Full Text search might not be turned on for the database. If it is and the enable full text search is checked in the admin, something might need to be re-set. I ran into the same error on a local test site of mine where I hadn't turned full text search on for the ac_Webpages table when I was building a custom search method. I'm not sure why the standard search wouldn't work, but AWCS should be able to figure it out for you.

[dc8johnson]

I had a client complain with the same problem today. We looked at the full text catalog definition and the ac_orders, ac_ordernotes and ac_ordershipments tables were NOT in the Full Text Catalog. Rebuilding the FTS index on the Configure >> Maintenance page didn't fix the problem.

Turns out we had to turn OFF the FTS option on the Store page (which removed the Full Text Catalog) and then turn it back ON (which recreated a new Full Text Catalog). The new Full Text Catalog had the three order tables and now the keyword search worked.

Looks like the upgrade scripts might not add the new tables to the Full Text Catalog.

[krittleb]

Good information!!

Our programmers still have not gotten the issue fixed for us yet so I will let them know how you got it to work.

You would think that everybody on the new 7.0.6 platform would be having the same problem and there would be more awareness of it on here...

[jmestep]

We have a client not hosted on our servers who is having the problem and we are planning to rebuild the index when we get access to their admin. It just isn't clear at this point if the problem came as a result of the upgrade or if they had switched database servers also and that caused a problem.

[jmestep]

I've put in a bug report about this.