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
Comment #1
dawehnerThis error happens if you don't have any visible/accessible field on a view, maybe check some of your views for that.
Comment #2
jsdadmin commentedComment #3
kars-t commentedHi
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.
Comment #5
vojnar commentedIm 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)
Comment #6
mustanggb commented