I have a Magento setup on production server. When we search any term on the site it should be stored in the catalogsearch_query table.

But for me some search terms are not being saved in this table.

Similar issue was on local system with production DB but when I truncated this table everything started working fine.

On production I did full re-indexing, checked for the class overrides and custom modules also but nothing helped.

So is there any way to fix this table without truncating and loosing the search terms?

I know there there is foreign key dependency on catalogsearch_result table also, with query_id field.

  • Did you find a solution for this yet? Feb 5 '17 at 16:15
  • @ArjenMiedema I have fixed it clearing the table and re importing the search terms.
    – Mukesh
    Feb 6 '17 at 9:13

As the topic starter stated in his comment, the fix for this was to backup the search terms, then truncate the table and reimport the search terms again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.