My issue is that the Price Sort and Advanced Search are not working. This has been discussed in other threads, but not for Magento ver. 184.108.40.206. The code is different so the fixes do not apply. The Position Sort and Name Sort and Search both function.
I looked at my database and discovered that the catalogindex_price table is empty, unlike functioning older versions of Magento. How can I get the data in the fields? I am also unable to rebuild the search index even if I delete the var/cache files and refresh the cache.
I’m still having this problem - no refreshing cache nor rebuilding of indices helped. Price and price alone not working for search, advance search, sort, nor layered nav filters (all my other searches and sorts function).
I had the same problem: couldn’t sort by price ascending or descending. I tried the fix for System --> Cache Management --> Refresh Layered Navigation Indices, and after 30 seconds I received this error message:
“Fatal error: Maximum execution time of 30 seconds exceeded in /home/edigital/public_html/lib/Zend/Db/Select.php on line 848”
I’m not really sure if that’s some kind of programming error or what, but the solution DID fix my “sort by price” problem. Thanks!
This is a strange error. I am having the sort by price issue. I rebuilt the search index. It worked....momentarily. Just long enough for me to check the prices and url several times, write my boss and notified them I fixed it. Turned around and it was a complete mess again.
Has anyone experienced this?? What breaks it? Thank you for the information thus far, it was helpful.
I found solution for my problem. My problem was occurred because i imported my local database at live.
Due to import the tables that have first Id zero was set to its highest id not to zero. This happens in “customer_group”, “core_store”, “core_store_group” and “core_website” tables.
to solve this problem in “customer_group” table set the “Not Logged In” rows id to zero and update the “catalog_product_index_price” tables “customer_group_id” value with zero where the rows are with the newly generated id.
Then do re indexing of “Catalog Search Index” from index management.
Its worked for me. Please give you response if helps to any one.