I just upgraded to rc3 and got this error. Ran db update, flushed cache, etc. I'm using Views Field Grouping Row Limit, Views PHP, and VBO, so maybe one of them is causing it. Going back to rc2.

'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'field_data_field_post_author.nid\' in \'on clause\''

in views_plugin_query_default->execute() (line 1386 of /home/admin/domains/hpfd7.altaruminstitute.net/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc).
Debug:

'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'field_data_field_post_author.nid\' in \'on clause\''

in views_plugin_query_default->execute() (line 1386 of /home/admin/domains/hpfd7.altaruminstitute.net/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc).

Comments

trgreen17’s picture

trgreen17 commented

Update: I think it's a problem with "Views Field Grouping Row Limit," cuz only the pages where I use that option show the error.

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Closed (duplicate)

Just a random duplicated issue: #1345132: SQLSTATE[42S22] error after updating views
I really doubt that you searched for a related issue first, sorry. Anyway just update to dev of references and everything will be fine.

trgreen17’s picture

trgreen17 commented

You're right, I didn't search - I just scanned the first couple pages. Sorry about that. And updating to dev of references did fix it. Thanks.

trgreen17’s picture

trgreen17 commented
Issue summary: View changes

fixed grammar