[support] View stopped working....

[John Callahan]

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 at udel.edu <mailto:john.callahan at 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/ ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090623/76474eda/attachment.htm>