When I have Views Save enabled it works fine on the views that utilise the header Global: Save - but I'm getting this error on other views I'm utilising on my site:

Exception: Query tagged for saved view access but there is no saved view id. Add foreign keys to views_save.id in schema to fix. in _views_save_query_views_save_access_alter() (line 634 of C:\wamp\www\mysite\sites\all\modules\views_save\views_save.module).

When I disable the module - all is well again

CommentFileSizeAuthor
#5 2139995-5--access_query_alter_bug.patch754 bytesdrunken monkey

Comments

pixelsweatshop’s picture

pixelsweatshop commented

Can confirm that I am getting this as well.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented

Huh, curious. I cannot reproduce this, and I also don't really know how this could happen. However, it seems to come from Views internals, so basically anything is possible.
Could you maybe describe your setup a little bit more? Does it occur right after you enable this module or only when you have the header added to some views? Does it occur for all users, or only for guests/normal users/admins? Does it occur on all views without the header? Do you have some additional Views modules installed that might influence this? Did you try on more than one site, did it fail on all of them?
Thanks for your help in resolving this!

erin814’s picture

erin814 commented

I'm getting this as well. I get the error message when trying to view a node of a particular content type. For me, when I change the permission for a user to "View published saved views", it causes this error. If I also allow the user to "Administer Views Save", it seems to work normally again. However, I'd rather not give this permission to users.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Active » Postponed (maintainer needs more info)

Again, I cannot reproduce this, I'm sorry. Are you using the latest versions of all relevant modules and of Drupal core?
Maybe you have some additional module installed that causes the incompatibility? Which Views modules do you have installed?
Also, please list exact steps needed to reproduce, preferrably from a clean install with only Views and Views Save added.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Title: Views Save breaking other views » Fix errors in query access altering
Status: Postponed (maintainer needs more info) » Needs review
StatusFileSize
new 2139995-5--access_query_alter_bug.patch754 bytes

I finally managed to reproduce this (though, for me, it failed in cron, while trying to delete Field API fields). Please test whether the attached patch solves the problem for you!

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Needs review » Fixed

OK, committed. I hope this eliminates that problem.

  • drunken monkey committed f54ec8a on 7.x-1.x 
    Issue #2139995 by drunken monkey: Fixed errors in query access altering.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

lowkey12’s picture

lowkey12 commented

Hello there,

I recently stumbled upon this issue and the patch has been applied, but I still receive the error: Exception: Query tagged for saved view access but there is no saved view id. Add foreign keys to views_save.id in schema to fix. in _views_save_query_views_save_access_alter() (line 636 of /var/www/coop/webalpha.info/tsdm/sites/all/modules/views_save/views_save.module)..

The error goes away if I alter the permissions to make it so authenticated users can not look at published save views. However, if I change that authenticated users are not able to see either published or unpublished saved views.

I've tried disabling multiple views plugins to see if it is an incompatibility but that has not helped.