Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
when user view create view brightcove video width "CONTEXTUAL FILTERS" or "FILTER CRITERIA" has field "Brightcove Video: Tags".
It's show error "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'brightcove_video__tags.tags'....."
I don't know fix it. can you help me
Comment | File | Size | Author |
---|---|---|---|
#6 | brightcove-fix-multivalue-entity-reference-for-views-2842933-6.patch | 3.48 KB | yce |
Comments
Comment #2
chinhlc CreditAttribution: chinhlc commentedComment #3
fgmApparently, the plugin exposes a nonexistent "tags" column for the brightcove_video__tags schema, which may have been a simple string at some point, but is now replaced by an entity reference target_id to the brightcove_video_tags vocabulary.
Comment #4
Znak CreditAttribution: Znak commentedComment #5
Znak CreditAttribution: Znak commentedComment #6
yce CreditAttribution: yce at Pronovix for BrightCove commentedHi,
I've created a patch which would solve the issue, but I'm not sure if it's the right way to do this.
Comment #7
BoobaaThis looks like a problem that should (have) be(en) fixed in core (views?). I can understand how this works and why, but could you please link the core issue as well (if there's one already)? I'm guessing that this problem could be (and should be) solved by that core issue as well, not only by this patch. Additionally, I'm a bit hesitant if we should include code that checks for this core problem, and only add/change our views integration data if core doesn't have it solved yet.
Leaving it on NR as it would be beneficial to have others' opinion about this, too.
Comment #8
yce CreditAttribution: yce at Pronovix for BrightCove commentedThere is a similar issue with dynamic entity reference module, here: https://www.drupal.org/node/2548395
The related core issue: https://www.drupal.org/node/2477899
So it should work, but I don't know why it isn't in our case.
Comment #9
BoobaaIs this problem still present with drupal-8.3.x? If it is, then please reopen the core issue and post a list of steps to reproduce it there, too (probably using only core modules).
Comment #10
muldos CreditAttribution: muldos at Groupe Profession Santé for Groupe Profession Santé commentedHi,
I've just run into this issue with Drupal core 8.3.7 and brightcove module's version 8.x.1-2.
Steps to reproduce :
1 - install the brightcove video module and its dependencies
2 - Configure brightcove api client credentials
3 - Sync video with drupal
4 - create a view for the type brightcove video
5 - add the name of the video as field
6 - add a filter on the tag field with a not null value (when no value is found, the field will not be used in the query)
7 - You should have now :
instead of a list of results
Comment #11
muldos CreditAttribution: muldos at Groupe Profession Santé for Groupe Profession Santé commentedComment #12
muldos CreditAttribution: muldos at Groupe Profession Santé for Groupe Profession Santé commentedHi, the bug was not fixed in core (but it was confirmed : https://www.drupal.org/project/drupal/issues/2477899) so can we use the fix provided ? There is no drawback to explicitly define to the views module the entity relationship between a BrightcoveVideo and Tags, I've used this patch in production for 8 monthes.