Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
When I install the module I always get this error. I couldn't find a way to fix it:
Notice: Undefined index: id in _recurly_entity_relationship_data() (line 137 of modules/recurly/recurly.views.inc).
Comment | File | Size | Author |
---|---|---|---|
#11 | recurly-views-integration-broken-2887510.patch | 1.03 KB | glynnr |
#3 | views_integration_broken-2887510-3.patch | 1.87 KB | markdorison |
|
Comments
Comment #2
markdorisonI am not seeing this specific error, but I am seeing an error when trying to add the recurly relationship to the default "Who's New" view; I am guessing this is related:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recurly_account.entity_type' in 'on clause': SELECT users_field_data.created AS users_field_data_created, users_field_data.uid AS uid FROM {users_field_data} users_field_data INNER JOIN {users} users ON users_field_data.uid = users.uid LEFT JOIN {recurly_account} recurly_account_users ON users.uid = recurly_account_users.entity_id AND (recurly_account.entity_type = 'user') WHERE (users_field_data.status = :db_condition_placeholder_0) AND ((users_field_data.access > 0)) ORDER BY users_field_data_created DESC LIMIT 5 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 )
Comment #3
markdorisonComment #4
markdorison@aepc55: I am not sure why this change seems to fix this issue for me, but it seems to. Does this resolve the issue for you?
Comment #5
aepc55 CreditAttribution: aepc55 commented@markdorison
It worked, thanks for the patch.
Comment #6
markdorisonComment #8
markdorisonComment #10
ngunner CreditAttribution: ngunner commentedI am still getting this error when I create a view of users and add relationship 'Recurly Account':
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recurly_account.entity_type' in 'on clause': SELECT users_field_data.uid AS uid FROM {users_field_data} users_field_data INNER JOIN {users} users ON users_field_data.uid = users.uid LEFT JOIN {recurly_account} recurly_account_users ON users.uid = recurly_account_users.entity_id AND (recurly_account.entity_type = 'user') WHERE users_field_data.status = :db_condition_placeholder_0 LIMIT 5 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 )
I have tested the patch in #3 as well as the latest Dev version of the module with no luck. Thank you for any help you can provide.
Comment #11
glynnr CreditAttribution: glynnr commentedApologies up front for re-opening this old issue but couldn't find anything more current.
I also have experienced this error and thought I would share my solution, just in case it helped someone else. Essentially it boils down to how the table alias is being used.
I've attached my patch which I'm running locally and seems to work.