I get the following error when trying to update a view with a node gallery image:

user warning: Table 'winegrowers.node_galleries' doesn't exist query: SELECT DISTINCT(node.nid) AS nid, node_galleries.fid AS node_galleries_fid, node_galleries.nid AS node_galleries_nid, node_galleries.is_cover AS node_galleries_is_cover FROM node node INNER JOIN node_galleries node_galleries ON node.nid = node_galleries.nid LIMIT 0, 10 in /home/winegrowers/lamorindawinegrowers.com/sites/all/modules/views/includes/view.inc on line 742.

Comments

bscanlin’s picture

Using Views 6.x-2.x-dev

wilson98’s picture

don't use distinct.

bscanlin’s picture

How do I remove distinct from the SQL? Is there a way to do that without changing the PHP code directly? Is there a different version of views that I should be using?

Here is the view that I'm trying to setup. My goal is to make a slideshow out of this view.

View settings
Tag: None
Basic settings
Name: Defaults
Title: None
Change settings for this styleStyle: Unformatted
Change settings for this styleRow style: Fields
Use AJAX: No
Use pager: No
Items to display: 10
More link: No
Distinct: No
Access: Unrestricted
Exposed form in block: No
Header: None
Footer: None
Empty text: None
Theme: Information
Relationships
None defined
RearrangeAddArguments
None defined
RearrangeAddFields
Node Gallery Image: Image Image
Sort criteria
None defined
RearrangeAddFilters
None defined

user warning: Table 'winegrowers.node_galleries' doesn't exist query: SELECT DISTINCT(node.nid) AS nid, node_galleries.fid AS node_galleries_fid, node_galleries.nid AS node_galleries_nid FROM node node INNER JOIN node_galleries node_galleries ON node.nid = node_galleries.nid LIMIT 0, 10 in /home/winegrowers/lamorindawinegrowers.com/sites/all/modules/views/includes/view.inc on line 742.

bscanlin’s picture

Status: Active » Closed (fixed)

Uninstalled module completely and reinstalled cleared problem.

millions’s picture

which module did you uninstall? views? node gallery?