After update from previous -dev to latest -dev and successful update 6011 I have no more views on site, blocks are gone and there errors are shown instead. Also all fields, relationships, arguments, filters are now 'Broken/missing handler: >'. I cannot add even basic node: title field.

* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 990.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
* 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 /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_pager.inc on line 142.
* 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 /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1134.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 990.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
* 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 /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1134.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 990.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
* 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 /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_pager.inc on line 142.
* 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 /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1134.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 990.
* warning: Invalid argument supplied for foreach() in /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
* 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 /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_pager.inc on line 142.
* 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 /home/.sites/143/site2/web/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1134.

Comments

boabjohn’s picture

Same here... just encountered now. Starting troubleshooting.

dawehner’s picture

Status: Active » Fixed

Damn. Reverted the patch. Please download the latest version.

Thanks for reporting!

jthomasbailey’s picture

Priority: Normal » Major
Status: Fixed » Active

Still broken.

dawehner’s picture

Status: Active » Fixed

No please download the cvs version if you need the most recent version.

boabjohn’s picture

Priority: Major » Normal
Status: Fixed » Active

Hey there dereine, much appreciated for the fast response...and apologies for my ignorance, but where in this string of commits can I grab a whole version of 3.x that does not have the error above?

http://drupal.org/project/cvs/38878

Thanks in advance...

cristian.stoica’s picture

Subscribing.

cristian.stoica’s picture

Updating to latest dev fixed the issue. However, got 2 warnings when executing update.php:

* warning: array_merge() [function.array-merge]: Argument #2 is not an array in /usr/home/.../drupal/update.php on line 174.
* warning: Invalid argument supplied for foreach() in /usr/home/.../drupal/update.php on line 338.

dawehner’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

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

remaye’s picture

Status: Closed (fixed) » Active

Sorry for the "up" but I got quite the same when I updated to latest views 6.x-3.x-dev version (downloaded January 2, 2011) except that the views themselves are working (no 'Broken/missing handler...') :

warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/nicolas-losson/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/nicolas-losson/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 990.
warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/nicolas-losson/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 914.
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 LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT' at line 2 query: SELECT FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid WHERE (node.type in ('fiche_projet')) AND ((term_data.name) = ('Pièces sonores')) LIMIT 0, 10 in /Applications/MAMP/htdocs/nicolas-losson/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1134.

In fact this due to the Custom_pager module (latest 6.x-1.x-dev version from 2010-Jul-11) that calls the views and doesn't work anymore.
I wonder if this is a Views issue or a Custom_pager issue ?
I already posted an issue for Custom_pager module (http://drupal.org/node/1012962) but the fact is that the Custom_pager was working great with my earlier 6.x-3.x-dev version of views ...

Is there any way to fix this in Views or Custom_pager modules ?
Thanks.

dawehner’s picture

Does views works fine without custom pagers... then this is a problem of custom pagers

remaye’s picture

Thanks Dereine for your quick response.
Yes views are working (with or without Custom_pager enable) and it is obviously Custom_pager that cause the warning messages.
But Custom_pager was working perfectly with previous version of 6.x-3.x-dev version.
So the question is :
is it intentional that Views changed its code causing Custom_pager (and possibly others modules using views) to not working anymore (and in this case Custom_pager sure has to adapt to it), or is it an unintentional side-effect that should be fixed in Views itself ?

Another thing is that Custom_pager has not been updated since July and I don't have answer on my post in Custom_pager issues : in case Custom_pager code should be corrected, do you have any tips on what has to be fixed within Custom_pager module to allow me to fix it myself ? (I'm not a Drupal coder expert and I couldn't figure out what Custom_pager part of code is involved...)

Thanks

achton’s picture

I am experiencing the same as #12 after updating Views to latest 6.x-3.x-dev. Views work independently, but I happen to use Panels which are unable to display the Views. I have not updated Panels/Ctools versions when this occurred.

I think it may also be what people are seeing in #1013398: Views panes are gone.

However, I have no error messages to go by, and everything seems to function normally, except that the frontend does not present any views, unless displayed stand-alone.

dawehner’s picture

@13
Please consider not posting on unrelated issues. Thanks

jamestombs’s picture

@14
It is not unrelated, I had exactly the same problem, the patch in comment 14 on #1013170: Views ctools integration broken because of issue with preview() fixed it for me and I had the same symptons.

dawehner’s picture

Please see the first report. Is this really the same?

jamestombs’s picture

@16 apologies, I thought I was replying to a different thread, had quite a few tabs open.

achton’s picture

@dereine, you are quite right, it is not the same as the original.
At the time, I thought it was related to the report in #10 and posted because this issue was reopened, but I see now that this is not the case, so I apologize. I think #1013170 is the master ticket for my issue.

summit’s picture

Subscribing, same issues.

    * 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 'LEFT JOIN rivs_node node_node ON node2.nid = node_node.nid ) count_alias' at line 8 query: SELECT COUNT(*) FROM (SELECT node.title AS node_title, node.nid AS nid, node_node.type AS node_node_type, node_node.nid AS node_node_nid, node_node.vid AS node_node_vid FROM rivs_node node LEFT JOIN rivs_content_ node2 ON node.nid = node2. LEFT JOIN rivs_node node_node ON node2.nid = node_node.nid ) count_alias in /sites/all/modules/views/plugins/views_plugin_pager.inc on line 142.
    * 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 'LEFT JOIN rivs_node node_node ON node2.nid = node_node.nid LIMIT 0, 10' at line 8 query: SELECT node.title AS node_title, node.nid AS nid, node_node.type AS node_node_type, node_node.nid AS node_node_nid, node_node.vid AS node_node_vid FROM rivs_node node LEFT JOIN rivs_content_ node2 ON node.nid = node2. LEFT JOIN rivs_node node_node ON node2.nid = node_node.nid LIMIT 0, 10 in /sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1134.

greetings, Martijn

henrijs.seso’s picture

Status: Active » Closed (fixed)

I am sorry Summit, I opened this issue and it was fixed very fast as shown in #2, it was small specific issue with updates. So this issue should be closed and you will have to open new one with new detailed report.

summit’s picture

A year later, this issue helped me: http://drupal.org/node/1369888#comment-5360454
greetings, Martijn