[SOLVED] search box cached ?

[bartman]

have moved a couple of products to a different cat, but when i run a search for these products using the quick search box with ajax switched on it still shows them in the old categorys and not the new ones.

have emptied the /tools/smarty/compile directory but this mad nop differnce

Any on have any clues

thanks

chris

[rocky]

You need to go to Preferences > Search and click "Rebuild the entire index".

[bartman]

Just tried that and the results remain the same, is their a manual way to do a rebuild

path still remains as follows

Party Glow > Glow Cups and Glow Glasses > Lumica Blue Chemical Glow Cup

when the product is not in that category tree but in

Glow Barware > Lumica Blue Chemical Glow Cup


the party glow and glow cups category are both disabled and the blue glow cups has been moved to the glow barware category





regards


Chris

[bartman]

just switched ajax search off and the problem remains the same with normal search results

regards


Chris

[BillyD]

Barman,

I had to go into the database and truncate/empty the tables search_index and search_word then go to the rebuild indexes to Preferences > Search and click “Rebuild the entire index”.

I still had stuff in these tables relating to ipods and laptops even though I had rebuilt the index several times. Not sure if this is because I have done a fair amount of customisation. You could set up another default install and trial?

[BillyD]

worth checking your category_product table too

[bartman]

looks like a database problem, and could be a bug as well

basically the id_category_default in the ps_product was still pointing to the original category even though the product had been moved to a different category



regards


chris

[bartman]

did some checking and it looks like you can cause some problems when moving products about in your shop

basically

ps_category_product shows the product in the correct category

I would imagine this record is added to the database when I moved the product in to a different category

but id_category_default in ps_product still shows the original category.

I can understand that this would be the correct procedure if you placing the product in more than one category

but I think it is incorrect if you are moving the product to a different category and the product will only appear in one category

id_category_default in ps_product should be updated and now show the new category id

regards


Chris

[rocky]

This is expected behaviour. You must remember to change the default category to the new category whenever you move a product. The reason PrestaShop doesn't do this automatically is that it is possible to put the product in multiple categories, so PrestaShop wouldn't know which category to make the default. I agree that it is wrong that PrestaShop allows you to set the default category to a category the product isn't in. Perhaps PrestaShop should warn you when this happens or automatically change the default category to the first ticked category. You could post that in the bug tracker if you want it fixed in a future version.

[bartman]

raised this in the bug tracker


many thanks for everyones help

regards



Chris