I have a view that has the following settings:

http://gist.github.com/460506

There are 6 image nodes. Yet only one of them--the fifth one!--is showing up in my view. What am I doing wrong?

Comments

merlinofchaos’s picture

merlinofchaos commented

Are the other 5 nodes unpublished? Is there a node_access module that is restricting access to the other 5 nodes?

Try running the query that the view Preview provides manually. What does it give you at a mysql prompt?

picardo’s picture

picardo commented

All nodes are published. There is no permission issue because I am editing as the admin user. Here is the query from the live preview.

SELECT node.nid AS nid,
node.title AS node_title,
node.type AS node_type,
image.fid AS image_fid,
image.image_size AS image_image_size
FROM node node
LEFT JOIN image image ON node.nid = image.nid
WHERE (node.status <> 0) AND (node.type in ('image'))

merlinofchaos’s picture

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

Try running the query that the view Preview provides manually. What does it give you at a mysql prompt?

picardo’s picture

picardo commented

Hehe. Sorry about that. Ok, I ran the command on phpmyadmin. And I got back a list of 20 records. It seems like all the right nodes.

http://dl.dropbox.com/u/285328/views.png

dawehner’s picture

dawehner
Primary language German
commented

Are you really sure you don"t have some kind of node access system or something similar?
There are some modules which uses hook_db_rewrite_sql

picardo’s picture

picardo commented

Positive. I am using Admin module which automatically enables all permissions for the users with administrator role. But I'm not sure if another module is interfering. Maybe you can figure out. This is a list of all the modules I have enabled.

404 Blocks
Admin
Admin Role
Administration interface for Nodewords
Administration menu
Attribute
Backup and Migrate
Basic meta tags
Better Permissions
Blog
Boost
Contact
Custom Error
Database logging
Devel
Fieldgroup
File Aliases
Filter Permissions
Flatrate
Google Analytics
Google Checkout
Image Attach
Image Import
Image assist
ImageAPI GD2
ImageAPI ImageMagick
ImageCache UI
ImageField
Libraries
Link
Module filter
ModuleInfo
Number
Option Widgets
PHP filter
Pathauto
PayPal
Poormanscron
Site verification meta tags
Statistics
Syslog
Taxonomy
Test Gateway
Text
Tokens for meta tags
U.S. Postal Service
UPS
Update status
Upload
User interface for Nodewords
Vertical Tabs
Views Slideshow: Imageflow
Views UI
Views exporter
Wysiwyg
jQuery Update

merlinofchaos’s picture

merlinofchaos commented

I'm not familiar with all of those, but I don't see any that should be interfering. That said, I'm not sure how the query could run and pull up 20 results and the same query, run by Views, only pulls up 1, without some module utilizing db_rewrite_sql or something to change the actual query that is run.

I'm out of ideas as to what else might cause a problem like this, too. More or less, once the query is built, Views just runs it, extracts results and displays them. You might try enabling query logging in devel.module, and seeing *exactly* what query was run, since Views reports the query prior to Drupal modifying it.

esmerel’s picture

esmerel commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

No updates for more than 30 days.