I had installed Fast Gallery successfully but recently added the 'Node Privacy By Role' module and now I get this error when viewing as an anonymous or authenticated user (only admin works). 

    * user warning: Unknown column 'n.nid' in 'on clause' query: SELECT COUNT(*) FROM fast_gallery INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 0 AND na.realm = 'node_privacy_byrole_user'))) AND ( folder = 'pictures') in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal6\sites\all\modules\fast_gallery\fast_gallery.inc on line 56.
    * user warning: Unknown column 'n.nid' in 'on clause' query: SELECT path,folder FROM fast_gallery INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 0 AND na.realm = 'node_privacy_byrole_user'))) AND ( folder = 'pictures') LIMIT 0, 10 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal6\sites\all\modules\fast_gallery\fast_gallery.inc on line 56.

All roles have Fast Gallery access enabled. For any other page on my site I have the option to edit->View/Edit Permissions but not for the image gallery. Is there a simple way to work around this?

Comments

rapsli’s picture

rapsli commented
Title: Fast Gallery Permissions » Fast Gallery Permissions support
Component: Miscellaneous » Code
Assigned: Unassigned » rapsli
Category: support » feature

I have never used this Module. I though doesn't make sense to to have edit permissions for the fast gallery, because you can only upload images by FTP. I though agree that it would be a nice feature for the view part.

Let me have a look at this and see how it behaves here. I'll get back to you and see if I can fix this issue.

rapsli’s picture

rapsli commented
Status: Active » Postponed (maintainer needs more info)

Couldn't reproduce the error. Though from my understanding of the module, Node Privacy By Role it's not possible to support fast gallery. In Fast Gallery the images aren't nodes! Is it possible that you are not using the latest beta1 version?

bmeier’s picture

bmeier commented

I was using beta 6.x.1.1 not the newest one. After upgrading all users can see the gallery but I get this warning (for each gid):

user warning: Table 'drupal.fast_gallery_exif' doesn't exist query: SELECT * FROM fast_gallery_exif WHERE gid=1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal6\sites\all\modules\fast_gallery\fast_gallery.inc on line 164.

Also there are 11 pages even though I only have 26 pictures (set at 15 to a page). This may be a problem causes by installing the newer fast gallery over an existing one?

rapsli’s picture

rapsli commented
Status: Postponed (maintainer needs more info) » Active

... try to completely uninstall the fast gallery module and install it again. There are still some problem with updating.

bmeier’s picture

bmeier commented
Status: Fixed » Active

edit: next post has comment and "active -> fixed"

bmeier’s picture

bmeier commented
Status: Active » Fixed

This worked I uninstalled fast gallery and imagecache as well then reinstalled them both and was able to configure everything as necessary. The new admin options for folders are great too.

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (fixed)

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