Solr 4.1 does not work (yet) with Magento EE 1.12 - use Solr version 3.6 for now!

This will be a short post, I just want to let people know how much trouble I've had trying to find something definitive that calls out how the Magento Solr integration built-into Magento Enterprise Edition v1.12 does NOT SUPPORT Solr version 4.1 - in fact, I still can't find any "smoking gun" documentation to confirm this, only a handful of reports about various bugs when using 4.1 such as this one regarding "Unknown commit parameter waitFlush" found on Stack Overflow:

It's surprising that there's not clearer (any?) documentation specifying the major revision of Solr to use. It's probably out there, and I suppose someone will rub my nose in it soon, but we've been scouring the Internet and haven't found anything that makes this more obvious.


How do I check Magento's Search Relevance scores to see what IT thinks is relevant?

Refine Magento search's targeting selection to be as crafty as a Predator Drone!

Magento's stock search is pretty basic, and although it offers a "sort by relevance" feature I often can't tell what it was thinking from the order of the result set. So I decided to hit the database directly and dump out the weighted scores to view them numerically. Now, this doesn't "dix" anything - but at least it gives me the ability to adjust the indexing algorithm and see the results of my efforts.

The following code will do just that:

SELECT prodName.`value` AS name,
MATCH (searchIndex.`data_index`) AGAINST (' ') AS relevance
FROM catalogsearch_fulltext AS searchIndex

LEFT JOIN catalog_product_entity_varchar AS prodName
ON prodName.`entity_id` = searchIndex.`product_id` AND prodName.`attribute_id` = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'name' AND entity_type_id = 4)

ORDER BY relevance DESC;


How to add a product search to Drupal Commerce using Views and the Search API

Bill's Hog Reserved Parking in the Men's Shitter

Having problems finding support with adding a product search in Drupal Commerce? Assuming you've gotten as far as installing the Search API, Views Search integration and set up your service/server/index, you're now wrestling with why the name of your index is not showing up in the drop-down for "Show: in Views add. Note: If you haven't gotten that far, go back to Google (GBTG?) cuz help is available. If you have, read on.


Subscribe to RSS - Search