I've problem with views, i can't add relationship, when i try i've this issue :

Notice : Undefined index: table in views_handler_relationship->query() (line 111 in sites/all/modules/views/handlers/views_handler_relationship.inc).

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (( (node.status = '1') AND (node.type IN ('forum')) ))) subquery' at line 2

Can you help me for fixe this problem ?

CommentFileSizeAuthor
#6 fix_empty_cache-2302447-9228265.patch808 bytesimpol
#5 fix_empty_cache-2302447-9228265.patch807 bytesimpol
#2 fix_empty_cache.patch1003 bytesimpol
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented

Can you please put down enough details to reproduce the issue?

impol’s picture

impol CreditAttribution: impol commented
FileSize
fix_empty_cache.patch1003 bytes

Sometimes in cache we have an empty array, and relationship plugin fails.

impol’s picture

impol CreditAttribution: impol commented
Status: Active » Needs review

Status: Needs review » Needs work

The last submitted patch, 2: fix_empty_cache.patch, failed testing.

impol’s picture

impol CreditAttribution: impol commented
FileSize
fix_empty_cache-2302447-9228265.patch807 bytes
impol’s picture

impol CreditAttribution: impol commented
FileSize
fix_empty_cache-2302447-9228265.patch808 bytes
impol’s picture

impol CreditAttribution: impol commented
Status: Needs work » Needs review

Status: Needs review » Needs work

The last submitted patch, 6: fix_empty_cache-2302447-9228265.patch, failed testing.

RAWDESK’s picture

RAWDESK CreditAttribution: RAWDESK for Colruyt Group Services commented

What's the status of this patch ? Can this lead to a permanent solution ?
Reported a similar issue in this thread :
https://www.drupal.org/node/2055681#comment-11916627