Hi,

Update to Views 2.5, and my previously working view failed with a mysql syntax error. I put the entire error in the Views issue queue #437960: SQL error from missing table alias (".nid") after upgrading to 2.4 or 2.5, but the pertinent part seems related to VotingAPI, though I did not update that module. This has happened on two machines with similar setups.

The problem in the querey seems to be this segment:
LEFT JOIN votingapi_cache votingapi_cache_node_average ON .nid =

Before updating views, that segment was:
LEFT JOIN votingapi_cache votingapi_cache_node_average ON node_users.nid =

The "node_users.nid" was truncated to just ".nid".

Any idea what would cause this? I'm hoping someone here, or over at the Views queue, can shed some light on what could have made that change. I did just try the latest VotingAPI dev version, with no change.

Comments

gregarios’s picture

gregarios commented

I, too, am having this problem. If I try to use any VotingAPI Relationships MySQL starts throwing the errors.

daneyuleb’s picture

daneyuleb commented
Status: Active » Closed (fixed)

At least in my case it seems to be a problem with a change made in the Views query.inc file, updated with views 2.4. In the Views issue queue I posted a workaround--the links in my first post, above. Because the problem doesn't seem specific to Voting API based on others comments, I'm going to change the issue settings here to closed--may reopen it if the Views author ever determines if the problem is in Views or in the other modules that get referenced in the MySQL error.