To see views query in views 1, install the devel module and configure it to log and display queries for users with suitable permissions.
(hopefully you can do this on a backup site, and not necessarily the production site, since this can slow things down).
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
2009/6/23 Idan Arbel idan@arbel-designs.com
Anyway to see the views query in views 1? Also what php memory value should I increase ?
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *John Callahan *Sent:* ג 23 יוני 2009 16:47 *To:* support@drupal.org *Subject:* Re: [support] View stopped working....
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?
Checked by AVG - www.avg.com Version: 8.5.374 / Virus Database: 270.12.87/2195 - Release Date: 06/22/09 18:11:00
-- [ Drupal support list | http://lists.drupal.org/ ]