By rrroonn on

Hello,

I have been working on setting up a image gallery using views and used the tutorial posted on this site as the basis. However, when I view the results, the page is always empty.

I eventually worked out that the views module is not including custom content types in the output:
* My test content based on a custom "Image" content type was not appearing in "Recent Posts"
* "Recent Posts" was not showing another custom content type that I created that just had a title and body
* A custom view to provide a table view of all content also didn't include these types.

If I create custom content items, I can view those item without any problems, they just don't get included in any views (not even "tracker").

This leads me to conclude that the problem is with the views handling of custom content types.

I have looked at the User Access Control list and dont see any obvious problems - "access all views" and "node access content" is checked for all roles.

I have looked at "Access control" for the custom content types and "view" permission is available for all roles.

I have looked at the View access (via ?q=admin/build/views/mycustomview/edit) and the view is enabled for all roles.

I have the following non-standard modules installed:

abuse
acl
audio [disabled]
blogger
captch
cck
content_access
custom_pagers
fckeditor [disabled]
forum_access
gallery [disabled]
imageapi
imagecache
imagefield
legal
lineage
localizer
menu_per_role [disabled]
node_privacy_byrole [disabled]
notify [disabled]
panels
profile_privacy
smtp
sparkline
thickbox
tinymce
token
user_register_notify
user_status
user_suspend
views
views_bonus

Any help would be appreciated as I'm at the point of tearing my hair out and its bound to just be a simple little gotcha.

thanks vm

Ron

⋅ Categories: Drupal 5.x

Comments

catch’s picture

catch
he/him
Primary language English
commented

It looks like you're missing a setting somewhere in one of your many node access modules, or maybe some stale data in the node_access table. An easy way to check is if a user with "administer nodes" permission can see them in lists.

As a side note, you shouldn't be giving all roles 'access all views' permission - this is only to bypass access settings on individual views content.

You may also have node type filters set up in your views which haven't been updated for the new content types.

rrroonn’s picture

rrroonn commented

Thanks for the advice - much appreciated.

The admin user also doesn't see the nodes in 'Views'. Do you have any debugging tips?

I'm not 100% convinced that its an access problem though, as I can view the node directly, just not include them in 'Views'. I guess I could disable all the access modules (though I think I have done that already) - but I'm not convinced that by doing that I have totally removed their influence (eg updated record attributes).

Is there a debug module available that lists SQL output to/from the db? That might help to see if the appropriate query is being made.

--- MORE INVESTIGATION REVEALS: ---

I hacked the PHP code to log sql queries to a file and found the following query:

SELECT count(DISTINCT(node.nid)) 
FROM node node  
LEFT JOIN content_type_image node_data_field_image ON node.vid = node_data_field_image.vid   
LEFT JOIN localizernode loc 
ON loc.nid=node.nid 
LEFT JOIN(
	SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language 
	UNION SELECT 0 AS weight, CAST('de' AS CHAR(10)) AS language
    ) lanw 
ON lanw.language=loc.language 
LEFT JOIN (
	select pid, MIN(weight) AS minweight from localizernode loc2 
	LEFT JOIN (
		SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language 
		UNION SELECT 0 AS weight, CAST('de' AS CHAR(10)) AS language
		) lanw2  
	on lanw2.language=loc2.language group by pid
	) loc1 
ON loc.pid=loc1.pid  
WHERE (lanw.weight=loc1.minweight) AND ( (node.type IN ('image')) AND (node.status = '1') AND ('applylocalizer'='applylocalizer'))

All greek to me but it made me consider the localization as a suspect.

When I disabled the 'Localizer Views' module, all content was returned correctly - not sure why yet.

thanks again,

Ron