Closed (fixed)
Project:
Node Gallery
Version:
6.x-2.0-alpha7
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
10 Jun 2009 at 03:40 UTC
Updated:
30 Jan 2010 at 22:30 UTC
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
Comment #1
bscanlin commentedUsing Views 6.x-2.x-dev
Comment #2
wilson98 commenteddon't use distinct.
Comment #3
bscanlin commentedHow 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.
Comment #4
bscanlin commentedUninstalled module completely and reinstalled cleared problem.
Comment #5
millions commentedwhich module did you uninstall? views? node gallery?