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 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 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 href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>