The index correctly indexes the product display title field:

admin/config/search/search_api/index/search_commerce_display/fields

but when I search for a product display title, no result found.

CommentFileSizeAuthor
#6 Notices during drush install58.75 KBguguss

Comments

guguss’s picture

guguss commented
Title: The search bar doesn't search for product display titles » The search bar doesn't search for product content type fields

Same for all taxonomy attached to the product content type: collection category, gender, brand.

The search works fine for :

  • the body
  • color
  • size
guguss’s picture

guguss commented
Status: Active » Needs work

I updated the search feature and commited it here : https://code.drupalcommerce.org/#/c/101/ to index the product display title field as fulltext.

But I'm still having an issue. After a fresh install, the feature is overriden with the field indexed as string instead of fulltext. Don't know where this issue comes from ! (this has ben fixed by : https://code.drupalcommerce.org/#/c/100/)

vasike’s picture

vasike
Location Ramnicu Valcea
commented
Status: Needs work » Needs review

Added the collection, gender, brand to the "Search Commerce Display" search engine fields as fulltext search.
commited it here: https://code.drupalcommerce.org/#/c/221/

IMPORTANT:
i had to change manually the features, as with Features recreation, i get others changes, with some field definitions and user permissions.
#1691422-1: Re-export all features
#1635258-9: Check by default the "billing address is same as shipping address" during checkout
so i think it's mandatory for the Kickstart Features to be rebuild from scratch.

bojanz’s picture

bojanz commented
Status: Needs review » Fixed

Tested this, it fixed the annoyances I had with searching. Seems fine now.

Merged. I'll re-export the features in the morning.

guguss’s picture

guguss commented
Assigned: Unassigned » vasike
Status: Fixed » Active

I'm reopening the issue since I'm having an issue when installing via drush, and it seems related ;) :

WD search_api_db: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;[warning]
check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE 
(item_id = '19')' at line 1
WD php: Notice: Undefined index: field_product_commerce_price_amount_float_asc in                                 [notice]
SearchApiDbService->indexItem() (line 332 of
/media/nfsdrive/stratus_kickstart_v2/www/commerce_kickstart/profiles/commerce_kickstart/modules/contrib/search_api_db/service.inc).
guguss’s picture

guguss commented
StatusFileSize
new Notices during drush install58.75 KB

I'm attaching a screenshot of the error !

The drush command I use is (-v for verbose mode) :
drush si commerce_kickstart --account-pass=admin --db-url=mysql://sqluser:password@localhost/kickstart_v2 -y -v

Anyway, the installation works for me... so those are just warning !

vasike’s picture

vasike
Location Ramnicu Valcea
commented

i couldn't reproduce it with Commerce Kickstart 7.x-2.0-alpha3+21-dev (2012-Jul-27).

guguss’s picture

guguss commented

Happened on the latest version with that latest commit :
Issue #1670986 by GuGuss, vasike: Add title and terms data fulltext search for S (MERGED)

vasike’s picture

vasike
Location Ramnicu Valcea
commented

indeed i got this error.
i also tried without the last changes for the "Search Commerce Display" search engine fields and i got the same errors.
So it doesn't seem related with this issue commits. it seems a new issue.

i also got other errors when i try to index the search manually, after instalation.

Notice: Undefined index: field_product_commerce_price_amount_float_asc in SearchApiDbService->indexItem() (line 332 of drupal_path/profiles/commerce_kickstart/modules/contrib/search_api_db/service.inc).

Some items couldn't be indexed. Check the logs for details.

Could be something related with the migration data?

bojanz’s picture

bojanz commented

There's also #1702692: Commerce Kickstart: installation of "demo store" fails when using PostgreSQL database. Odd things around search.

vasike’s picture

vasike
Location Ramnicu Valcea
commented

it seems there is an issue with Price field with the "Search API ranges" module.
If i use other widget for this field. there's no error.
so (imho) definitely this is a new issue.
i also suspect this is related with some modules upgrades, search api and related.

by the way the all products won't work - empty page, as the search index isn't created.

vasike’s picture

vasike
Location Ramnicu Valcea
commented
Status: Active » Fixed

new issue opened for this #1706244: Search Commerce Display won't index product - no results. closing this one.

Automatically closed -- issue fixed for 2 weeks with no activity.