Here's the thing:

1. Idan says that when he goes to Adminster > Content management > Content he sees the nodes of his non-page content types that views doesn't show him.

(please confirm this once again, Idan)

2. He doesn't mention any errors he has seen, so we don't really know that views is breaking, or that the SQL is breaking.

Victor

On Tue, Jun 23, 2009 at 10:47 AM, John Callahan <john.callahan@udel.edu> wrote:
Can you perform an SQL query from the command line directly to the mysql database?  Use the database credentials as in the settings.php file.  Just try doing a basic SELECT statement on the node table using the WHERE clause to restrict on the content types you want.  If you can do that from the command line, try creating a PHP page on your site and perform the same query, of course using http://api.drupal.org/api/function/db_query.

I would try to build up to the actual SQL statement that the View is using.  See where it breaks.

- John



Walter Garcia-Fontes wrote: 
* Idan Arbel [23/06/09 14:40]:
  
No user was deleted, I'll updated the cck and views, and in content management
is see non page content types.
I tried changing the view, or creating a brand new view but still it doesn't
display in content other than page
    
Could it be a permission problem? Do you have the content permission
module enabled?

--
[ Drupal support list | http://lists.drupal.org/ ]