I'm getting a very common error in our log files, while running Drupal 6.20:

"Invalid argument supplied for foreach() in .../views/plugins/views_plugin_query_default.inc on line 924."
Line 924 is
"foreach ($fields_array as $field) {"

Google was less than helpful with examples of similar problems. Any ideas on how to troubleshoot/attack this?

Comments

dawehner’s picture

This error happens if you don't have any visible/accessible field on a view, maybe check some of your views for that.

jsdadmin’s picture

Status: Active » Postponed
kars-t’s picture

Status: Postponed » Fixed

Hi

I am closing this issue to clean up the issue queue. Feel free to reopen the issue if there is new information and the problem still resides. If not please make sure you close your issues that you don't need any more.

Maybe you can get support from the local user group. Please take a look at this list at groups.drupal.org.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

vojnar’s picture

Status: Closed (fixed) » Active

Im getting the below error with views 6x 3.0.
The "accessible field" is a custom php field which has echo "this"; in it.
This field provided by: Views Custom Field 6.x-1.0

It runs perfect in views 6.2.
Very unfortunate. Not sure what to do, downgrade views?

Thanks

warning: Invalid argument supplied for foreach() in C:\wampserver\www\d6\modules\views\plugins\views_plugin_query_default.inc on line 924.
warning: Invalid argument supplied for foreach() in C:\wampserver\www\d6\modules\views\plugins\views_plugin_query_default.inc on line 1000.
warning: Invalid argument supplied for foreach() in C:\wampserver\www\d6\modules\views\plugins\views_plugin_query_default.inc on line 924.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node node ) count_alias' at line 2 query: SELECT COUNT(*) FROM (SELECT FROM node node ) count_alias in C:\wampserver\www\d6\modules\views\plugins\views_plugin_pager.inc on line 141.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node node LIMIT 0, 10' at line 2 query: SELECT FROM node node LIMIT 0, 10 in C:\wampserver\www\d6\modules\views\plugins\views_plugin_query_default.inc on line 1150.

Sorry it is views 3.0 without rc

(And Im admin, so it is not permission issue)

mustanggb’s picture

Issue summary: View changes
Status: Active » Closed (outdated)