This is a notice message that I am trying to clean for some time without any success. I have searched the forums but couldn't find anybody with the exact same issue.
My products are tagged with terms of a vocabulary.
The taxonomy default view displays product images, add to cart button, title, priceof product etc.
I get the following notice message
Notice : Undefined index: node in views_handler_field_field->access() (line 127 in /var/www/mysite/sites/all/modules/views/modules/field/views_handler_field_field.inc).
I could identify that the guilty field is the price. (if i remove it, the notice get away)
Here is a copy of the query from the view.
SELECT DISTINCT node.nid AS nid, commerce_product_field_data_field_sku.product_id AS commerce_product_field_data_field_sku_product_id, node.created AS node_created, node.sticky AS node_sticky, 'commerce_product' AS field_data_field_photo_commerce_product_entity_type, 'commerce_product' AS field_data_commerce_price_commerce_product_entity_type, 'node' AS field_data_title_field_node_entity_type
FROM
{node} node
INNER JOIN (SELECT td.*, tn.nid AS nid
FROM
{taxonomy_term_data} td
INNER JOIN {taxonomy_vocabulary} tv ON td.vid = tv.vid
INNER JOIN {taxonomy_index} tn ON tn.tid = td.tid
WHERE (tv.machine_name IN ('categories')) ) taxonomy_term_data_node ON node.nid = taxonomy_term_data_node.nid
LEFT JOIN {field_data_field_sku} field_data_field_sku ON node.nid = field_data_field_sku.entity_id AND (field_data_field_sku.entity_type = 'node' AND field_data_field_sku.deleted = '0')
LEFT JOIN {commerce_product} commerce_product_field_data_field_sku ON field_data_field_sku.field_sku_product_id = commerce_product_field_data_field_sku.product_id
WHERE (( (node.status = 1 OR (node.uid = 1 AND 1 <> 0 AND 1 = 1) OR 1 = 1) AND (taxonomy_term_data_node.tid = '11' ) )AND(( (node.type IN ('produit_vitrine')) AND (node.language IN ('fr', 'und')) )))
ORDER BY node_created DESC, node_sticky DESC
Any help to understand wat is wrong would be appreciated
thanks
Comment | File | Size | Author |
---|---|---|---|
#3 | error.png | 23.62 KB | priyankprajapati |
Comments
Comment #1
bendev CreditAttribution: bendev commentedNo one ?
Comment #2
rszrama CreditAttribution: rszrama commentedSorry, there isn't enough information here to be able to reproduce the issue. For some reason, it appears your View is attempting an access check on the wrong base table for the price field. That isn't related to Commerce itself, so I think you'll need to look into Views itself to find where the issue might be.
Comment #3
priyankprajapati CreditAttribution: priyankprajapati commentedI have same issue in views.
when i add any fileds that time error will be display
Notice: Undefined index: commerce_product in views_handler_field_field->access() (line 127 of sites\all\modules\views\modules\field\views_handler_field_field.inc)
Comment #4
Nchase CreditAttribution: Nchase commentedsame error here.
Comment #5
pwiniacki CreditAttribution: pwiniacki commentedsame here after trying to update drupal to 7.35 and commerce + rules to latest stable versions.
EDIT:
related to:
An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: http://www.site.com/update.php StatusText: OK ResponseText: Fatal error: Call to undefined function commerce_line_item_load_multiple() in
EDIT2:
You can try to change the value for max_execution_time in php.ini file to be bigger than 60 - for example: max_execution_time = 240
So error disappear and there is no more problems with views_handler and field_views warnings.
Comment #6
DarrellDuane CreditAttribution: DarrellDuane commentedThis issue is a duplicate of https://www.drupal.org/node/2331209 and has been marked as Reviewed & Tested by the community.
Comment #7
DarrellDuane CreditAttribution: DarrellDuane commented