Did install 7.x-1.x-dev version and applied Recommender API patch as defined in #1611716.

After installation on Commerce Product Display: similar products views it statest that Relationship: Commerce Product: Products recomended for this product is either broken or corrupt.

In commerce_rec.views_default.inc has reference to commerce_rec_source field but I guess that it should link to commerce_rec_similarity (as defined in commerce_rec_views_data_alter)?

  /* Relationship: Commerce Product: Products recomended for this product */
  $handler->display->display_options['relationships']['commerce_rec_source']['id'] = 'commerce_rec_source';
  $handler->display->display_options['relationships']['commerce_rec_source']['table'] = 'commerce_product';
  $handler->display->display_options['relationships']['commerce_rec_source']['field'] = 'commerce_rec_source';
  $handler->display->display_options['relationships']['commerce_rec_source']['relationship'] = 'field_product_product_id';
  $handler->display->display_options['relationships']['commerce_rec_source']['required'] = 1;

If changing field value from commerce_rec_source to commerce_rec_similarity, view seems to be ok but query returns
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'commerce_product_field_data_field_product.commerce_rec_similarity' in 'on clause'

Any idea what I'm doing wrong here?

Comments

mitrpaka’s picture

Issue summary: View changes
Status: Active » Closed (duplicate)

Query error was due to wrong patch applied to Recommender API. Correct patch to apply is https://drupal.org/node/1611716#comment-6105088.

This is duplicate for https://drupal.org/node/1611692