True. By break, I meant what part is not working as expected: the data, the SQL (View), or the display?

Is it true that a primary difference here between the Content page and a View is that the view does a join to one of the CCK tables? If so, I would check that the data tables still behave well; try selects on those individual CCK tables as well as joins using node/cck tables. If they work, you feel pretty good about your data. I would then start looking at things that Views add over plain SQL, like access permissions and maybe display (already discussed cache).

Who knows, maybe it's a javascript/jQuery error that prevents the display even though the query works??? I really don't know.

- John

Victor Kane wrote:

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/ ]
--
[ Drupal support list | http://lists.drupal.org/ ]