3

I have a Magento 1.4.1.1 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.

Improve this question
2
  • Did you find a solution for this yet?
    – Arjen Miedema
    Commented Feb 5, 2017 at 16:15
  • @ArjenMiedema I have fixed it clearing the table and re importing the search terms.
    – Mukesh
    Commented Feb 6, 2017 at 9:13

1 Answer 1

Reset to default
4

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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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