When trying to share arguments with two node reference cck fields, I get the following error (edited for clarity):

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 'LIMIT 0, 10' at line 20 query: SELECT node.nid AS nid, ... WHERE LIMIT 0, 10 in /public_html/sites/all/modules/views/includes/view.inc on line 755.

If I enter the same argument twice it works fine, with or without "Share Arguments" checked.

I have not checked with other field types or with any version of Views Or other than the 13 Aug 2009 snapshot.

Comments

OnlineWD™’s picture

OnlineWD™ commented

I'm seeing this error but share arguments is unchecked, think it must be caused by views update.

jsenich’s picture

jsenich commented

I'm running into the same issue. I have two cck nodereference field arguments that I want to use Views Or on. What appears to be happening is that the WHERE clause in the generated SQL query is completely blank unless you pass 2 arguments.

jsenich’s picture

jsenich commented

Actually, this seems to be a duplicate of #644174: Share arguments won't work, or rather, that is a duplicate of this issue. Anyway, the fix that I found there (http://drupal.org/node/644174#comment-3376744) seems to work.

scottrigby’s picture

scottrigby
he/him
Primary language English
Location Brooklyn, NY
commented
Status: Active » Closed (duplicate)