Search Not working after MySQL Update [SOLVED]

[waynemiller]

Hi All,

 

I have just added the description to over 4000 items. I created a temp table, loaded a csv and then updated the pr_product_lang table with the descriptions. (I couldn't use the import function as my descriptions contain a lot of different symbols) Anyway the update was successful but now my search function wont work. If I use the back end, select an item and then save it the search function works on that item.

 

What do I need to do? I obviously don't want to go into every item and save it as like I said earlier theres over 4000 of them.

 

 

Heeeeeeeeeeeeeeeeeeeeeelp Wayne

Edited December 8, 2012 by waynemiller (see edit history)

[bellini13]

i suspect the symbols you are using are not being encoded properly. you would probably need to encode those in the same manner that the back office does. and no, I do not know what that is.

[gdinari]

Hi waynemiller, I was experiencing the same issue as a cause of csv database imports.

 

The problem seems to be that by performing db imports youre actually skipping some of the automated processes that prestashop would perform had you created the entries through the admin. For example, creating a product. If you did it through the admin section, upon saving it, the system automates a whole bunch of processes throughout the database to update that product. But if you create the product directly to the database then those automated process dont get initiated and somethings won't work how they should.

 

To fix it you need to rebuild the site index used for searching for products. This will process all of your products and update them accordingly for the search function.

 

How to fix:

Back Office > Preferences > Click "Re-build entire index"

 

You should do this often, especially when you update a lot of items. Also keep in mind that if you have a lot of product (like 1000s) then your server may timeout, so make sure you have enough max_execution time (in php.ini file of server). If you only have a small inventory then no need to worry.

 

This is what worked for me.

 

Hope this helps.

Edited December 8, 2012 by gdinari (see edit history)

[waynemiller]

That worked for me too, many thanks