<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
True. By break, I meant what part is not working as expected: the
data, the SQL (View), or the display? <br>
<br>
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). <br>
<br>
Who knows, maybe it's a javascript/jQuery error that prevents the
display even though the query works??? I really don't know.<br>
<br>
- John<br>
<br>
<br>
<br>
Victor Kane wrote:
<blockquote
cite="mid:ff176450906230654m7ad45e07tac855a6de52a7cb2@mail.gmail.com"
type="cite">Here's the thing:<br>
<br>
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.<br>
<br>
(please confirm this once again, Idan)<br>
<br>
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.<br>
<br>
Victor<br>
<br>
<div class="gmail_quote">On Tue, Jun 23, 2009 at 10:47 AM, John
Callahan <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:john.callahan@udel.edu">john.callahan@udel.edu</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
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
<a moz-do-not-send="true"
href="http://api.drupal.org/api/function/db_query" target="_blank">http://api.drupal.org/api/function/db_query</a>.<br>
<br>
I would try to build up to the actual SQL statement that the View is
using. See where it breaks.<br>
<font color="#888888"><br>
- John</font>
<div class="im"><br>
<br>
<br>
Walter Garcia-Fontes wrote:
<blockquote type="cite">
<pre>* Idan Arbel [23/06/09 14:40]:
</pre>
<blockquote type="cite">
<pre>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
</pre>
</blockquote>
<pre>Could it be a permission problem? Do you have the content permission
module enabled?
</pre>
</blockquote>
</div>
</div>
<br>
--<br>
[ Drupal support list | <a moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</blockquote>
</div>
<br>
<pre wrap="">
<hr size="4" width="90%">
--
[ Drupal support list | <a class="moz-txt-link-freetext" href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</pre>
</blockquote>
</body>
</html>