This issue seems to appear earlier last week in a 6.x-2.x-dev branch. It doesn't affect 6.x-2.7 though.

Repro:

10 Create a node-based view
20 Select "Style: Unformatted"
30 Select "Row style: Node"
40 Click "Preview"

The following error messages shows up (cleaned up for brevity):

warning: Invalid argument supplied for foreach() in [moduledir]\views\plugins\views_plugin_query_default.inc on line 944.
warning: Invalid argument supplied for foreach() in [moduledir]\views\plugins\views_plugin_query_default.inc on line 918.
warning: Invalid argument supplied for foreach() in [moduledir]\views\plugins\views_plugin_query_default.inc on line 944.
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "FROM" LINE 2: FROM drupal_node node ^ in [drupaldir]\includes\database.pgsql.inc on line 139.
user warning: query: SELECT FROM drupal_node node LIMIT 10 OFFSET 0 in [moduledir]\views\plugins\views_plugin_query_default.inc on line 1117.

Comments

dawehner’s picture

dawehner
Primary language German
commented

Just tagging.

dagmar’s picture

dagmar
Primary language Spanish
Location Argentina
commented
Status: Active » Closed (duplicate)

#629984: Node and Comment row styles needs to be sure nid/cid is in query before trying to use it

merlinofchaos’s picture

merlinofchaos commented

The duplicated should only affect the 3.x branch -- this should not affect the 2.x branch, though. Can you confirm that you have this issue in 2.x-dev?

esteewhy’s picture

esteewhy commented

@merlinofchaos

Yeah, sorry, this problem reveals in 3.x only. I've just double checked it for today's 2.x-dev -- it works okay. So if this one is really a duplication, then it must be definitely closed.

liam morland’s picture

liam morland
Primary language English
Location Ontario, CA 🇨🇦
commented
Issue tags: +PostgreSQL

Tagging