To see views query in views 1, install the devel module and configure it to log and display queries for users with suitable permissions.<br><br>(hopefully you can do this on a backup site, and not necessarily the production site, since this can slow things down).<br>
<br>Victor Kane<br><a href="http://awebfactory.com.ar">http://awebfactory.com.ar</a><br><a href="http://projectflowandtracker.com">http://projectflowandtracker.com</a><br><br><div class="gmail_quote">2009/6/23 Idan Arbel <span dir="ltr"><<a href="mailto:idan@arbel-designs.com">idan@arbel-designs.com</a>></span><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="white" link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Anyway to see the views query in views 1? Also what php memory
value should I increase ?</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p><b><span style="font-size: 10pt; color: windowtext;">From:</span></b><span style="font-size: 10pt; color: windowtext;"> <a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a>
[mailto:<a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a>] <b>On Behalf Of </b>John Callahan<br>
<b>Sent:</b> <span dir="rtl" lang="HE">ג</span><span dir="ltr"></span><span dir="ltr"></span> 23 <span dir="rtl" lang="HE">יוני</span><span dir="ltr"></span><span dir="ltr"></span> 2009 16:47<div class="im"><br>
<b>To:</b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a><br>
<b>Subject:</b> Re: [support] View stopped working....</div></span></p>
</div>
</div>
<p> </p>
<p>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>.</p><div><div></div><div class="h5"><br>
<br>
I would try to build up to the actual SQL statement that the View is
using. See where it breaks.<br>
<br>
- John<br>
<br>
<br>
Walter Garcia-Fontes wrote: </div></div><div><div></div><div class="h5">
<pre>* Idan Arbel [23/06/09 14:40]:</pre><pre> </pre>
<blockquote style="margin-top: 5pt; margin-bottom: 5pt;"><pre>No user was deleted, I'll updated the cck and views, and in content management</pre><pre>is see non page content types.</pre><pre>I tried changing the view, or creating a brand new view but still it doesn't</pre>
<pre>display in content other than page</pre><pre> </pre></blockquote>
<pre> </pre><pre>Could it be a permission problem? Do you have the content permission</pre><pre>module enabled?</pre><pre> </pre><pre> </pre>
</div></div><p><span style="font-size: 10pt; color: windowtext;">Checked
by AVG - <a href="http://www.avg.com" target="_blank">www.avg.com</a><div class="im"><br>
Version: 8.5.374 / Virus Database: 270.12.87/2195 - Release Date: 06/22/09
18:11:00</div></span><span style="color: windowtext;"></span></p>
</div>
</div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>