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:
- 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)
- 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 mailto: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 pageCould 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/ ]