Hello,
I have a very strange problem on a live site, all views that display content types other than "page" return nothing.
The site has been working great for about a year, today I deleted a page node, change a filter in a view and change a filter in a block and then the client reported that none of the views work.
After checking and trying to fix, I can't get a view to return nodes that aren't "page".
I created a new view, with just one filter according to node type. Set it to just page, returns great. Set it to all except "page" and nothing.
What can cause this?
This is pretty urgent.
Thanks
Idan
* Idan Arbel [23/06/09 13:19]:
I created a new view, with just one filter according to node type. Set it to just page, returns great. Set it to all except "page" and nothing. What can cause this? This is pretty urgent.
Have you cleared the cache tables? Have you checked the logs to see if there are any php errors reported? Have you tried increasing the memory assigned to php in the server?
I've checked for errors in the log,nothing there, how do I clear the cache tables, although I'm pretty sure this isn't a cache issue, the system is quite responsive to change, just not fetching node types that aren’t page.
I'll have my host increase the memory for php.
Thanks
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Walter Garcia-Fontes Sent: ג 23 יוני 2009 14:42 To: support@drupal.org Subject: Re: [support] View stopped working....
* Idan Arbel [23/06/09 13:19]:
I created a new view, with just one filter according to node type. Set it
to
just page, returns great. Set it to all except "page" and nothing. What can cause this? This is pretty urgent.
Have you cleared the cache tables? Have you checked the logs to see if there are any php errors reported? Have you tried increasing the memory assigned to php in the server?
Since views manages its own cache, you might want to make sure it is cleared, along with Drupal internal caches.
This depends on what version of Drupal you are using.
In Drupal 5, you can visit admin/build/modules, or else install the devel module and avail yourself of its link to clear internal Drupal caches.
In Drupal 6, you can clear internal Drupal caches via an explicit button at the foot of Administer > Site configuration > Performance , and then go to Administer > Site building > Views > Tools and then hit the "Clear Views' Cache" button.
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
2009/6/23 Idan Arbel idan@arbel-designs.com
I've checked for errors in the log,nothing there, how do I clear the cache tables, although I'm pretty sure this isn't a cache issue, the system is quite responsive to change, just not fetching node types that aren’t page.
I'll have my host increase the memory for php.
Thanks
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Walter Garcia-Fontes Sent: ג 23 יוני 2009 14:42 To: support@drupal.org Subject: Re: [support] View stopped working....
- Idan Arbel [23/06/09 13:19]:
I created a new view, with just one filter according to node type. Set it
to
just page, returns great. Set it to all except "page" and nothing. What can cause this? This is pretty urgent.
Have you cleared the cache tables? Have you checked the logs to see if there are any php errors reported? Have you tried increasing the memory assigned to php in the server?
-- Walter Garcia-Fontes Barcelona -- [ Drupal support list | http://lists.drupal.org/ ] 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/ ]
Thanks
I'm running drupal 5 on this site, I cleared the cache and still the same.
What else can be done, what could cause this weird effect?
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Victor Kane Sent: ג 23 יוני 2009 14:59 To: support@drupal.org Subject: Re: [support] View stopped working....
Since views manages its own cache, you might want to make sure it is cleared, along with Drupal internal caches.
This depends on what version of Drupal you are using.
In Drupal 5, you can visit admin/build/modules, or else install the devel module and avail yourself of its link to clear internal Drupal caches.
In Drupal 6, you can clear internal Drupal caches via an explicit button at the foot of Administer > Site configuration > Performance , and then go to Administer > Site building > Views > Tools and then hit the "Clear Views' Cache" button.
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
2009/6/23 Idan Arbel idan@arbel-designs.com
I've checked for errors in the log,nothing there, how do I clear the cache tables, although I'm pretty sure this isn't a cache issue, the system is quite responsive to change, just not fetching node types that aren’t page.
I'll have my host increase the memory for php.
Thanks
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Walter Garcia-Fontes Sent: ג 23 יוני 2009 14:42 To: support@drupal.org Subject: Re: [support] View stopped working....
* Idan Arbel [23/06/09 13:19]:
I created a new view, with just one filter according to node type. Set it
to
just page, returns great. Set it to all except "page" and nothing. What can cause this? This is pretty urgent.
Have you cleared the cache tables? Have you checked the logs to see if there are any php errors reported? Have you tried increasing the memory assigned to php in the server?
-- Walter Garcia-Fontes Barcelona -- [ Drupal support list | http://lists.drupal.org/ ]
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/ ]
Checked by AVG - www.avg.com Version: 8.5.374 / Virus Database: 270.12.87/2195 - Release Date: 06/22/09 18:11:00
Might sound strange but did you try exporting then re-importing the view with a new name? I haven't done that with D5 before so I'm not sure of the steps.
- John
Idan Arbel wrote:
Thanks
I'm running drupal 5 on this site, I cleared the cache and still the same.
What else can be done, what could cause this weird effect?
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Victor Kane *Sent:* ג 23 יוני 2009 14:59 *To:* support@drupal.org *Subject:* Re: [support] View stopped working....
Since views manages its own cache, you might want to make sure it is cleared, along with Drupal internal caches.
This depends on what version of Drupal you are using.
In Drupal 5, you can visit admin/build/modules, or else install the devel module and avail yourself of its link to clear internal Drupal caches.
In Drupal 6, you can clear internal Drupal caches via an explicit button at the foot of Administer > Site configuration > Performance , and then go to Administer > Site building > Views > Tools and then hit the "Clear Views' Cache" button.
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
2009/6/23 Idan Arbel <idan@arbel-designs.com mailto:idan@arbel-designs.com>
I've checked for errors in the log,nothing there, how do I clear the cache tables, although I'm pretty sure this isn't a cache issue, the system is quite responsive to change, just not fetching node types that aren’t page.
I'll have my host increase the memory for php.
Thanks
-----Original Message----- From: support-bounces@drupal.org mailto:support-bounces@drupal.org [mailto:support-bounces@drupal.org mailto:support-bounces@drupal.org] On Behalf Of Walter Garcia-Fontes Sent: ג 23 יוני 2009 14:42 To: support@drupal.org mailto:support@drupal.org Subject: Re: [support] View stopped working....
- Idan Arbel [23/06/09 13:19]:
I created a new view, with just one filter according to node type.
Set it to
just page, returns great. Set it to all except "page" and nothing. What can cause this? This is pretty urgent.
Have you cleared the cache tables? Have you checked the logs to see if there are any php errors reported? Have you tried increasing the memory assigned to php in the server?
-- Walter Garcia-Fontes Barcelona -- [ Drupal support list | http://lists.drupal.org/ ]
Checked by AVG - www.avg.com http://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/ ]
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/ ]
Was the module cck somehow inadvertantly disabled?
Was a user (content author) deleted?
Are views and cck updated to the latest verstion?
When you go to Administer > Content management > Content and filter according to non-page content types, do you see your non-page content types?
When you go to Administer > Content management > Content types, are the non-page content types there?
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
On Tue, Jun 23, 2009 at 9:11 AM, Idan Arbel idan@arbel-designs.com wrote:
Thanks
I'm running drupal 5 on this site, I cleared the cache and still the same.
What else can be done, what could cause this weird effect?
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Victor Kane *Sent:* ג 23 יוני 2009 14:59
*To:* support@drupal.org *Subject:* Re: [support] View stopped working....
Since views manages its own cache, you might want to make sure it is cleared, along with Drupal internal caches.
This depends on what version of Drupal you are using.
In Drupal 5, you can visit admin/build/modules, or else install the devel module and avail yourself of its link to clear internal Drupal caches.
In Drupal 6, you can clear internal Drupal caches via an explicit button at the foot of Administer > Site configuration > Performance , and then go to Administer > Site building > Views > Tools and then hit the "Clear Views' Cache" button.
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
2009/6/23 Idan Arbel idan@arbel-designs.com
I've checked for errors in the log,nothing there, how do I clear the cache tables, although I'm pretty sure this isn't a cache issue, the system is quite responsive to change, just not fetching node types that aren’t page.
I'll have my host increase the memory for php.
Thanks
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Walter Garcia-Fontes Sent: ג 23 יוני 2009 14:42 To: support@drupal.org Subject: Re: [support] View stopped working....
- Idan Arbel [23/06/09 13:19]:
I created a new view, with just one filter according to node type. Set it
to
just page, returns great. Set it to all except "page" and nothing. What can cause this? This is pretty urgent.
Have you cleared the cache tables? Have you checked the logs to see if there are any php errors reported? Have you tried increasing the memory assigned to php in the server?
-- Walter Garcia-Fontes Barcelona -- [ Drupal support list | http://lists.drupal.org/ ]
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/ ]
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/ ]
Hi,
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
idan
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Victor Kane Sent: ג 23 יוני 2009 15:17 To: support@drupal.org Subject: Re: [support] View stopped working....
Was the module cck somehow inadvertantly disabled?
Was a user (content author) deleted?
Are views and cck updated to the latest verstion?
When you go to Administer > Content management > Content and filter according to non-page content types, do you see your non-page content types?
When you go to Administer > Content management > Content types, are the non-page content types there?
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
On Tue, Jun 23, 2009 at 9:11 AM, Idan Arbel idan@arbel-designs.com wrote:
Thanks
I'm running drupal 5 on this site, I cleared the cache and still the same.
What else can be done, what could cause this weird effect?
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Victor Kane Sent: ג 23 יוני 2009 14:59
To: support@drupal.org Subject: Re: [support] View stopped working....
Since views manages its own cache, you might want to make sure it is cleared, along with Drupal internal caches.
This depends on what version of Drupal you are using.
In Drupal 5, you can visit admin/build/modules, or else install the devel module and avail yourself of its link to clear internal Drupal caches.
In Drupal 6, you can clear internal Drupal caches via an explicit button at the foot of Administer > Site configuration > Performance , and then go to Administer > Site building > Views > Tools and then hit the "Clear Views' Cache" button.
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
2009/6/23 Idan Arbel idan@arbel-designs.com
I've checked for errors in the log,nothing there, how do I clear the cache tables, although I'm pretty sure this isn't a cache issue, the system is quite responsive to change, just not fetching node types that aren’t page.
I'll have my host increase the memory for php.
Thanks
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Walter Garcia-Fontes Sent: ג 23 יוני 2009 14:42 To: support@drupal.org Subject: Re: [support] View stopped working....
* Idan Arbel [23/06/09 13:19]:
I created a new view, with just one filter according to node type. Set it
to
just page, returns great. Set it to all except "page" and nothing. What can cause this? This is pretty urgent.
Have you cleared the cache tables? Have you checked the logs to see if there are any php errors reported? Have you tried increasing the memory assigned to php in the server?
-- Walter Garcia-Fontes Barcelona -- [ Drupal support list | http://lists.drupal.org/ ]
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/ ]
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/ ]
Checked by AVG - www.avg.com Version: 8.5.374 / Virus Database: 270.12.87/2195 - Release Date: 06/22/09 18:11:00
* 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?
No, no content permission or any permission module installed.
I'm also checking on user 1
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Walter Garcia-Fontes Sent: ג 23 יוני 2009 16:38 To: support@drupal.org Subject: Re: [support] View stopped working....
* 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?
Yes, I can access the non page nodes via content management, it filters according to the content type great, only views simply doesn't fetch any non page node.
What is user 0? I'm working from the administrator and check with a logged out user too.
Idan
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Fred Jones Sent: ג 23 יוני 2009 16:57 To: support@drupal.org Subject: Re: [support] View stopped working....
I'm also checking on user 1
and user 0 also! :) -- [ Drupal support list | http://lists.drupal.org/ ] Checked by AVG - www.avg.com Version: 8.5.374 / Virus Database: 270.12.87/2195 - Release Date: 06/22/09 18:11:00
I solved the problem, or at least found it. I have localizer installed, and language was set only for page elements, out of the blue it started filtering all content types without fall back, so if a language wasn’t set for a node then it didn't display it.
Thanks for the help everyone!
Idan
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Fred Jones Sent: ג 23 יוני 2009 16:57 To: support@drupal.org Subject: Re: [support] View stopped working....
I'm also checking on user 1
and user 0 also! :) -- [ Drupal support list | http://lists.drupal.org/ ] Checked by AVG - www.avg.com Version: 8.5.374 / Virus Database: 270.12.87/2195 - Release Date: 06/22/09 18:11:00
Good to hear! Please ignore my last email. :-)
- John
Idan Arbel wrote:
I solved the problem, or at least found it. I have localizer installed, and language was set only for page elements, out of the blue it started filtering all content types without fall back, so if a language wasn’t set for a node then it didn't display it.
Thanks for the help everyone!
Idan
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Fred Jones Sent: ג 23 יוני 2009 16:57 To: support@drupal.org Subject: Re: [support] View stopped working....
I'm also checking on user 1
and user 0 also! :)
[ Drupal support list | http://lists.drupal.org/ ] 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/ ]
I'm glad you solved your problem, but that's really difficult to understand, since one would think the same effect would be seen when viewing content in Adminster > content management > content.
2009/6/23 Idan Arbel idan@arbel-designs.com
I solved the problem, or at least found it. I have localizer installed, and language was set only for page elements, out of the blue it started filtering all content types without fall back, so if a language wasn’t set for a node then it didn't display it.
Thanks for the help everyone!
Idan
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Fred Jones Sent: ג 23 יוני 2009 16:57 To: support@drupal.org Subject: Re: [support] View stopped working....
I'm also checking on user 1
and user 0 also! :)
[ Drupal support list | http://lists.drupal.org/ ] 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/ ]
This is actually a "feature" to prevent content in wrong language from displaying to users of the other language, the real question is why did it start working now, I really didn't even come close to touching any feature from the localizer module when I edited the site.
Idan
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Victor Kane Sent: ג 23 יוני 2009 17:23 To: support@drupal.org Subject: Re: [support] View stopped working....
I'm glad you solved your problem, but that's really difficult to understand, since one would think the same effect would be seen when viewing content in Adminster > content management > content.
2009/6/23 Idan Arbel idan@arbel-designs.com
I solved the problem, or at least found it. I have localizer installed, and language was set only for page elements, out of the blue it started filtering all content types without fall back, so if a language wasn’t set for a node then it didn't display it.
Thanks for the help everyone!
Idan
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On
Behalf Of Fred Jones Sent: ג 23 יוני 2009 16:57 To: support@drupal.org Subject: Re: [support] View stopped working....
I'm also checking on user 1
and user 0 also! :) -- [ Drupal support list | http://lists.drupal.org/ ]
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/ ]
Checked by AVG - www.avg.com Version: 8.5.374 / Virus Database: 270.12.87/2195 - Release Date: 06/22/09 18:11:00
Well, it's great you got your site working again!
On Tue, Jun 23, 2009 at 11:26 AM, Idan Arbel idan@arbel-designs.com wrote:
This is actually a "feature" to prevent content in wrong language from displaying to users of the other language, the real question is why did it start working now, I really didn't even come close to touching any feature from the localizer module when I edited the site.
Idan
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Victor Kane *Sent:* ג 23 יוני 2009 17:23
*To:* support@drupal.org *Subject:* Re: [support] View stopped working....
I'm glad you solved your problem, but that's really difficult to understand, since one would think the same effect would be seen when viewing content in Adminster > content management > content.
2009/6/23 Idan Arbel idan@arbel-designs.com
I solved the problem, or at least found it. I have localizer installed, and language was set only for page elements, out of the blue it started filtering all content types without fall back, so if a language wasn’t set for a node then it didn't display it.
Thanks for the help everyone!
Idan
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On
Behalf Of Fred Jones Sent: ג 23 יוני 2009 16:57 To: support@drupal.org Subject: Re: [support] View stopped working....
I'm also checking on user 1
and user 0 also! :)
[ Drupal support list | http://lists.drupal.org/ ]
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/ ]
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/ ]
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?
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
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/ ]
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@udel.eduwrote:
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/ ]
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:
- 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)
- 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@udel.edu mailto:john.callahan@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 pageCould 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/ ]
* Idan Arbel [23/06/09 13:50]:
I've checked for errors in the log,nothing there, how do I clear the cache tables, although I'm pretty sure this isn't a cache issue, the system is quite responsive to change, just not fetching node types that aren’t page.
In Drupal 6 there is a button to clear the cache at:
admin/settings/performance
-
Fred Jones -
Idan Arbel -
John Callahan -
Victor Kane -
Walter Garcia-Fontes